Question: o Design a Relational Data Model for the following ER model of a Faculty/Student database StudID StudName FaclD FacN Faculty Advisor Student teaches takes Course

o Design a Relational Data Model for the following ER model of a Faculty/Student database StudID StudName FaclD FacN Faculty Advisor Student teaches takes Course CourseNo CourseName Comments on the ER-diagram: -The Faculty entity represent the faculties of the university - The Student entity represent the students of the university - The Course entity represent the courses of the university - The key in each entity is underlined with a solid line The Advivor relationship represents the faculty-student advising relationship The teaches relationship represents the teaching duties of faculties The takes relationship represents the course enrollment of students - - - Your relational model answer must satisfy the following requirements: . Use the smallest possible number of relations Attributes in relations must not have NULL values Exception If avoiding NULL values will require creating a new relation, the attribute is allowed to have NULLs .Underline the primary key of each relation For every foreign key in the relational model - Draw an arrow from the foreign key to the relation that the foreign key is "pointing to" (i.e., it's "home relation")
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
