Related questions
Question
using this example contruct Database relationship chart for a Gym/Fitness
Transcribed Image Text:Entity Relationship Diagram
SEX
SALARY
SUPERVISOR
FNAME
FNAME
●
●
NAME
●
(1,1)
SUPERVISED
BY
STAFF
MINIT
NAME
MINIT
(1,N)
SCHEDULE DOB
SUPERVISOR ID
LNAME
PROGRAMS
PROGRAM TYPE
SSN
LNAME
(0,N)
STAFF ID
PHONE
d
ADDRESS
Assumptions:
REGISTER
FOR
START TIME
END TIME
DAY
PROGRAM ID
(1,N)
YEARS
10
TEACHER
COMMUTER TYPE
HOMEROOM
TEACHER (1,1)
VETERANS
ELEMENTARY SCHOOL
(0,1)
TEAM
LEAD OF
(1,N)
(1,1)
BELONGS
ΤΟ
ROOM NO
(1,N)
STUDENT
(N,M)
ENROLLED IN
(1,1)
GRADE
(1,N)
(1,1)
CONTAINS
CLASSROOMS
(1,N)
TEACHES
(1,1)
SEX
NAME
FNAME
(1,N) ROOM NO
STUDENT ID
ADDRESS
MINIT
GUARDIAN
LNAME
(1,1)
SUPERVISES
(1,N)
COURSE ID
GRADE_ID COURSES
(1,N)
(1,N)
COURSE
NAME
GUARDIAN ID
NAME
PHONE#
SCORE RECORD
FNAME
MINIT
LNAME
SUBJECT
LEVEL
REPORT_TYPE
*********
Each Program needs at least one student.
Each Guardian may have many students.
Each Supervisor can supervise many Programs given that the programs are run on
different day or time.
Expert Solution
arrow_forward
Step 1: Introduction
Entity Relationship diagram is a logical diagram that contains mainly three components that are Entities, Attributes and Relationships. Entities are represented using Rectangle, attributes are represented using Oval and relationships are represented using Rhombus.
Step by stepSolved in 3 steps with 1 images
Knowledge Booster
Similar questions
- The database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. Each question is worth 2 marks. NOTE: You can use the symbolss, P, etc., or the words’ PROJECT’, ‘RESTRICT’etc.as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the first and last names of Customers who come from the City named Perth. List the first and last names of customers who had…arrow_forwardThe database used for this question is a very simple one with the following schema: (Primary keys are bold, foreign keys are underlined) CUSTOMER (CustID, FirstName, LastName, City, Phone, Email) INVOICE (InvoiceNumber, CustID, Date) INVOICE_ITEM(InvoiceNumber, ItemNumber, Quantity) ITEM (ItemNumber, ItemName, UnitPrice) When a customer makes a purchase, an invoice is created. The invoice may be for many items. For example, in a single purchase, a customer might buy 10 Back Scratchers, 4 Hair Removers and a Dog Lead. Provide relational algebra (NOT SQL) queries to find the following information. NOTE: You can use the symbols s, P, etc., or the words’ PROJECT’, ‘RESTRICT’ etc. as you prefer. You do not need to try to make efficient queries – just correct ones. Where you use a join, always show the join condition. List the dates on which Homer Griffin made purchases. List the first and last names of customers who have bought “Back Scratcher” or “Hair Remover” List the first…arrow_forwardE-R diagrams or DBDL may show database structure. Why do you prefer this method?arrow_forward
- Topic: Database Design and Entity Relationship Diagrams Please convert the following diagram to Crow's Foot notation.arrow_forwardT. Relational Model Instructions This assignment will show that you understand how columns should be separated between tables in a properly structured relational database. Your objective: Imagine you need to design a database that tracks members, type of membership, and exercise routines for each member. • Build a relational database model with multiple tables • Use your imagination and feel free to create the tables with as many columns as you would like. • Highest points will be awarded for completeness AND correctness. Submit as an Excel workbook or image.arrow_forwardQuestion A city college would like to maintain their academic information in a MySql database system. The following are the interested information: Courses: Catalog # (M170 for instance) Credit Hours; Name of the Course (Database Design Fundamentals for instance) Course Descriptions Prerequisite Components (Lecture, or Laboratory for instance) Classes: Class # Class Name (usually the course name, M 170 for instance) Start Date End Date Meeting time (9:30 am ~ 12:15 pm, for instance) Days in a week (Monday) Term (Spring 2018, for instance) Location (TIE Building for instance) Room (UB 301, for instance) Instructor Online status (online, or in-person) Faculty: Employee Id (001880301, for instance) First Name Last Name Title (professor, for instance) Email Phone Office Location (TIE building, for instance) Room (UB303, for instance) Student: Student ID First Name Last Name Plan Sub Plan Advisor Current GPA Grade of each course The Term you got the grade for a course. The class…arrow_forward
- Don't copy again and again that is wrong. Please help me with this question.arrow_forwardDatabase design diagrams (DBDL) and entity-relationship (E-R) diagrams (ER) are both valid ways to depict a database's structure. For what reasons do you choose one tactic over another?arrow_forwardFor the purpose of illustrating the structure of a database, either an E-R diagram or DBDL may be used. If that's the case, which strategy do you favor, and why?arrow_forward
arrow_back_ios
arrow_forward_ios