Question: Question : Relational Database 1. At KPU, a professor teaches one or more classes, and same course may be taught by one or more professors.

Question : Relational Database 1. At KPU, a
Question : Relational Database 1. At KPU, a professor teaches one or more classes, and same course may be taught by one or more professors. A professor is associated with professor's ID and professor's name. A class is associated with unique class code, section number, and location. a. Draw a complete E-R diagram to represent the relationship between PROFESSOR and CLASS, indicating cardinality. b. Model the E-R diagram in (a) above into a set of relations which can be implemented in a data base. Make up a primary key when needed and one or more non-key attributes for each entity. Express the structure of the relations with shorthand notations where the name of relations is followed (in parenthesis) by the names of the attributes in the relation. For example, you would express Employee Table as: Employee (Emp Id Name, dept, salary)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!