Answer the questions considering the following case - Best-East University is at present in need of a database for their student course advising. Courses are offered to the students and students choose the course and section. After the approval of course registration, a faculty and classroom are assigned to the course. In addition to the faculty, a Teacher Assistant (TA) is assigned for a section also. For a lab course, a Lab Instructor (LI) is also assigned. A faculty, TA, or LI may take many courses. A student may take up to five courses. (a) Find appropriate database relation schemas with appropriate attributes. (b) Find Primary and Foreign Keys for all relations (tables). (c) Draw an Entity-Relationship (ER) diagram showing relation relationships.
Answer the questions considering the following case -
Best-East University is at present in need of a
offered to the students and students choose the course and section. After the approval of course registration,
a faculty and classroom are assigned to the course. In addition to the faculty, a Teacher Assistant (TA) is
assigned for a section also. For a lab course, a Lab Instructor (LI) is also assigned. A faculty, TA, or LI may
take many courses. A student may take up to five courses.
(a) Find appropriate database relation schemas with appropriate attributes.
(b) Find Primary and Foreign Keys for all relations (tables).
(c) Draw an Entity-Relationship (ER) diagram showing relation relationships.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
