Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sketch the ERD for the following scenario. Please use the same format as the attached image ( attached image is unrelated to this problem, I

Sketch the ERD for the following scenario. Please use the same format as the attached image (attached image is unrelated to this problem, I just included it to show you the formatting using draw.io).Use proper ERD notations for attributes, entities, and relationships. Show all cardinalities, primary keys and foreign keys. Resolve all multi-valued attributes & M:N relationships properly.
Clients have a unique Client_Id and they have a Name. Clients award Projects to the firm. Each Project is awarded by exactly one Client and a client can award more than one Project but doesnt have to. No projects exist that are not awarded by a client. Projects have a unique Project_ID and they have attributes of Description and Due_Date.
Programmers are assigned to Projects and have a unique Programmer_Id. Programmers also have a Name, Office, and Language. A programmer must know at least one language and most programmers know more than one. Different programmers may know the same language. A Project may have no programmers assigned or a project may have several programmers assigned. A programmer must be assigned to at least one project but they may be assigned to several.
The programmers keep track of the time they work on the project using Time Cards. The time card records the Date and the Hours a programmer works on a project. A programmer creates a time card each time they work on a project. A programmer can work on a project on different days but s/he can only work on one project each day.
You do not need to explain cardinalities in words, but if you use any assumptions, make sure to indicate them in your answers.
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_2

Step: 3

blur-text-image_3

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 And Transaction Processing

Authors: Philip M. Lewis, Arthur Bernstein, Michael Kifer

1st Edition

0201708728, 978-0201708721

More Books

Students also viewed these Databases questions

Question

Identify how culture affects appropriate leadership behavior

Answered: 1 week ago