Answered step by step
Verified Expert Solution
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.ioUse proper ERD notations for attributes, entities, and relationships. Show all cardinalities, primary keys and foreign keys. Resolve all multivalued attributes & M:N relationships properly.
Clients have a unique ClientId 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 ProjectID and they have attributes of Description and DueDate.
Programmers are assigned to Projects and have a unique ProgrammerId 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 she 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started