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,

database management need some help database management need some help Given the following client business rules: 1)

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

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 Databases Questions!