Scenario You have recently been appointed as database designer for Plug-Ins Electronic. Plug Ins is an electronics shop that sells a variety of electronic items It is located in Mankhool, Dubai, UAE....

Please help me with these questions atleast the first part
Scenario<br>You have recently been appointed as database designer for Plug-Ins Electronic.<br>Plug Ins is an electronics shop that sells a variety of electronic items It is located in<br>Mankhool, Dubai, UAE. It is a family firm that has been in existence for 7 years and<br>selling their products to customers in the local area. The business has been doing<br>well and until now it has recorded sales and customer information manually by hand.<br>However, the sales are increasing, and the owner now needs to start tracking details<br>about the customer orders. staff products, deals and suppliers. The awner of Plug<br>Ins has asked you to design a relational database that will store and record the<br>business information,<br>

Extracted text: Scenario You have recently been appointed as database designer for Plug-Ins Electronic. Plug Ins is an electronics shop that sells a variety of electronic items It is located in Mankhool, Dubai, UAE. It is a family firm that has been in existence for 7 years and selling their products to customers in the local area. The business has been doing well and until now it has recorded sales and customer information manually by hand. However, the sales are increasing, and the owner now needs to start tracking details about the customer orders. staff products, deals and suppliers. The awner of Plug Ins has asked you to design a relational database that will store and record the business information,
Task 2<br>Using the scenario, produce Design Documentation for Plug-Ins Electronics. Your<br>database design documentation should incllude:<br>2.a) Entity Relationship Diagram and Data dictionaries for each of the tables you<br>feel should be created in the database.<br>2.b) Normalisation upto 3 NF of each table of Plug-Ins Electronics database.<br>

Extracted text: Task 2 Using the scenario, produce Design Documentation for Plug-Ins Electronics. Your database design documentation should incllude: 2.a) Entity Relationship Diagram and Data dictionaries for each of the tables you feel should be created in the database. 2.b) Normalisation upto 3 NF of each table of Plug-Ins Electronics database.

Jun 09, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here