Normalize the below given scenario about Bill Receipt to Unnormalized , First Normal Form , Second Normal Form and Third Normal Form with Primary keys
Normalize the below given scenario about Bill Receipt to Unnormalized , First Normal Form , Second Normal Form and Third Normal Form with Primary keys and foreign keys.
BILL NO: B12567 DATE: 9/5/20 TIME: 4:00 PM PAYMENT METHOD: CREDIT CARD RECEPTIONIST ID: E78 RECEPTIONIST NAME: ALI ITEM NAME MILK PEPSI BROWN BREAD CATEGORY DAIRY SWEETENED SOFT DRINK BREAD ABC LLC. Bill Receipt EXPIRY DATE 05/07/20 01/03/21 10/09/20 UNIT PRICE 1 OMR 300 BAIZA 400 BAIZA BUYER ID: C123 BUYER NAME: Yasir Al-Balushi CARD NO: 9158 xxxx xxxx 1550 QUANTITY TOTAL 1 5 1 1 OMR 1 OMR 650 BAIZA 400 BAIZA GRAND TOTAL:3 OMR 50 BAIZA
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Normalized Bill Receipt Scenario Unnormalized Bill No Date Time Buyer ID Buyer Name Card No Payment Method Receptionist ID Receptionist Name Item Category Expiry Unit Quantity Price Total B12567 9520 ...
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
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
31st Edition
1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516
