Question
briefly describe the entities and relationships between the entities.
briefly describe the entities and relationships between the entities.
example
The Student fills one Seat (1:1), The Seat fills one Student(1:1)
The Student takes one or many Course(1:M), The Course takes one or many Student. (1:M)
The Instuctor teaches one or many Course(1:M), The Course has one Instructor(1:1)
The Course has one or many Class(1:M), The Class has one Course(1:1)
The Class has one Section(1:1), The Section has one or many Class(1:M)
The Professor teaches zero to many Section(M:1), The Section has one Professor(1:1)
Mark_Id(Long) MARKS Student_Id(Long) FK:FR_6 SUBJECTS PK:PK_Marks Subject_Id(Long) Title(Text) Subject_Id(Long) FK:FR_5 Date(TimeStamp) Mark(Integer) STUDENTS Student_Id(Long) FirstName(Text) PK:PK_Students PK:PK_Subjects TEACHERS Teacher_Id(Long) PK:PK_Teachers FirstName(Text) SUBJ_TEACH LastName(Text) LastName(Text) ST_Id(Long) PK:PK Subj_Teach Group_Id(Long) FK:FR_4 Subject_Id(Long) FK:FR_3 Teacher_Id(Long) FK:FR_2 Group_Id(Long) FK:FR_1 GROUPS Group_Id(Long) PK:PK_Groups HI Name(Text)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started