Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. Create the following tables (Considering that your company starts a new business of catering for universities) (70 points) campuses (campus.aid, campusaname, street, city, state,
1. Create the following tables (Considering that your company starts a new business of catering for universities) (70 points) campuses (campus.aid, campusaname, street, city, state, zip, phone, campus.discount) positions (ptoid position, yealvamembership.fee) members (member.id ddsess campus.phone. campus.id. fk campus.id --> campus(campus id positionaid -> positions(position.id) prices (fooditem id mealvpe. mealaprice) fooditems (fooditemid, fooditem.name, foodaitemtypeid) tk fooditera.typedd--> prices(foodsiteret pead) food..orders (ordeid, memberid order.date) tk memberid -> members(member.id) food..order.lines ozdekid, foodaaitemsid. quantity) foodaitems.id -> fooditems(fooditem.id) * Requirements Use the proper naming convention for your constraints: Example: Constraint TableName FieldName Constraintlp .Set up the Primary Keys for each table with Constraints listed. Note: The Ordetine Table has a composite Primary Key Add Your Foreign Keys for each table with your Constraints listed
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started