Using Visio, create an Entity Relationship Diagram (ERD) of .xlsx data a. Please include the correct...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using Visio, create an Entity Relationship Diagram (ERD) of .xlsx data a. Please include the correct annotations for cardinality You are now the database designer. Add a new entity to your ERD in Visio from question #3 that was not defined in the data provided. This new entity should relate to the existing entities. a. Include i. ii. iii. iv. Entity Name Cardinality relationship to other Entity Column Names Data Type Size your normalized V. vi. Key References vii. NOT NULL Constraints Grocery Store 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 Sales Clerk Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Natasha Romanoff Total, Item Count $68.40, 14 $81.56, 24 $27.50, 12 $224.42, 52 $51.60, 14 $137.40, 31 $52.00, 20 $48.20, 21 $43.56, 16 $9.78, 3 $169.50, 43 $27.06, 8 $87.28, 20 $97.42, 22 $181.48, 34 Type, Cash-back, Rewards Card used? Credit, No, Yes Debit, Yes, Yes Credit, No, No Credit, No, Yes Credit, No, Yes Credit, No, Yes Cash, No, Yes Debit, Yes, Yes Credit, No, Yes Cash, No, No Credit, No, Yes Credit, No, Yes Debit, Yes, No Cash, No, Yes Debit, No, Yes Column Name Grocery Store Sales Clerk Grocery Store No. Total Item Count Payment Type Cash back Additional Payment varchar varchar Number float number var char var char varchar Data Type Max 8000 char Max 8000 char 5-17 bytes 4-8 bytes 5-17 bytes Max 8000 char Max 8000 char Max 8000 char Size Key Foreign Key Not Null Constraints Primary Key NOT NULL Using Visio, create an Entity Relationship Diagram (ERD) of .xlsx data a. Please include the correct annotations for cardinality You are now the database designer. Add a new entity to your ERD in Visio from question #3 that was not defined in the data provided. This new entity should relate to the existing entities. a. Include i. ii. iii. iv. Entity Name Cardinality relationship to other Entity Column Names Data Type Size your normalized V. vi. Key References vii. NOT NULL Constraints Grocery Store 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 133, 2589 Lomas NE Albuquerque NM 87131 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 290, 4433 Plaza Central Ave. Santa Fe NM 87587 Sales Clerk Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Steve Rogers T'Challa Wakanda Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Tony Stark Natasha Romanoff Natasha Romanoff Total, Item Count $68.40, 14 $81.56, 24 $27.50, 12 $224.42, 52 $51.60, 14 $137.40, 31 $52.00, 20 $48.20, 21 $43.56, 16 $9.78, 3 $169.50, 43 $27.06, 8 $87.28, 20 $97.42, 22 $181.48, 34 Type, Cash-back, Rewards Card used? Credit, No, Yes Debit, Yes, Yes Credit, No, No Credit, No, Yes Credit, No, Yes Credit, No, Yes Cash, No, Yes Debit, Yes, Yes Credit, No, Yes Cash, No, No Credit, No, Yes Credit, No, Yes Debit, Yes, No Cash, No, Yes Debit, No, Yes Column Name Grocery Store Sales Clerk Grocery Store No. Total Item Count Payment Type Cash back Additional Payment varchar varchar Number float number var char var char varchar Data Type Max 8000 char Max 8000 char 5-17 bytes 4-8 bytes 5-17 bytes Max 8000 char Max 8000 char Max 8000 char Size Key Foreign Key Not Null Constraints Primary Key NOT NULL
Expert Answer:
Answer rating: 100% (QA)
Question For the Entity relationship diagram it include 5 entities 1 Item entity 2 payment entity 3 ... View the full answer
Related Book For
Posted Date:
Students also viewed these databases questions
-
If in an economy: (a) Consumption function is given by C = 100+ 0.75 Y, and (b) Autonomous Investment Is 150 crores. Estimate (I) Equilibrium level of Income and (ii) Consumption and Savings at the...
-
Create an entity relationship diagram from Fundamentals of Database Management Systems.
-
Read the scenario and design an entity relationship diagram with the following components: A local university is starting an internship program for its seniors to gain real world experience in local...
-
This section contains 6 questions. Questions 83 to 88 have four statements (A, B C and D) given in Column I and four statements (p, q, r and s) in Column II. Any given statement in Column I can have...
-
A year-old study found that the service time for all drive-thru customers at the Stardust Coffee Shop is uniformly distributed between 3 and 6 minutes. Assuming the service time distribution has not...
-
The snail Cepaea nemoralis may have a yellow, pink or brown shell. Each colour shell may have up to five dark bands, or have no bands. Both shell colour and number of bands are genetically...
-
What are some audit steps to catch skimming and money-laundering schemes?
-
In Kagan Company, materials are entered at the beginning of each process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its Sterilizing...
-
Question 19 Not yet answered Question text Review the List of Transactions below. Compare the transactions against the entries in the Trust Cash Receipts Book and Trust Cash Payments Book below....
-
Ben Johnson is the manager of the jewelry department of a large chain of department stores. The department store has succeeded on the basis of customer service and quality of merchandise. As a...
-
4. A lens has a strong spherical aberration. If an object consists of a series of dots arranged in a cross concentric with the optical axis (Fig. 1), how does the image look like in the imaging...
-
4 5 4 Solve the equation *+1 2 3(x+1)*
-
This method consists of defining a year as a base year to make comparisons of other years with respect to it: Vertical analysis. Trends Horizontal analysis Percent analysis. Instruments used in...
-
8. Using CRC method, generate a code word for data word 1011110111 using each of the following generator polynomials. (15 points) a) G(x)=x+1 b) G(x)=x++ x+x Assume that the receiver of a system that...
-
You have been hired by FAB Corporation, a manufacturer of a new garage door opening device. The President has asked you to review the company's costing system to control manufacturing overhead costs....
-
K Divide and simplify. 45 5 45 5 (Simplify your answer. Type an exact answer, using radicals a
-
The ASX Corporate Governance Principles do not inclide: a. Safeguarding integrity in financial reporting b. None- all are included c. Recognising and managing risk d. Reporting the rights of s 1...
-
The Taylor's series expansion for cosx about x = 0 is given by: where x is in radians. Write a user-defined function that determines cosx using Taylor's series expansion. For function name and...
-
The number (in millions) of international tourists who travel to India in the years 2009, 2010, 2011, 2012, and 2013 is 5.1, 5.7, 6.2, 6.5, and 6.6, respectively. Let n be the number (in millions) of...
-
5x x 12 Describe the solution set as an inequality, in interval notation, and on a graph.
-
Some ordered pairs are listed in Table 49. Table 49 Some Ordered Pairs xy -10.4 -7..1 -3.-3 -1.-2 2-5 a. Construct a scatterplot by hand. b. Is there a linear association, a nonlinear association, or...
-
From 1921 through 2020, the mean return of the Standard \& Poor's 500 was \(12.59 \%\). A random sample of 38 years is selected from this population. What is the probability that the mean return for...
-
From 1975 through 2020, the mean annual gain of the Dow Jones Industrial Average was 652. A random sample of 32 years is selected from this population. What is the probability that the mean gain for...
-
A fertility rate is the number of births per 1000 women aged 15-44. The mean fertility rate of the 50 U.S. states for a recent year was 59.0 with a standard deviation of 5.47. A random sample of 40...
Study smarter with the SolutionInn App