Question: Practical Assignment. Build an ERD (25 points), map it to the logical model (15 points), write CREATE TABLE statements (10 points): 1. The IT department

 Practical Assignment. Build an ERD (25 points), map it to the

Practical Assignment. Build an ERD (25 points), map it to the logical model (15 points), write CREATE TABLE statements (10 points): 1. The IT department of a company wants to keep information about its products in a database. For each product we keep Product Number, Name, and Description; a product can have more than one Description. Also, we need to keep in the database the date of the most recent modification of the product and the latest price. One of the employees of the IT department is assigned as a person in charge of a product. One employee can be in charge of several products, or may not be in charge of any product. Employees have ID, Name and Phone. Employees develop products using different technologies. For a technology we need to know the name and the release number. An employee can develop more than one product using more than one technology; the same technology can be used in development of multiple products. We need to know which employees worked on which products and which technologies were used for this

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!