Question: You can make the following assumptions: 1 . Each store has one manager 2 . Each employee has one supervisor 3 . Many employees are

You can make the following assumptions:
1. Each store has one manager
2. Each employee has one supervisor
3. Many employees are assigned to each store. The attribute Hours tells the number of hours each employee has worked on the corresponding store per week and the attribute rating is the rating that this employee received for his work on this store.
4. Revenue and opening date refer to the store
Based on this information:
1. Is this relation in 1NF? If not create the 1NF. If yes explain why.

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 Databases Questions!