[kunkka]

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]

[June7]

Here is a tutorial on database design.

http://forums.aspfre...les-208217.html