Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

D 4.0 Organization of Elements in Entities with Relationships At We will continue to use the DB ERD Exercise Excel file, so locate the copy you used in Section 3.0 and open it. When Section 3.0 was...

Q:

Now draw the following problems: 1) A firm wants to make a database of movies in the following way: Movies are directed by directors and acted by actors and actresses. And users will give review or...

Q:

Now draw the following problems: 1) A firm wants to make a database of movies in the following way: Movies are directed by directors and acted by actors and actresses. And users will give review or...

Q:

^Where do I put lines 27-36 in the entities tab below Also, How do I determine where private keys (pk) go and foreign keys (fk) go? I really just need the entity tab to be completed... where lines...

Q:

Assignment Summary Use LucidChart and ERD to complete the practice database design problem at then end of Tutorial A, Page 11, Problem Solving Cases When Your ERD model is complete, post a shareable...

Q:

Assignment Summary Use LucidChart and ERD to complete the practice database design problem at then end of Tutorial A, Page 11, Problem Solving Cases When Your ERD model is complete, post a shareable...

Q:

This discussion covers: The components of the Entity - Relationship Diagram ( ERD ) The rules to apply or use to map ERD into tables The SQL commands to be used to create tables and insert data...

Q:

please help me with this project! Here is the example for the assignment Term Project - Phase 1 "Planning Data Extractions to Answer Questions" Note: The Term Project (both Phase 1 and Phase 2) must...

Q:

Please help with a conceptual design (ERD - Entity Relationship Diagram) out from the rules stated. Make sure to remove all redundant relationships. Entities: Human Mage Knight Hero Spell Weapon...

Q:

QUESTION 1 100 points Save Answer Given the information below, create the fully labeled Crow's Foot ERD using a specialization hierarchy where appropriate (use Visio). The ERD must contain all...

Q:

Suppose a player receives payoffs in six consecutive periods of 1, 3, 1, 5, 2, and 8. If her discount rate is d, write an expression for the discounted payoff at time 1.

Q:

1. This is known as the policy issue resolved by the top management of an organization in view of numerous considerations. . IRR . MARR C. ERR D. ROR 2. This is the other term for MARR. A. Hurdle...

Q:

a tresury bill with 1 1 9 days to maturity is quoted at 9 7 . 6 3 0 . what are the bank discount yield, the bond equivalent yield, and the effective annual return?

Q:

True or False. " To change or modify a contract that is NOT under the UCC, new consideration must be part of the agreement."

Q:

Classify delivery styles by type.

Q:

Identify tasks and techniques associated with special presentation situations.

Q:

Demonstrate the techniques to be used when delivering an effective presentation.