Hello,

The following question is a Database question. Please only answer if you are familiar with Database and SQL specifically. Please answer Question Number 2.

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