Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Given the following business rules, finish the business rule and create the appropriate Crow's Foot ERD. Paste the ERD from Visio into this document.

image text in transcribed
1. Given the following business rules, finish the business rule and create the appropriate Crow's Foot ERD. Paste the ERD from Visio into this document. a. A COMPANY operates many DEPARTMENTS. b. Each DEPARTMENT employs one or more EMPLOYEES. c. Each of the EMPLOYEEs might or might not have one or more DEPENDENTS. d. Each EMPLOYEE might or might not have an EMPLOYEE HISTORY. 2. Given the following Crow's Foot ERD, create the appropriate business rules. RENT LINE RENTAL CUSTOMER PK CUS NUM LIEPOS CUS_LNAME 25 PK RENT NUM LINE NUM RENT NUM FK2 CUS NUM RENT CHARGE RENT PAID RENT LATE CHG TAPE CODE LINE COPY LINE CHG DAY LINE CHARGE LINE DATE OUT LINE DATE IN TAPE PK TAPE_CODE TAPE COPY TAPE NAME TAPE_CHARGE a. List the required attributes for each entity in the above ERD. b. List the strong relationship(s) in the above ERD. c. List the weak relationship(s) in the above ERD. d. List the weak entity in the above ERD

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

Machine Learning And Knowledge Discovery In Databases European Conference Ecml Pkdd 2015 Porto Portugal September 7 11 2015 Proceedings Part 2 Lnai 9285

Authors: Annalisa Appice ,Pedro Pereira Rodrigues ,Vitor Santos Costa ,Joao Gama ,Alipio Jorge ,Carlos Soares

1st Edition

3319235249, 978-3319235240

More Books

Students also viewed these Databases questions