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
I need a help with my assignment of data envelopment analysis which is due for submission next week on monday the 10th Dec. Will you be able to help so that I can submit it on tim

Explain the function of Object model Object model describes the classes of objects in system, including their attributes and operations which they support. The analysis object

What do you understand by a view? What does WITH CHECK OPTION clause for a view do? - A view is a virtual table which comprises fields from one or more real tables. - It is

Explain Stand Alone Query Language in details? Stand alone Query Language - The query language that can be used interactively is known as stand alone query language. It does no

I need a professional to prepare a database to collect and store basic information. The information can be basic info such as contact details etc. One requirement i have is f

What is view in SQL? How is it defined? Any relation that is not part of the logical model, but is made visible to a user as a virtual relation is known as a view. We descri

Explain the term- Data Flows Data Flows: A data flow connects output of an object or process to input of another process or object. It represents an in-between data value wit

Super keys of a relation can have extra attributes. Candidate keys are minimal super key, i.e. such a key have no extraneous attribute. An attribute is known as extraneous if even

By which techniquesTransaction processing is associated? Transaction processing is associated by producing detail, summary, or exception reports and recording a business activi

What is a database graph? The partial ordering implies that the set D may now be viewed as a directed acyclic graph, known as a database graph.