using this example contruct  Database relationship chart for a Gym/Fitness

icon
Related questions
Question

using this example contruct  Database relationship chart for a Gym/Fitness 

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.
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
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer