Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Decide what form these tables are in (1nf,2nf,3nf) and explain why: Customer Columns Attributes Description Type Keys 1 cust_id customer id int PK 2 cust_name
Decide what form these tables are in (1nf,2nf,3nf) and explain why:
Customer | ||||
Columns | Attributes | Description | Type | Keys |
1 | cust_id | customer id | int | PK |
2 | cust_name | customer name | varchar | |
3 | phone_no | phone number | int | |
4 | email id | varchar | ||
5 | address | house address | varchar | |
6 | dob | date of birth | date | |
7 | license_detail | driving license details | varchar | |
8 | age | age of customer | int | |
Location | ||||
Columns | Attributes | Description | Type | Keys |
1 | loc_id | Location id | int | PK |
2 | loc_name | location name | varchar | |
3 | store_name | store name | varchar | |
4 | store_address | store address | varchar | |
5 | store_phone_no | store phone | int | |
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