Answered step by step
Verified Expert Solution
Link Copied!

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.

imageimage

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi

12th edition

133544613, 978-0133544619

More Books

Students also viewed these Algorithms questions

Question

List four objectives of derived data.

Answered: 1 week ago