1 Replies - 554 Views - Last Post: 08 June 2009 - 01:21 PM Rate Topic: -----

#1 kunkka  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 99
  • Joined: 15-May 09

can someone help me with my Normalisation

Posted 07 June 2009 - 07:58 AM

Please check my Normalisation is correct or not. if not please tell me what to do..


2NF

Customer(Cust_ID,Name,Address,NIC,Telephone,Email)

Estimate(Est_ID,Cust_ID,Est.Request_Date,Est.Details,Cost,Duration, Est.Level)

Booking(Booking_ID,Est_ID,Surv_ID,Emp_ID,Descript,Email_Sent,Booking_date)

Employee(Emp_ID,Emp_Name,Address,NIC,Joindate,Telephone,Email,Type,Availability,Skills,Level,Email_Sent,Username,Password)

Job(Job_ID,Emp_ID,Est_ID,Est_Status,Price,Job_Status,Details,Start_Date,Estimate_EndDate,EndDate,Accepted_Job)

OrderLine(Order_ID,SJ_ID,Emp_ID,Supplier_ID,Details,Date,Price,OrderPlaced)

Small_Jobs(SJ_ID,Job_ID,Emp_ID,Desc,Progress,Start_Date,End_Date,Duration,OrderStatus)

Supplier (Supplier_ID,Name,Address,Telephone,Email,Type)

Surveyors(Surv_ID,Name,Address,NIC,Telephone,Email,Availability,Surv_Level,SentMail)



3NF


Customer(Cust_ID,Name,Address,NIC,Telephone,Email)

Estimate(Est_ID,Cust_ID,Est.Request_Date,Est.Details,Cost,Duration, Est.Level)

Booking(Booking_ID,Est_ID,Surv_ID,Emp_ID,Descript,Email_Sent,Booking_date)

Employee(Emp_ID,Emp_Name,Address,NIC,Joindate,Telephone,Email,Type,Availability,Skills,Level,Email_Sent,Username,Password)

Job (Job_ID, Emp_ID, Est_ID, Price, Job_Status, Details, Start_Date, EndDate, Accepted_Job)

OrderLine(Order_ID,SJ_ID,Emp_ID,Supplier_ID,Details,Date,Price,OrderPlaced)

Small_Jobs(SJ_ID,Job_ID,Emp_ID,Desc,Progress,Start_Date,End_Date,Duration,OrderStatus)

Supplier (Supplier_ID,Name,Address,Telephone,Email,Type)

Surveyors(Surv_ID,Name,Address,NIC,Telephone,Email,Availability,Surv_Level,SentMail)


Justification


When normalizing 2NF to 3NF, the Job table Est_Status, Estimate_EndDate, is not transitively depend on Job_ID. Most of the table has their own primary key without being two keys as a primary key.

[is this enough. please help me]

Is This A Good Question/Topic? 0
  • +

Replies To: can someone help me with my Normalisation

#2 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: can someone help me with my Normalisation

Posted 08 June 2009 - 01:21 PM

Here is a tutorial on database design.

http://forums.aspfre...les-208217.html
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1