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 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
Get step-by-step solutions from verified subject matter experts
