Question
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
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, E_FName, 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started