Retrieving Data From Multiple Tables Week 5 CIS 336

customers

PKcustomer_idINTEGER

customer_first_nameVARCHAR(20)

customer_last_nameVARCHAR(20)

customer_addressVARCHAR(50)

customer_cityVARCHAR(20)

customer_stateCHAR(2)

customer_zipCHAR(5)

customer_phoneCHAR(10)

customer_faxCHAR(10)

orders

PKorder_idINTEGER

order_dateDATETIME

shipped_dateDATETIME

FK1customer_idINTEGER

FK2employee_idINTEGER

items

PKitem_idINTEGER

titleVARCHAR(40)

unit_priceDECIMAL(9,2)

FK1artist_idINTEGER

order_details

PK,FK1order_idINTEGER

PK,FK2item_idINTEGER

order_qtyINTEGER

Database Model for Labs 4-7

Artists

PKartist_idINTEGER

artist_nameVARCHAR(30)

Employees

PKemployee_idINTEGER

last_nameVARCHAR(20)

first_nameVARCHAR(20)

FK1manager_idINTEGER

text�

�

Table