Draw an ER model according to the above business rules.

1.2. Now that the CEO knows that you are an expert with ERDs, he wants you to review and ERD that an intern created for another project. Below is the ERD and the business rules used to create it. Which 10 changes would you propose should be made to the ERD to improve its quality, so that it can be successfully implemented in a relational database. NOTE: You must redraw the ERD and show the changes on the new ERD. A list of changes will not be marked.

Answer the above 2 questions according to the information given below.

One of the leading groups of high?tech manufacturing companies 'CEO has approached you about a project they are currently working on. They design and manufacture games, consoles, laptops, movie projectors and many other consumer gadgets. She has approached you to advise her about how to collect, store and process data for the group's new carbon accounting project code?named DB Green. The CEO has put much thought into the data she wants to store in the carbon accounting database. She has also spoken to her IT management team to get their input. Between them, they have come up with a set of business rules to be used as the basis for the data model design

DBGreen Project -Business Rules

1.A single database will be created that will track the carbon footprint soft all the companies within the group.

2.All tables in the database must have primary keys.

3.Each company has a name and consists of one or more departments.

4.Each company has one employee that is the CEO of the company. That employee may only be the CEO of one company, and not all employees are CEOs.

5.Each department must have exactly one employee who is the Green Champion -the person responsible for any initiatives related to the carbon footprint of the department. That employee may only be the Green Champion for a single department, and not all employees are Green Champions.

6.The following data must be recorded for each employee: name and surname.

7.Some departments have products that they are responsible for. Each product must be allocated to exactly one department and must have a description.

8.The main purpose of the database is to record carbon transactions. Each carbon transaction is accounted for by exactly one department. Optionally, the single product that the carbon transaction relates to can also be recorded.

9.The following data must be recorded for each carbon transaction: date and value.

NOTE: Use a word or any website to produce the diagrams. Dont use handwriting. You mustredraw the ERD and show the changes on the new ERD.

Transcribed Image Text:

Business Rules 1. All tables in the database must have surrogate primary keys. 2. A product consists of one or more parts. Not all parts captured in the system are part of a product yet, and a part can be used in many products. Each part is supplied by at least one supplier, but multiple suppliers could potentially supply the same part. 4. The following information must be stored for each product: description. 3. Product Product ID (PK) Name Producer Address Figure 1: ERD drawn by an Intern contained in Supplies Product ID (FK) Part ID (FK) Part Part ID(PK) Supplier ID (FK) Description Business Rules 1. All tables in the database must have surrogate primary keys. 2. A product consists of one or more parts. Not all parts captured in the system are part of a product yet, and a part can be used in many products. Each part is supplied by at least one supplier, but multiple suppliers could potentially supply the same part. 4. The following information must be stored for each product: description. 3. Product Product ID (PK) Name Producer Address Figure 1: ERD drawn by an Intern contained in Supplies Product ID (FK) Part ID (FK) Part Part ID(PK) Supplier ID (FK) Description