This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: , Date_sold, Commission_percent, Discount_amt) Partial Dependencies: (Car_num Date_sold) (Salesman Commission_percent) Transitive Dependencies: (Date_sold Discount_amt) Step 2: CAR_SALE is not in 2NF or 3NF because there are partial and transitive dependencies present. These can lead to redundancy in the database. Step 3: Table Name: CAR Column Name Car_Num Date_Sold Key Type Primary Table Name: SALESMAN Column Name Salesman Commission_percent Key Type Primary Key Table Name: DATE_SOLD Column Name Date_Sold Discount_Amt Key Type Primary Key...
View Full Document
- Summer '08
- Database normalization, Key type