Question: database management need some help Given the following client business rules: 1) Melville metal works operates in many regions (region has attributes: RID, R Description,
Given the following client business rules: 1) Melville metal works operates in many regions (region has attributes: RID, R Description, R_Location) of the country 2) One or more stores may be store has the attributes: SID. S_ Name, S_Sales, S Location) located in each region 3) Each store has many employees (employee has the attributes:EID, E_LName, EFName, E_Title, E DOB, E Emall) 4) An employee may work for many stores 5) An employee may own one or more cars car has the attributes: CAR VIN, C_Make, C Model, c_Year, C_Color) A) Draw an ERD using the UML notation representing the above business rules 10 points B) Convert the ERD in A) into a relational diagram in UML notation 10 points
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
