Access over 35 million academic & study documents

Database Tables

Content type
User Generated
Subject
Application Writing
Type
Homework
Rating
Showing Page:
1/3

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/3

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/3

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
DATABASE TABLE NAME: DATE: During your weekly trip to the grocery store, you purchase bread, milk, cold cereal, bananas, and ice cream. The purchase was made using a debit card. Create a table listing at least seven (7) data items collected in this transaction and how they are entered into the system The information will be entered into the system in 2 separate tables. The first table will be items table and the purchase table The data for the first table (items table) include: item_id (varChar) item_name(varChar(20)) item_quanitity(int) item_unit_price(decimal) item_unit_price(decimal) Item_id(pk) item_name item_quantity item_unit_price item_unit_price A1 Milk 10 pkts 9.90 0.99 A2 cold_cereal 1 box 10.00 10.00 A3 bananas 10 pieces 10.00 1.00 A4 ice_cream 7kg 24.00 24.00 The data for the second table (purchase_table) include: userId(varChar(20)) user_name(var ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents