Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started