Question: 1 - Put this relation in BCNF SKU _ DATA 2 - Put this relation in BCNF STUDENT _ ACTIVITY 3 - Create an ER

1- Put this relation in BCNF
SKU_DATA
2- Put this relation in BCNF
STUDENT_ACTIVITY
3- 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 employee(s) working on which
project(s). Usually a project always has some employee(s) 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.
1 - Put this relation in BCNF SKU _ DATA 2 - Put

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!