Draw an ER diagram including entity types, relationship types, attributes (including key attributes), and cardinality constraints....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Draw an ER diagram including entity types, relationship types, attributes (including key attributes), and cardinality constraints. Note: If necessary optimize the ERD using Associative Entity. Entity Types Regular Entities A Store has a Store Address, Store Supervisor ID, Store Manager ID, Employe ID, number of employees A Supervisor has a Supervisor ID, Store Supervising, Name, Phone, Email A Manager has a Manager ID, Store Number Managing Name, Phone, Email An Employee has an Employee ID, Store Location, Name, Phone, Email A Customer Service Representative has a Customer Service ID A Customer has a Customer Membership ID, Name, Phone, Email, Shipping Address Associative Entities An Order has Order ID, Customer Membership ID, Customer Name, Customer Shipping Address, Customer Payment A Complaint has a Complaint ID, Customer Membership ID, Complaint Draw an ER diagram including entity types, relationship types, attributes (including key attributes), and cardinality constraints. Note: If necessary optimize the ERD using Associative Entity. Entity Types Regular Entities A Store has a Store Address, Store Supervisor ID, Store Manager ID, Employe ID, number of employees A Supervisor has a Supervisor ID, Store Supervising, Name, Phone, Email A Manager has a Manager ID, Store Number Managing Name, Phone, Email An Employee has an Employee ID, Store Location, Name, Phone, Email A Customer Service Representative has a Customer Service ID A Customer has a Customer Membership ID, Name, Phone, Email, Shipping Address Associative Entities An Order has Order ID, Customer Membership ID, Customer Name, Customer Shipping Address, Customer Payment A Complaint has a Complaint ID, Customer Membership ID, Complaint
Expert Answer:
Answer rating: 100% (QA)
What is ER Diagram ER Diagram stands for Entity Relationship Diagram also known as ERD is a diagram ... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these accounting questions
-
Draw an ER Diagram for a project management and issue tracking system for a startup that supplies software to small enterprises The requirements for the ER diagram are given below Write down all...
-
Review Questions Q1) Design the entity relationship diagram for the following scenario? A company is setting up a database to record sellers and their products. This requires recording the following...
-
Draw an entity-relationship diagram including minimum and maximum cardinality for the following The system stores information about two things cars and owners .A car has attributes for make model and...
-
What is your debt payments-to-income ratio if your debt payments total $684 and your net income is $2,000 per month?
-
LifeLine Corporation manufactures fire extinguishers. One part used in all types of fire extinguishers is a unique pressure fitting that requires specialized machine tools that need to be replaced....
-
A civil engineer is studying a left-turn lane that is long enough to hold seven cars. Let X be the number of cars in the lane at the end of a randomly chosen red light. The engineer believes that the...
-
Sherwin Corporation invest its excess cash in equity securities when such founds are not needed to support operations. At the beginning of the year the companys portfolio consisted of the following...
-
Redhawk, Inc., is a merchandiser that provided the following information: Number of units sold............. 10,000 Selling price per unit............. $15 Variable selling expense per unit............
-
Define business ethics and corporate social responsibility ( CSR ) . How can ethical decision - making and CSR initiatives benefit an organization's reputation and long - term success?
-
This assignment requires you to complete the 2022 tax reporting for a fictional woman named Anna Smith. Question 1 T1 - step 4 - line 66 This is Anna's taxable income Answer: Question 2 T1 - step...
-
Mary Mother comes into your office, and wants to talk about divorcing her husband, Fred Father. The parties were married in Tampa, Fl on July 4, 1995. There are no minor children of the marriage, but...
-
A steel mono-pile needs to be constructed to hold a monitoring station. The monitoring station should be 20 feet above the still water level, SWL, of 55 feet. The superstructure including the...
-
Explain the advantages and disadvantages inherent in each of the four business forms with regard to contract creation, negotiation, and approval of contracts.
-
1) What is Philosophy? Do you have a personal philosophy in life? If so, what is your personal philosophy? 2) Differentiate ethics from morality. 3) Why is ethics called a normative science?...
-
At gunpoint, a convenience shop was robbed in the middle of the day. The culprit was seen on the store's security camera, and a composite sketch was created from the footage. The owner of the...
-
Assume Ganado enters into a swap agreement to receive euros and pay Japanese yen, on a notional principal of 5,000,000. The spot exchange rate at the time of the swap is 104/. (When you answer the...
-
Most experts agree the pandemic proved that Lean systems processes and thinking are out- of-date and should be scrapped. O True O False
-
This problem continues the Draper Consulting, Inc., situation from Problem 12-45 of Chapter 12. In October, Draper has the following transactions related to its common shares: Oct 1 Draper...
-
What is the purpose of the Union, Intersection, and Difference operations?
-
What is the difference between a Select statement that used Count (*) and a select statement that uses count (Column name)? How does Count (Column name) differ from Count (Distnct column name)?
-
Consider the relation instance STUDENT (Major, Stu_id, Activity, Name, Phone) a. Identify all multi-valued dependencies in STUDENT. b. Describe insertion, deletion, and update anomalies that...
-
Rebecca Odin has the following details of her property, plant and equipment. She charges depreciation at 2% per annum on cost for buildings, 10% per annum on cost for machinery, 25% per annum on cost...
-
Deborah Urer owns a small bar. Her trial balance as at 30 June 2012 is set out below. You also have the following additional information. 1. Closing inventory is 6,250. 2. There is 200 owing for...
-
Why do you think that three different types of business enterprise (sole traders, partnerships and limited companies) exist?
Study smarter with the SolutionInn App