Using the scenario, produce Design Documentation for Plug-Ins Electronics. Your database design documentation should incllude:. 2.a) Entity Reilationship Diagram and Data dictionaries for each of the tables you feel should be created in the database.
Using the scenario, produce Design Documentation for Plug-Ins Electronics. Your database design documentation should incllude:. 2.a) Entity Reilationship Diagram and Data dictionaries for each of the tables you feel should be created in the database.
Principles of Information Systems (MindTap Course List)
13th Edition
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Ralph Stair, George Reynolds
Chapter5: Database Systems And Big Data
Section5.4: Big Data
Problem 2RQ: Telefonica Brasil is one of the largest telecommunications companies in Brazil, and it provides...
Related questions
Question
The er diagram should include customer, orders, staff,products, deals and suppliers.
![Task 2
Using the scenario, produce Design Documentation for Plug-Ins Electronics. Your
database design documentation should include:
2.a) Entity Reiationship Diagram and Data dictionaries for each of the tables you
feel should be created in the database.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0116cd0c-ab34-4b62-8d03-4e78af88ccd9%2Ff76922c3-7a9d-443f-b296-3f6fb24831eb%2F7wghorq_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Task 2
Using the scenario, produce Design Documentation for Plug-Ins Electronics. Your
database design documentation should include:
2.a) Entity Reiationship Diagram and Data dictionaries for each of the tables you
feel should be created in the database.
![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, Dubal, UAE. It is a family firm that has been in exXistence 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 andoustomer 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 owner of Plug
Ins has asked you to design a relational database that will store and record the
business information,](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0116cd0c-ab34-4b62-8d03-4e78af88ccd9%2Ff76922c3-7a9d-443f-b296-3f6fb24831eb%2Fyvtladi_processed.jpeg&w=3840&q=75)
Transcribed Image Text: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, Dubal, UAE. It is a family firm that has been in exXistence 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 andoustomer 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 owner of Plug
Ins has asked you to design a relational database that will store and record the
business information,
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 1 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781305971776/9781305971776_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781305971776
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
![Principles of Information Systems (MindTap Course…](https://www.bartleby.com/isbn_cover_images/9781285867168/9781285867168_smallCoverImage.gif)
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)