Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

4 Briefly describe dividend signalling theory.

Answered: 1 week ago

Question

What concepts should be included in a financial literacy scorecard?

Answered: 1 week ago

Question

Classify delivery styles by type.

Answered: 1 week ago