Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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 10 points

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions