Answered step by step
Verified Expert Solution
Question
1 Approved Answer
3 C is a consulting company in Newark. It needs a database to keep track of the assignment of employees to projects. For each employee,
C is a consulting company in Newark. It needs a database to keep track of the
assignment of employees to projects. For each employee, C wants to record an
employee ID unique for every employee name, address, and birthday. For each project,
C wants to record a project ID unique for each project project name, and start date.
Employees are included in the database even when they have not been assigned to any
project. A project must have at least one employee assigned. An employees billing rate
the price they charge client for their services may vary by projects, and C wishes to
record the applicable billing rate for each employee when assigned to different projects
Hint: Search relationship attributes
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