Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Review following cases and create ERD for each case: Company, Department, Employee State, City, Zip, Street Case # 1 : Q . How many Departments

Review following cases and create ERD for each case: Company, Department, Employee State, City, Zip, Street Case #1: Q. How many Departments can be in each Company? A. Many Q. Can each(1) Department belong to multiple Companies? A. No! Each(1) Company has Many Departments; Each (1) Department belongs to 1 Company. Conclusion: Company to Departments: Relation 1 : M Departments to Company: Relation M : 1 Case #2: Q. How many Courses Each Student can take? A. Many Q. How many Students can take Each Course? A. Many Conclusion: Student to Course Relation: M : M S

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

Larry Ellison Database Genius Of Oracle

Authors: Craig Peters

1st Edition

0766019748, 978-0766019744

More Books

Students also viewed these Databases questions

Question

3. Identify challenges to good listening and their remedies

Answered: 1 week ago

Question

4. Identify ethical factors in the listening process

Answered: 1 week ago