Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The following table is a sample of the data from a company, that store information about various stores and the employees that work on these
The following table is a sample of the data from a company, that store information about various stores and the employees that work on these stores The data are as follows: StoreName StoreMgr EmpId Hoursperweek Revenue OpeningDate EmpSalary Empsuper EmpDept Rating PinkStore Bob E Alice Pink Store Bob E Bob Pink Store Bob E Alice BlueStore Alice E Alice Blue Store Alice E Alice Blue Store Alice E Bob You can make the following assumptions: Each store has one manager Each employee has one supervisor 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. Revenue and opening date refer to the store Based on this information: Is this relation in NF If not create the NF If yes explain why.
The following table is a sample of the data from a company, that store information about various stores and the employees that work on these stores
The data are as follows:
StoreName StoreMgr EmpId Hoursperweek Revenue OpeningDate EmpSalary Empsuper EmpDept Rating
PinkStore Bob E Alice
Pink Store Bob E Bob
Pink Store Bob E Alice
BlueStore Alice E Alice
Blue Store Alice E Alice
Blue Store Alice E Bob
You can make the following assumptions:
Each store has one manager
Each employee has one supervisor
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.
Revenue and opening date refer to the store
Based on this information:
Is this relation in NF If not create the NF If yes explain why.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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