Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This is a Database Systems: Design, Implementation, & Management. not coding This assignment is designed to give you practice applying the normalization process on poorly
This is a Database Systems: Design, Implementation, & Management. not coding
This assignment is designed to give you practice applying the normalization process on poorly designed spreadsheets that contain data. It consists of two exercises, each of which is worth 50 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. For each exercise, give the name of each table along with the attributes, primary key field(s), and foreign key field(s) if they exist. For a given table, put its name in CAPITAL LETTERS and its attributes within parentheses (). Underline the primary key (PK) fields and italicize any foreign key (FK) fields, if they exist. If a field is both a foreign key and part of a composite primary key, both underline and itolicize it. Required fields should be in a boldface font, while optional fonts should not be in boldface (remember that required attributes must have a value in your database). 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_Iname, 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. 1. Campus Auto has a spreadsheet that consists of a single table whose small portion is shown below. Modify the spreadsheet as needed by creating additional, related tables, if necessary, so that it is not subject to anomalies. Chapter 6 Assignment CIS 171 Database Desigr 2. Campus Books is a small bookstore that keeps track of its inventory in a spreadsheet. Modify the spreadsheet as needed by creating additional, related tables, if necessary, so that it is not subject to anomaliesStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
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