Question: Perform the normalisation process for project charges report shown in the table below. You should perform this process up to 3NF relations. For each level

Perform the normalisation process for project charges report shown in the table below. You should perform this process up to 3NF relations. For each level of normalisation, identify functional dependencies for each attribute for 1NF, 2NF and 3NF. Then, describe and illustrate the normalisation process for each level comprehensively Perform the normalisation process for project charges report shown in the table

WorkNo ProjectNo W2002 10002 EmpNo EmpName 101 Abdul Fahmi Razak 107 Meor Hashim Meor Ngah 112 Mohamad Azami Daud 118 Ramli Azman 120 Anita Jusoh Job Description Project Manager Database Admin System Analyst System Developer System Developer Project Name Oracle data migration JoinDate 03-Feb-2009 20-Mei-2010 28-Mei-2010 22-Jun-2011 02-Dec-2011 WorkHour 24 32 32 160 160 AssignDate 12-Oct-2016 JobID J05 JO8 J12 J31 J31 Charge Amount 4800.00 3200.00 3840.00 8000.00 8000.00 Rate Hour 200.00 100.00 120.00 50.00 50.00 Work No Project No Project Name AssignDate W3044 10006 eProduction Development 18-Oct-2016 EmpNo EmpName JoinDate JobID 102 Fridaus Othman 17-Mac-2009 J05 107 Meor Hashim Meor Ngah 20-Mei-2010 J08 114 Asma Che Amin 15-Jun-2010 J12 123 Fahmi Abdullah 01-Mac-2012 J25 124 Nuridzuan Ahmad 15-Mac-2012 J31 Job Description RateHour WorkHour Charge Amount Project Manager 200.00 80 16000.00 Database Admin 100.00 1500.00 System Analyst 120.00 120 12000.00 Senior System Developer 80.00 160 12800.00 System Developer 50.00 160 8000.00 15

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!

How to perform normalisation on these documents? Building Insurance and Damage History Property ID 4231212 Bulding ID 1 Bulding Size (sq. m) 300 Bulding Class* 1 LGA Building Value $523,000 Insurance...

SECTION A: Answer ALL (30 marks) QUESTION 1 Rajesh owns a car rental shop. To maintain the rental records in a systematic way, Rajesh assigns a unique ID to each of his customers. He allows each...

Assignment 1. You recognize that the existing table structure is very poor and need to improve it. Given what you see in the table above, a) Draw a dependency diagram. Identify the possible primary...

From the case study below answer Tasks 1-3 Whenever a customer makes a booking on the web page, they must enter their customer details. A new customer will automatically be assigned an account...

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

This question involves the use of AGGREGATE linear PYTHOIN regression on the Auto data set. (a) Perform a simple linear regression with mpg as the response and horsepower as the predictor. Describe...

Given the following relational DB Schema Employee (empNo, fName, lName, address, DOB, sex, position, deptNo) Department (depNo, depName, mgrempNo) Project (prjNo, prjName, deptNo) WorksOn (empNo,...

This is not an easy and quick question for you instructors. It need attention and time and good knowledge of data base. It is complete question. Term Project - week 8 - (17%): You were just hired to...

Its only 8 simple question but looks like lengthy assignment. Just need focus and attention Term Project - week 8 - (17%): You were just hired to make a database to track blood draws at a lab....

Given the sample records in the EMPLOYEE table shown below, and using the Normalization Steps discussed in this Topic, normalize this table into 3NF. Be sure to document and provide each individual...

Required information [The following information applies to the questions displayed below.] Blue Water Sails, Incorporated (BWS) manufactures sailcloth used by sailmakers that produce sails for...

(a) Why do researchers want to discover relationships? (b) What is the difference between a real relationship and one produced by sampling error?

? _ _ _ _ _ _ _ _ i s t h e m o s t c o m m o n t y p e o f e a r n i n g s m a n i p u l a t i o n .

QUESTION 2 Prepare an Income statement of the company at the end of February for each one of the products sold by Julia using the following methods of valuation of the inventory: You can ignore all...

Do you generate agendas with the dates, places, and times for the next meetings?

How will the members be held accountable?

a. Do team members trust each other?