Answered step by step
Verified Expert Solution
Question
1 Approved Answer
use the below ERD to create new tables to allow the database to conform to the 1NF Products_1NF PK1 Barcode VARCHAR(150) PK2 NavigationPath VARCHAR(150) PK3
use the below ERD to create new tables to allow the database to conform to the 1NF
Products_1NF | ||
PK1 | Barcode | VARCHAR(150) |
PK2 | NavigationPath | VARCHAR(150) |
PK3 | ItemDescription | VARCHAR(150) |
Width | REAL | |
Quantity | REAL | |
Brand | VARCHAR(150) | |
Lenghth | REAL | |
Colour | VARCHAR(150) | |
StockCountry | VARCHAR(150) | |
ProductDescription | VARCHAR(150) | |
PackType | VARCHAR(150) | |
Volume_litre | REAL | |
Warranty | VARCHAR(150) | |
Weight_kg | REAL | |
Height | REAL | |
Price | REAL |
Transactions_1NF | ||
PK1 | CartID | INTEGER |
PK2 | Barcode | VARCHAR(150) |
PK3 | Username | VARCHAR(150) |
Total | REAL | |
InvoiceDate | DATETIME |
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