the er should diagram include customer,staff, products,deals and suppliers Task 2Using the scenario, produce Design Documentation for Plug-Ins Electronics. Yourdatabase design documentation should include:2.a) Entity Relationship 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, Dubai, UAE. It is a family firm that has been in existence 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.

An ER diagram contains entities and attributes. It is used to visually denote the working of a…

Using the scenario, produce Design Documentation for Plug-Ins Electronics. Your database design documentation should include: 2.a) Entity Relationship 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 include: 2.a) Entity Relationship 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: What ABAC attributes are needed to describe the following corporate structure: The Account…

A: ABAC Attributed: Attribute-based access control (ABAC) is an authorization model that evaluates…

Q: Specify the day-to-day activities associated with the DBA's technical role, which includes service…

A: A database administrator (DBA) is a technical role responsible for managing and maintaining…

Q: ERD should have a minimum of 10 entities, and ideally more. Entity-Relationship Diagram The subject…

A: ER:- A substance relationship model (or ER model) depicts interconnected items of interest in a…

Q: Describe your company's business plan.

A: Given: The cornerstone of your company is its business strategy. Using a business plan template, you…

Q: Calculate the total raw material cost (label TotCost) for each product compared to its standard…

A: SQL query The SQL query to calculate total raw material cost for each product:

Q: Describe your organization's unique identifier.

A: Intro Unique Organizational Identifiers are only assigned by IEEE. So let's talk about IEEE first.…

Q: How to Create single-process fact table?

A: Fact tables The fact table that is used in dataware housing is defined as the table that consists…

Q: Explain Basic concepts and definitions in relationships?

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

Q: Draw ER Diagram considering the various entity sets and relationship sets that are related to…

A: We will create ER diagram using entities attributes and relationship. Entity are shown by rectangle…

Q: Create an ER DIAGRAM that shows relationship between the following business rules below and post the…

A: The correct answer for the above mentioned question is given in the following steps for your…

Q: Why do businesses choose inflexible procedures?

A: Introduction: Companies favours the following in their business operations because: Here are four…

Q: To maintain the transaction codes, choose ______. Administration → Financials → Setup →…

A: Transaction codes are a kind of shortcuts for different applications. They are used in SAP for…

Q: Using Figure P2.4 as your guide, work Problems 4–5. The DealCo relational diagram shows the initial…

A: Rules: One region is the placement for several stores. every store is found in just one region.…

Q: Record purchased 어< Generate Order Details Display and Compute the total Store Staff Customer Manage…

A: The answer is

Q: What are the different tables that are utilized in EIGRP?

A: Answer:- the different tables that are utilized in EIGRP

Q: What is current sourcing?

Q: For each customer: CID (unique), CName (unique), For each manager: MID (unique), MFullName (composed…

A: Q. For Hotel: HotelID (unique) and ANoOfRooms (number of rooms in the hotel) For Hotel: HotelID…

Q: Given the following Business case scenarios I need help creating UML activity diagrams to highlight…

A: In this question we have to understand about the given scenario and designa UML activity diagram to…

Q: How the requirements are validated?

A: Requirements are the necessity which is the integral part of project.

Q: Which person is important to be a part/involved of during the - Three Steps of the Analysis Phase.…

A: Here is your solution -

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: Specify the business approach you plan to take.

A: A business plan is a formal written document that describes a company's aims, strategies, and…

Q: Based on the ER diagram above answer the questions below

A: The er diagram is based on the relationship between the book supplier and the books he sell.

Q: Transform the following EER diagram into relations and indicate the primary key and foreign keys for…

A: Step 1: Identify EntitiesIdentify all entities in the diagram. In our case, these are Vendor,…

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: PLEASE DRAW THE DIAGRAM ACCORDING TO THE QUESTION: 4. Company TeaLeaves has recently adopted a new…

A: Let's see the solution in the next steps

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: Identify two business rules from the below Entity Relationship Diagram (ERD

A: Above provide ER diagram relates to Employee Management or Office management flow. Description -…

Q: State and explain basic components of ASM chart. Also explain the salient features of ASM chart.

A: INTRODUCTION: Data and control information is separated from binary information in digital…

Q: b. Transform the following Entity relationship diagram to Relational Schema. ManName GSM ComiD…

A: Below I have provided a solution for the given question.

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: What issues may emerge as a result of vertically dividing a relationship?

A: Introduction: When a marriage ends, the PRA assumes that both partners have contributed equally to…

Q: What are the various EIGRP tables?

A: To store router information EIGRP uses three tables. They are: The neighbor table The topology…

Q: University First Name Last Name Middle Name Name Department Name Student Enroll in Department…

A: ERD (Entity Relationship Model): - The relationships of data items contained in a database are…

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: Create a possible data flow diagram for a gym membership registration process

A: What is the purpose of the Data flow Diagram: A data flow diagram (DFD) maps out the flow of…

Q: Please DRAW a normalized ER diagram for the following situation: Unidiner is a university dining…

A: We have to DRAW a normalized ER diagram for the following situation: Unidiner is a university dining…

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 should diagram include customer,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 Relationship 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, 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 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

Refer to this entity-relationship diagram. SALES PRODUCT PK Salesperson Number PK Product Number Quantity PK Product Number Sold %23 Sold Product Product Name Unit Price What is the modality of the product? Dependent on the quantity At least one Two or more Two
map the following lngical model(ER) diagram into a physical model ( Tables) Products Product d name description comanedin contain ORDERS Customers Order id Amount shipping address Customer Paemal Iname one Draw your tables on this page:
How is the key unit of a business name determine?
please provide full ans
Design and execute technical function DBA tasks.
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
Creation of Entity Relationship Diagram Draw the entity relationship diagram (ERD) for this information.
Entities, relationships, and characteristics should all have appropriate names and definitions.
What kind of structure would you say exists inside the company?
Please provide: Use Case diagram, Use Case description, Activity diagram, Swimlane diagram, dataflow diagram Features: Maid Biodata( User or maid employer can view maid biodata at the website real times) Scheduling Emergency Support Review Advanced Search Interview Online payment Settings
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?
Is there a need for creating an associative entity? If so, draw one, if not, then suggest why?