Difference: CSC210S2022SyllabusHome4 ( vs. 1)

Revision 12022-03-15 - cathybareiss

Line: 1 to 1

Added:

>
>

META TOPICPARENT	name="CSC210SylS2022"

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.

View topic | History: r1 | More topic actions...