|
-
November 13th, 2007, 11:29 AM
#1
normalization
hii
i have these unnormalized data..i wanna normalized these up to 3NF.
I tried 1st NF..but im not sure whether its correct ..if anyone can pls help me.
HIREINFO (Machine_ID, Hire_customer_name, Hire_customer_address, Date_of_hire, Days_hire, Price_of_hire_per_day, Hire_customer_category, Category_description, Hire_category_discount_percentage)
1st NF-
Customer_Details ([Customer_ID, Machine_ID]pk, Hire_customer_name, Hire_customer_address, Hire_customer_category, Category_description, Hire_category_discount_percentage)
Hire_Details (Machine_ID[pk], Date_of_hire, Days_hire, Price_of_hire_per_day,)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|