ER Homework 1

This homework is designed to get you familiar with Oracle's Data Modeler software so that you can design database systems.

Assignment

Create an ER diagram to model the relationship between food items, a menu, and a bill for a restaurant. You may create unique ids if you wish but you should also indicate if there is a combination of attributes that could also be a key. Use common sense to decide about optional conditions

• An item has:
  • a description
  • a short name
  • a size
  • a price
  • a set number of calories
• A menu
  • There are two menus: An adult and a child
  • Menus have many items on them
• A bill
  • A bill has a date and time
  • Has a number that is unique only for a given date and time
  • Has a bunch of items on it (some of which can be duplicated)

Submission requirements

• Your diagram must be done using the class standard format
• Your diagram must contain your name
• Your diagram should fit nicely on one page (all I should have to do is print it)
• You need to combine the file and the folder together into a zip file and submit that zip file.