Question: 1 - Put this relation in BCNF SKU _ DATA 2 - Put this relation in BCNF STUDENT _ ACTIVITY 3 - Create an ER
Put this relation in BCNF
SKUDATA
Put this relation in BCNF
STUDENTACTIVITY
Create an ER model to reflect the information requirements for the following case:
A consulting firm needs to keep track of its employee information such as employee
name, home address, salary, cell phone number etc. Every employee has a unique
employee ID assigned by the firm. Each employee has a job title. Some employees may
work on many projects but not every one works on a project. A project is identified by a
project's ID A project also has a title. The firm needs to keep track of its past and
ongoing project's information, including budget, director name, project starting and
ending dates. The firm also wants to know which employees working on which
projects Usually a project always has some employees working on it Each project is
developed for and sponsored by its client. The firm needs to keep contact information of
all clients, including client name, address, email and phone number.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
