Hello,
The following question is a Database question. Please only answer if you are familiar with Database and SQL specifically. Please answer Question Number 5.
Please answer the following questions 1. Identify minimal sets of functional dependencies 2. Step-wise normalization up to BCNF A. O-NF/UNF B.1-NF C. 2-NF D.3-NF/BCNF 3. Represent normalization results in E-R Diagram 4. Using SQL solve the following inquiries A. If the associate can receive 1% of total net sales (exclude tax and government fees) as the bonus. what is the amount of bonus that Christina Lopez received in year 2018 B. Find all gift cards that have a balance below $1.00 C. Please find out the total amount accumulated from all cards on question b 5. Please use Relational Algebra to represent queries in question4 You have a sample store receipt that contains sales details. Please d with all transactions. Ther esign a database to collect data associated e may be more fields that need to be collected which are not include in the receipts AAA Electronic Store 7/14/2018 QTY Price Total Item CTO iPad, 014728348Model A2014 $1,249.00 $1,249.00 Serial Number: 14205718 CTO APPLECARE, 014907757 Serial Number: 1420570 $129.00 $129.00 CTO Apple Accessory Smart Keyboard, 014842627 Serial Number: 14205721 E-Waste Fee 011029172 Subtotal Total Sales Tax Total Gift Card Account Number: 69xx XXxx XXXX 4332 Auth# 1207152626329207429871 Available Balance: $2.72 Credit Card: VISA Account: 3476 $199.00 $199.00 $5.00 $5.00 $1,582.00 $1,697.84 $800.00 Auth#: 120715262329406801327 $897.84 Associate: Erika Guitierrez Customer Information John Smith 12345 Parkway Hollywood, CA, 33024 Please answer the following questions 1. Identify minimal sets of functional dependencies 2. Step-wise normalization up to BCNF A. O-NF/UNF B.1-NF C. 2-NF D.3-NF/BCNF 3. Represent normalization results in E-R Diagram 4. Using SQL solve the following inquiries A. If the associate can receive 1% of total net sales (exclude tax and government fees) as the bonus. what is the amount of bonus that Christina Lopez received in year 2018 B. Find all gift cards that have a balance below $1.00 C. Please find out the total amount accumulated from all cards on question b 5. Please use Relational Algebra to represent queries in question4 You have a sample store receipt that contains sales details. Please d with all transactions. Ther esign a database to collect data associated e may be more fields that need to be collected which are not include in the receipts AAA Electronic Store 7/14/2018 QTY Price Total Item CTO iPad, 014728348Model A2014 $1,249.00 $1,249.00 Serial Number: 14205718 CTO APPLECARE, 014907757 Serial Number: 1420570 $129.00 $129.00 CTO Apple Accessory Smart Keyboard, 014842627 Serial Number: 14205721 E-Waste Fee 011029172 Subtotal Total Sales Tax Total Gift Card Account Number: 69xx XXxx XXXX 4332 Auth# 1207152626329207429871 Available Balance: $2.72 Credit Card: VISA Account: 3476 $199.00 $199.00 $5.00 $5.00 $1,582.00 $1,697.84 $800.00 Auth#: 120715262329406801327 $897.84 Associate: Erika Guitierrez Customer Information John Smith 12345 Parkway Hollywood, CA, 33024
