Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

briefly describe the entities and relationships between the entities.


Screen Shot 2023-03-01 at 12.16.04 AM.png 

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurship

Authors: Andrew Zacharakis, William D Bygrave

5th Edition

1119563097, 9781119563099

More Books

Students also viewed these Databases questions