Please only answer if you are familiar with Database .

You have a sample store receipt that contains sales details. Please design a database to collect data associated with all sales transactions. There may be more fields needed collected which are not included in the receipts.

1. Identify minimal sets of functional dependencies

.

AAA Electronic Store 10/14/2018 ITEM QTY PRICE TOTAL CTO IPAD 014728348 Model A2014, Serial Number: 14205718 CTO APPLECARE. $1,249.00 $1,249.00 014907757 Serial Number: 14205720 CTO APPLE ACCESSORY Smart Keyboard, 5129.00 $129.00 014842627 Serial Number: 14205721 $199.00 $19900 E-WASTE FEE 011029172 55.00 $5.00 Subtotal $1,582.0o Total Sales Tax $115.84 Total $1,697.8 Gift Card Account Number: 693x 30OCK 0OCx 4432 Auth# : 1207152626329207429871 Available Balance: $2.72 5800 00 Credit Card: Visa Account: 3476 Autha 1207152626329406801327 5897 84 Associate: Christina Lopez Customer Information ohn Smith 5500 University San Bernardino, CA 92407