Scenario You have recently been appointed as database designer for Plug-Ins Electronics. 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

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
Please help me with these questions atleast the first part
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,
Transcribed Image 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
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.
Transcribed Image 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.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY