I was wondering if someone could show me how to do the following 3 questions?

Chapter 6 Assignment CIS 171 Database Design This assignment is designed to give you practice applying the normalization process on poorly designed tables that contain data. It consists of five exercises, each of which is worth 20 points, for a total of 100 points possible. The objective for each exercise is for you to transform the existing table into a set of tables, each of which is at least in third normal form. Some sample data has been provided to help you identify dependencies between attributes. Beware, however, that while data can help you identify dependencies, it does not always reveal every dependency and can sometimes even obfuscate some of the dependencies that do exist. For each exercise, describe the name of each table along with the attributes, primary key field(s), and foreign key field(s) if they exist. You do not need to show the work that led you to your solution. Be sure to work through the checklist at the end of the process to make sure your tables are optimally designed. Use the notation described in the normalization process document described in class to express your answers. For a given table, put its name in capital letters and its attributes within parentheses. Underline the primary key fields and italicize any foreign key fields, if they exist. If a field is both a foreign key and part of a composite primary key, both underline and italicize it. Required fields should be in a boldface font, while optional fonts should not be in boldface. The table's name should be bold faced as well. Here's an example of a set of normalized tables properly described: CUSTOMER (cust_id, cust_fname, cust_lname, cust_email, cust_phone) ORDER (order_id, cust_id, order_date) INVOICE (order_id, prod_id, prod_quantity, prod_price) PRODUCT (prod_id, prod_name, prod_description, prod_price, prod_qty_in_stock) Place the answers within a Word document. Place your name, the course, submission date, and assignment number at the top. Be sure to clearly label each exercise as you present your answers. Submit your work within Blackboard on or before the assignment deadline which is posted in the course schedule. Be sure to check the rubric when your work is graded for specific details on how your work was assessed