A1258690194RzDtx

1
Part A E/R Model with
attributes
CC
cardtype
expdate
address
name
phone
status
cookie
timeplaced
name
description
name
address
city
price
picFileName
zip
2
Part B Relations

• Relations from Entities
• payment_info(cc, cardtype, expdate)
• orders(cookie, status, timeplaced)
• restaurants(restName, restAddress, city, zip)
• menuItems(picFileName, itemName, description)
• customers(custName, custAddress, phone)
• Relations from Relationships
• hascard(cc, cardtype, custName, custAddress)
• hasPaid(cookie, cc, cardtype)
• originates(cookie, restName, restAddress)
• serves(picFileName, restName, restAddress, price)
• favorite(custName, custAddress, picFileName,
  restName, restAddress)
• includes(cookie, picFileName)
• has(cookie, custName, custAddress)