Chapter $6$ Assignment

CIS $171$ Database Design

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 $0.$ Underline the primary key $($PK$)$ fields and itolicize 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 italicize 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 $($erder 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.

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 Design

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 anomalies. Im having trouble understanding on how I need to proceed with this assignment. Should I continue with lucid chart like we been doing or just continue this in Word Doc like it says in the Instructions, im a little confussed, thanks.