Question
Here is some data that is to be kept in a database. Projects have multiple employees working on them. Pay rates are set by an
Here is some data that is to be kept in a database. Projects have multiple employees working on them. Pay rates are set by an employees job class. Normalize this data from unnormalized to 3NF. Explain what you are doing and why you are doing it at each step. Only do what is required from each transitions from one form to the next. Once you have explained a transition, show the new relations and their attributes. This can be of the form TABLE(A1, A2,..An). Make sure you have indicated keys where necessary by underlining them. This is sample data but does not represent all possibilities of data. Keep this in mind so you do not base your responses only on this dataset. For example, an employee could work on more than one project.
PROJ NUM PROJ NAME EMP NUM EMP NAME JOB CLASS CHG HOUR HOURS Evergreen 103 101 105 106 102 Amber VWave 114 118 104 112 June E. Arbough Elect. Engineer John G. Newws Alice K. Johnson Database Designer Miliam Smithtield David H. Senior Annelise Jones James J. Frommer General Support Anne K. RamorasSystems Analyst Darlene M. Smithson DSS Analyst $84.50 $10500 $105.00 $35.75 $96.75 23.8 19.4 35.7 2.6 23.8 Database Designer Programmer Systems Analyst Applications Designer $48.1024.6 18 $18.36 45.3 32.4 $96.75 $45.95 44.0Step 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