John's database tables SALES Customer ID (primary key) Date of purchase Item code(foreign key) 001 2/05/2021 A-1 002 3/05/2021 B-1 003 4/05/2021 C-1 004 5/05/2021 D-1 005 6/05/2021 E-1 ITEM LIST Item...


John's database tables


SALES



































Customer ID (primary key)Date of purchaseItem code(foreign key)
0012/05/2021A-1
0023/05/2021B-1
0034/05/2021C-1
0045/05/2021D-1
0056/05/2021E-1

ITEM LIST






























Item code(primary key and foreign key)Item nameQuantity
A-1Bread35
B-1Milk45
C-1Egg12
D-1Tea20

PRICE LIST






























Item code(primary and foreign key)Item costTotal price
A-115525
B-115675
C-1896
D-120400

Design a logical view for the tables



Jun 04, 2022
SOLUTION.PDF
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions ยป

Submit New Assignment

Copy and Paste Your Assignment Here
Have files?