Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company employs many employees. b). Each employee has one and only one position. Many employees have the same position. The number of employees that have the same position can not exceed 10. c). Each position is classified as management, technical support, or stuff. Each category includes at least one position. d). An employee may or may not attend one or more meetings. e). Each meeting is attended by many employees but not more than 20. 18 PK 8 CUSTOMERS Customer# int NOT NULL Lastname char(50) NOT NULL Firstname char(50) NOT NULL Email char(50) NOT NULL Address char(50) NOT NULL City char(50) State char(50) Zip char(50) Referred char(50) Region char(50) ORDERSITEMS PK Item# int NOT NULL FK Order# char(50) NOT NULL FK ISBN char(50) NOT NULL Quantity int Paideach int NOT NULL + + PROMOTION PK Gift char(50) NOT NULL Minretail int NOT NULL Maxretail int NOT NULL B PK FK Order# int NOT NULL ORDERS Customer# char(50) NOT NULL Orderdate Date Shipdate Date Shipstreet char(50) NOT NULL Shipcity char(50) Shipstate char(50) Shipzip char(50) Shipcost int BOOKS PK ISBN# int NOT NULL ++ Title char(50) NOT NULL PubDate Date NOT NULL PubID int NOT NULL Cost char(50) NOT NULL Retail char(50) Discount int Category char(50) NOT NULL B BOOKAUTHOR FK ISBN int NOT NULL OFK1 AuthorID int NOT NULL B PUBLISHER PK PubID int NOT NULL Name char(50) NOT NULL Contact int NOT NULL Phone int NOT NULL 8 AUTHOR PK AuthorID int NOT NULL Lname char(50) NOT NULL Fname char(50) NOT NULL Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company employs many employees. b). Each employee has one and only one position. Many employees have the same position. The number of employees that have the same position can not exceed 10. c). Each position is classified as management, technical support, or stuff. Each category includes at least one position. d). An employee may or may not attend one or more meetings. e). Each meeting is attended by many employees but not more than 20. 18 PK 8 CUSTOMERS Customer# int NOT NULL Lastname char(50) NOT NULL Firstname char(50) NOT NULL Email char(50) NOT NULL Address char(50) NOT NULL City char(50) State char(50) Zip char(50) Referred char(50) Region char(50) ORDERSITEMS PK Item# int NOT NULL FK Order# char(50) NOT NULL FK ISBN char(50) NOT NULL Quantity int Paideach int NOT NULL + + PROMOTION PK Gift char(50) NOT NULL Minretail int NOT NULL Maxretail int NOT NULL B PK FK Order# int NOT NULL ORDERS Customer# char(50) NOT NULL Orderdate Date Shipdate Date Shipstreet char(50) NOT NULL Shipcity char(50) Shipstate char(50) Shipzip char(50) Shipcost int BOOKS PK ISBN# int NOT NULL ++ Title char(50) NOT NULL PubDate Date NOT NULL PubID int NOT NULL Cost char(50) NOT NULL Retail char(50) Discount int Category char(50) NOT NULL B BOOKAUTHOR FK ISBN int NOT NULL OFK1 AuthorID int NOT NULL B PUBLISHER PK PubID int NOT NULL Name char(50) NOT NULL Contact int NOT NULL Phone int NOT NULL 8 AUTHOR PK AuthorID int NOT NULL Lname char(50) NOT NULL Fname char(50) NOT NULL
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these algorithms questions
-
Both data sets shown in the histograms have a mean of 50. One has a standard deviation of 2.4, and the other has a standard deviation of 5. By looking at the histograms, which is which? Explain your...
-
Use the following business rules to create a Crows Foot ERD. Write all appropriate connectivities and cardinalities in the ERD. a. A department employs many employees, but each employee is employed...
-
What is the result of the following? A. 3.011459 B. 3.1401MM C. 59.011459 D. 59.1401MM E. The code does not compile. F. The code compiles but throws an exception at runtime. import java.time. *;...
-
Fraser Valley Technologies Inc. had the following shareholders' equity on December 31, 2017: Common shares, 200,000 shares issued and outstanding .......................$2,000,000 Retained earnings...
-
Problems 1 and 2 used different forecasting methods. Which method appears to provide the more accurate forecasts for the historical data? Explain.
-
In many science fiction movies, someone is portrayed moving something with her or his mind-an amazing feat called telekinesis. What does your knowledge of forces predict about the effect of a...
-
An Equimolar liquid mixture of n-pentane and n-hexane at 80?C and 5.00 atm is fed into a flash evaporator at a rate of 100.0mol/s. When the feed is exposed to the reduced pressure in the evaporators...
-
1. (30 pts) Consider a computer system that uses 32-bit addressing and is byte addressable. It has a 64 KiB 8-way set-associative cache, with 16 words per cache block. (a) (10 pts) Write down the...
-
5 10 points Match the virtual lab procedure with the correct lung volume. 6 7 Ask the subject to inspire a normal inspiration, and breathe out a normal expiration, then exhale as forcibly as possible...
-
Determine the requested binomial tree option pricing model inputs given the information below and the assumption of a 360-day year: $ Spot price of underlying security: Risk-free rate (APR): Value...
-
If simple payback is not a good financial decision making criteria, why is it used so often? Also discuss the good financial decision. Explain briefly
-
Assuming certified cost or pricing data are not required, under what circumstances does the FAR permit cost analysis alone to be determine a reasonable price?
-
Joey, whose mass is m = 36 kg, stands at rest at the outer edge of a frictionless merry-go-round with the mass M = 300 kg and the radius R = 2.0 m, as in. The merry-go-round is also at rest. Joey...
-
What program was established in 1975, that uses the tax system to provide tax refunds to the working poor, where the value of the program is based on earnings and the number of children, if any,...
-
How can carrying inventory protect against stockouts, balance supply/demand, and protect against uncertainty? What are the consequences of not carrying inventory? Rubrics
-
In Problems 6-12, construct a scatterplot of the given data. Is there a trend in the data? Are any of the data points outliers? Construct a divided difference table. Is smoothing with a low-order...
-
The tractor is used to lift the 150-kg load B with the 24-mlong rope, boom, and pulley system. If the tractor travels to the right at a constant speed of 4 m/s, determine the tension in the rope when...
-
List four objectives of derived data.
-
A driver's license bureau maintains a database of licensed drivers. State whether each of the following represents data or metadata. If it represents data, state whether it is structured or...
-
Briefly describe four threats to high data availability and at least one measure that can be taken to counter each of these threats.
-
Consider the dynamic system, a mass, spring and damper structure, shown in Figure 2.2. (a) Draw a free-body diagram for the dynamic system (b) Derive the Input-Output model of the dynamic system k...
-
Two connected cars with an applied input force \(u(t)\) and negligible rolling friction can be represented by a translational mechanical system as shown below. (a) Draw the free-body diagrams of this...
-
Consider an RLC circuit consisting of a resistor \((R)\), an inductor \((L)\), and a capacitor \((C)\), connected in series, as depicted in Figure 2.4. Derive the Input-Output model of the network....
Study smarter with the SolutionInn App