CSC210S2022SyllabusHome4 < CenterForComputing

Tags: view all tags
---++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.
Topic revision: r1 - 2022-03-15 - cathybareiss