Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

CSIT 1 5 4 Lab 2 There are 2 parts to this week's assignment. You will upload 2 files for this assignment. Part 1 will

CSIT 154
Lab 2
There are 2 parts to this week's assignment. You will upload 2 files for this assignment. Part 1 will be a JPEG file and part 2 will be a PDF file. Part 1
Use Lucidcharts to create a crow's foot ERD for each problem. You can watch the provided tutorial video for using the application.
A. At ABC Company, each division has many departments. Each department has some employees and each employee works for only one department. Each department is managed by one employee, and each manager manages only one department.
B. A customer can download many CDs from MusicOnline. Each of the CDs can be downloaded by many customers.
C. The FERDA Corporation operates many plants. Each plant is in an area, and each area can have more than one plant. Each plant has many employees; however, each employee is employed by only one plant.
Part 2
Write the business rules that are reflected in the ERD shown in the following Crow's foot diagram. Determine the business rules required to make the diagram correct. Attach your answers as a PDF document to the same assignment.
image text in transcribed

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

Database Design Query Formulation And Administration Using Oracle And PostgreSQL

Authors: Michael Mannino

8th Edition

1948426951, 978-1948426954

More Books

Students also viewed these Databases questions

Question

Did you open with an issue explanation?

Answered: 1 week ago

Question

Understand the role of internal marketing and communications.

Answered: 1 week ago