Post your solutions to the March 8 In-Class Exercise to this thread. Best, Chris

-- Mar 8 In-Class Exercise

Dean Johnson ((resource:IMG_1360.JPG|Resource Description for IMG_1360.JPG))

-- Mar 8 In-Class Exercise

 user_table 		(user_id, user_name, password)
 item_table 		(item_id, item_name, item_desc, item_price, item_qty)
 category_table 	(ctgy_id, item_id)
 order_table 		(order_id, user_id, order_date, tot_price)
 order_desc_table 	(order_id, item_id, order_item_price, order_item_qty)

 user_id 		--> user_name, password
 item_id 		--> item_name, item_desc, item_price, item_qty
 ctgy_id 		--> item_id
 order_id 		--> user_id, order_date, tot_price
 order_id, item_id 	--> order_item_price, order_item_qty

Rohan Kumar ---- '''Table (Columns):''' user_table (user_id, user_name, password) item_table (item_id, item_name, item_desc, item_price, item_qty) category_table (ctgy_id, item_id) order_table (order_id, user_id, order_date, tot_price) order_desc_table (order_id, item_id, order_item_price, order_item_qty) '''Functional Dependency:''' user_id --> user_name, password item_id --> item_name, item_desc, item_price, item_qty ctgy_id --> item_id order_id --> user_id, order_date, tot_price order_id, item_id --> order_item_price, order_item_qty

-- Mar 8 In-Class Exercise

((resource:cs174March8.jpg|Resource Description for cs174March8.jpg))

-- Mar 8 In-Class Exercise

((resource:IMG_0941.JPG|Resource Description for IMG_0941.JPG))

-- Mar 8 In-Class Exercise

Kirtan Patel ((resource:IMG_0449.jpg|Resource Description for IMG_0449.jpg))

-- Mar 8 In-Class Exercise

Mohnish Kadakia ((resource:Mohnish_kadakia_Shopping.jpg|Resource Description for Mohnish_kadakia_Shopping.jpg))

-- Mar 8 In-Class Exercise

Richard Lack ((resource:1489012958647642594033.jpg|Resource Description for 1489012958647642594033.jpg))

-- Mar 8 In-Class Exercise

Loan Vo ((resource:CS174-Inclass-38.pdf|Resource Description for CS174-Inclass-38.pdf))

-- Mar 8 In-Class Exercise

((resource:iPhoneUpload.jpg|Resource Description for iPhoneUpload.jpg))