Attributes employees include employee identifier and employee
1. (20 points – 5 points each)
Construct an E-R diagram (ERD) for each of the following “real-world” scenarios. Assume no additional constraints, other than those which are explicitly stated, hold in each case.
Every professor teaches exactly one course (no more, no less) and every course must be taught by some professor.
2. (15 points – 5 points each)
3. (25 points)
You’ve been hired by a law firm to construct a database based upon the following business rules. Create an ERD that accurately depicts this situation. Clearly state any assumptions you made.
A CLIENT may have more than one CASE.
Attributes of CASE are Case_ID, Case_Description, and Case_Type.
Attribtues of JUDGE are Judge_ID, Name and Years_In_Practice.
Each JUDGE is assigned to exactly one court.
For each sales office, there is always one employee assigned to manage that office. An employee may manage only the sales office to which they are assigned.
The firm lists property for sale. Attributes of property include Property_ID (identifier) and Location. Components of Location include Address, City, State, and Zipcode.
Customers place orders through a branch.
Kristi would like to like to track the following about customers: Name, Address, City, State, Zipcode, Telephone, Date of Birth, Primary Language.
A branch may have many customers.
The following information about each branch needs to be recorded: Branch number, Location (consisting of Address, City, State, Zipcode), Square footage.
Kristi wants to record the following information about each item: Description, Color, Size, Pattern, Type.
An item can be composed of multiple items: for example, a dining room wall covering set (item 20) may consist of wallpaper (item 22) and borders (item 23).
Employees may have more than one skill.
