Database Designed by Andrew Thorsen -- CS 325 - Fall 2017
Used by Drew Hengehold 2025
Date last mod: 10/30/2017
Table Model
Employee(EMPL_ID, empl_lname, empl_fname, empl_dicount, empl_salary, empl_phone,)


Empl_emails(EMPL_ID, EMPL_EMAIL)
        Foreign key (empl_id) references Employee


Customer(CUST_NUM, cust_type, cust_lname)


Guest(CUST_NUM)
        foreign key (cust_num) references Customer


Member(CUST_NUM, mem_lname, mem_reward, mem_fav_tea, mem_email, mem_address,
                mem_discount)
        foreign key (cust_num) references Customer


Reservation(RES_NUM, Cust_numnu, Res_date, Num_of_guests)
        Foreign key (cust_num) references Customer


Sale(SALE_NUM, Sale_amt, cust_num, empl_id)
        Foreign key (cust_num) references Customer 
        Foreign key (empl_id) references Employee


Sale_item(ITEM_ID, item_type, Item_name, Stock_quantity, Item_price)


Tea(ITEM_ID, tea_brand, tea_type, tea_style)
        Foreign key(item_id) references sale_item


food(ITEM_ID)


Sale_line_item(SALE_NUM, ITEM_ID, quant)
        Foreign key (sale_num) references Sale
        Foreign key (item_id) references Sale_item