Question
Consider a Laptop sales database. The database is having information on selling of various models of laptops. Consider the following relation: Laptop_SALE(Laptop_Model, Sales_Person, Amount_of_Discount, Percentage_of_Commission,,
Consider a Laptop sales database. The database is having information on selling of various models of laptops. Consider the following relation:
Laptop_SALE(Laptop_Model, Sales_Person, Amount_of_Discount, Percentage_of_Commission,, Sold_Date)
A Laptop might be sold by different salesperson, henceforth the primary key will be a combination of Laptop_Model and Sales_Person
FDs based on primary key: Sales_Person -> Percentage_of_Commission Sold_Date -> Amount_of_Discount
Answer the following : i. Identify whether the relation is 1NF, 2NF or 3NF. ii. Why or why not? Justify. iii. In what way u could progressively normalize it totally?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Beginning Databases With PostgreSQL From Novice To Professional
Authors: Richard Stones, Neil Matthew
2nd Edition
1590594789, 978-1590594780
