Green Field county stadium is planning to conduct a cricket match between two teams A and B. A large crowd is expected in the st
2 answers:
You might be interested in
Answer:
See explaination
Explanation:
Clearly the entities are as follows:-
Course
Section
Room
Test
The relationship among entities are as follows:-
Course has Section
Test is conducted for Course
Test is conducted in Section
Test is conducted in Room
Attributes of each entities are as follows:-
Course (CourseID, Name, Department)
Section (SectionID, Enrollment)
Room (RoomNumber, Capacity, Building)
Test (Time)
Section is a week entity as, there may be same sections for different courses, therefore section uses the primary key of course entity as foreign key.
Also entity Test is dependent upon the entities Room,Section and Course, therefore primary keys of these entities will be used as foreign key in the Test entity.
Check attachment for the ER diagram
