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

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

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_2

Step: 3

blur-text-image_3

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

Moving Objects Databases

Authors: Ralf Hartmut Güting, Markus Schneider

1st Edition

0120887991, 978-0120887996

More Books

Students also viewed these Databases questions