The er diagram should include customer, orders, staff,products, deals and suppliers. Task 2Using the scenario, produce Design Documentation for Plug-Ins Electronics. Yourdatabase design documentation should include:2.a) Entity Reiationship Diagram and Data dictionaries for each of the tables youfeel should be created in the database. ScenarioYou 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 inMankhool, Dubal, UAE. It is a family firm that has been in exXistence for 7 years andselling their products to customers in the local area. The business has been doingwell 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 detailsabout the customer, orders, staff, products, deals and suppliers. The owner of PlugIns has asked you to design a relational database that will store and record thebusiness information,

ER Diagram abbrivation for Entity Relationship Diagram, also known as ERD is a databse diagram…

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.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Create a detailed use case diagram for boarding house finder website

A: use case diagram for boarding house finder website

Q: Please answer in 3-5 sentences. Thank you. Project Title: Web-Based Alumni Record System School…

A: Online Alumni system - Every year students graduate from the colleges and become alumni of that…

Q: Specify the business approach you intend to take.

A: StrategyYour company strategy is crucial. Business plan templates help you develop a plan fast and…

Q: Explain Basic concepts and definitions in relationships?

A: Given: Explain Basic concepts and definitions in relationships?

Q: Jersey athletics has decided to put a periodic survey on their website to engage more users in brand…

A: The question asks for a summary of the Entity-Relationship Diagram (ERD) using the Crow's Foot…

Q: Explain the concept of traceability in requirement analysis and its role in ensuring requirements…

A: The capacity to track an object as it goes through a process is known as traceability.It refers to…

Q: Describe the CIO's responsibilitie

A: Actually, CIO for Chief information Officer. With the growing significance of information technology…

Q: In CRC based design, a CRC Team consists of : (a) one or two users representatives (b) All (c)…

A: Given question is based on CRC design.

Q: List all the different types of characteristics used in the ER model.

A: Here is your solution -

Q: Please combine 2 of this sequence diagram and form a one sequence diagram.

A: There are two processes depicted in the sequence diagrams, these are:- Sequence Diagram 1:…

Q: See attached photo, help me to make the sequence diagram (on the left) clear and easy to understand.…

A: Answer : Sequence Diagram : 1) Sequence Diagram belongs to Interaction diagram of UML family. 2)…

Q: What Are the Users' Responsibilities During the Requirements Phase?

A: The main Users' Responsibilities During the Requirements Phase are :-

Q: What Are the Users' Responsibilities During the Requirements Phase?

A: Introduction: The requirements phase defines the functionality, performance criteria, and other…

Q: Explain the concept of traceability in requirement analysis and how it helps in ensuring that all…

A: Traceability in requirement analysis is a fundamental concept and practice that ensures that all…

Q: Choose one BUC and sketch an activity diagram. Your activity diagram must be consistent with the BUC…

A: An activity diagram is basically a flowchart that shows the flow from one activity to another.…

Q: Briefly explain change models.

A: The change model helps to identify potential areas of resistance and implement strategies designed…

Q: The main idea and purpose of MODAF Strategical point of view.

A: MODAF (Ministry of Defense Architectural Framework) is a design framework that establishes a…

Q: For example, how does multiple fact taBles work in practice?

A: GIVEN: For example, how do multiple fact taBles work in practice?

Q: Store Monthly Inventory Report Franchise Owner Owner Credentials Arrive Items Requirement Retailer…

A: Inventory management is related to business management . Inventory means stock of goods like raw…

Q: Characterize the degree and the cardinalities of the relationship that connects Customer to itself.…

A: The "family member" relationship connects the customer to itself and it has a degree 1.

Q: There is no Level 1 DFD for the activity Approving Supplier Invoices. If you were to draw one, what…

A: Data-flow diagrams (DFDs) represent a view of the system that is most easily understood by users:…

Q: When a prospective student wants to obtain more information about an educational institution and the…

A: Given: When a prospective student wants to obtain more information about an educational…

Q: To be deemed complete, a report must include all of the information included in the records of the…

A: The record source of a report is used for determining which fields from your database can be…

Q: Data Flow Diagram (Level O Diagram) D2 ProdList Customer Record Store Staff Customer Info D1…

A: The process is explained as below in steps: 1. The customer provides customer info which is recorded…

Q: Name of Supplier: ISBN Number of Supplier: Title Publisher Date of Supply 04 PROVIDER Provider oook…

A: Multi-valued attributes may have several values for an entity collection. Author and Contact Number…

Q: A potential customer or “prospect” is first identified as sales lead Select one: True False

A: Prospecting is the process of maintaining potential customers for a product or service, it is the…

Q: When compared to a product breakdown structure, a work breakdown structure has a number of…

A: The fundamental contrast between PBS and WBS is that the product management framework includes the…

Q: Draw a activity Diagram: Actors Use Cases Use Case Description Customer Login Tesco appointment…

A: The given problem has a use case description to bool an appointment in Tesco Appointment Website.…

Q: How important the significance of study section in the research?

A: Significance of the study is written so that the reader know the importance of study. It is the…

Q: 5 functional requirement for salesperson who place orders on behalf of customers and check their…

A: FUNCTIONAL REQUIREMENTS: Functional requirements are the functions which are used to define various…

Q: did not resolve the relationships between th entities (conference, delegation,event,…

A: Here given the entities so i take one by one and write the relationship between:…

Q: Store Staff Sales Update Product Data Report Customer Customer Info Order Inventory Report Payment…

A: Here we have given with a data flow diagram.The explanation for this diagram is as follows.

Q: Refer to this entity-relationship diagram. SALES PRODUCT PK Salesperaon Number PK Product Number…

A: Modality refers to the minimum number of times an instance in one entity can be associated with an…

Q: List the various aspects involved with the examination of the customer's capabilities.

A: Introduction; Thus, seven fundamentally distinct dimensions of democracy are highlighted: equitable…

Q: Explain how reflection can be utilized to improve the performance of a group.

A: NOTE :- Below i explain the answer in my own words by which you understand it well. Information…

Concept explainers

Enhanced ER Model

The enhanced ER model is an abbreviation for Enhanced Entity-Relationship (EER) model. As you know, the entity-relationship (ER) model is a pictorial illustration of the relationship between various entities of a domain. In the case of a large amount of data with multiple interrelated entities, the ER diagrams become complex and tough to interpret. For such cases, the need for enhancement in the ER model was observed, and thus, the EER model was designed.

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.

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

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

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.

Similar questions

Determinant in an entity or table is a field that depends on other fields determines other fields determines the price for a product is not necessary in a table
No matter what adjustments are made to the data or the parameters, the formulae in a spreadsheet that has been thoughtfully created will never need to be modified. True False
Explain roles, responsibilities, and required characteristics or skills of all roles in the scrum process.
What kind of structure would you say exists inside the company?
Explain how reflection can be utilized to improve the performance of a group.
Two unique relationships exist between the Customer and the Plan. Distinguish them by describing their distinctions.
List the activities, number of people required and the time (in days) required for each activity of ecommerce project. Be specific with details. For example, if you are going to collect data, indicate specifically who you are going to collect data from?
I need Activity Diagram
Please include all SDLC phases and their deliverables.
Use Case Diagram
What difficulties can be encountered when creating or keeping up with POA&M.
What is the level of engagement?