Normalize table 3nf , Database Management System

Normalize the following tables upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the tables. No need for E-R, mapping, relationships etc. Just tables. State all assumption, logic, and reasoning, to explain your work.

Employee = Empid + Empname + SSN + Empadd + Empphone + DOB + Sex + DateHired + Lastdateworked + Averrating + WordProc + Typing + Filing + Bookkping + Steno + Availcode

Client = Clid + Clname + Cladd + Clphone + Contact + BillingYTD + PaymentYTD

Job = Job# + Jobtitle + Startdate + Expectenddate + Dailyrate + Dailyhours + Reporttoname + Reporttoadd + Reporttophone + Jobstatus + Clid*

Invoice = Invoice# + Invoicedate + Oldbal + Totcharges + Newbal + Totpaid + Clid*

Payroll = Check# + Paydate + Gross + Fed + Fica + State + Local + Net + Grossytd + Netytd + Fedytd + Ficaytd + Stateytd + Localytd + Empid*

Job-Employee = Job# + Empid + Ratername + Ratingdate + Emprating

Assumptions:


1. Employee address depends on employee phone.

2. Reporttoadd depends on Reporttophone.

3. Dailyrate depends on Jobtitle.

4. Net depends on combination of Gross, Fed, Fica, State, Local

5. Netytd depends on Grossytd, Fedytd, Ficaytd, Stateytd, Localytd

6. Newbal depends on Oldbal, Totcharges.

7. Net, Netytd, Grossytd, Fedytd, Ficaytd, Stateytd, Localytd are calculated fields.

8. Newbal is sum of oldbal and totcharges.

9. We would normally want the Reporttoadd with the Job record. Similarly, the Dailyrate is a piece of information that is integral to a Job record.

Posted Date: 3/12/2013 2:40:09 AM | Location : United States







Related Discussions:- Normalize table 3nf , Assignment Help, Ask Question on Normalize table 3nf , Get Answer, Expert's Help, Normalize table 3nf Discussions

Write discussion on Normalize table 3nf
Your posts are moderated
Related Questions
PART MARKING:  We will only mark TWO of the four questions below but you must submit answers to all four. We will choose the questions we mark randomly and we will supply you with

MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in

What is meant by mean time to failure? The mean time to failure is the amount of time that the system could run continuously without failure.

#floating point representation is used to store

Describe an data dictionary? A data dictionary is a data structure which keeps meta data about the structure of the database ie. the schema of the database.

Question: One of the tasks a database management system must perform is to ensure that the data is still intact in the face of software and hardware failure. This task is known

The figure below depicts the conceptual diagram of a banking system. (a) Describe one example relevant to the system in figure, for each of the 4 types of enterprise appl

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

What is data block? Data Block - In oracle the data blocks are referred to as tablespaces. A tablespace is an fields of disk consisting of one or more disk files. A tablespace