|
|
Section 4 lesson 3
Journal Writing: 6:50 - 7:05
Prepare day for oracle on line course
Morning Lecture: 7:10- 7:45
Activity Assignment: 7:45 - 8:10
Assignment: Fast Food ( Progressive Project) keep all in notebooks
Assignment: Read the rest of the interview notes for Global Fast Foods and further develop the ERD -- come up with additional entities if necessary, attributes and relationships, based on the interview notes. Then present it to the class.
"I own a small fast-food restaurant. We feature food items from all around the world -- hence the name, Global Fast Foods. Employees work at the counters and take orders. An order can consist of one or more food items."I’d like to track which of my employees work the hardest -- who takes the most orders? I want to know what the busiest times of the day are, and what the busiest days of the week are. I also want to find out which food items are the most popular. I have different kinds of employees on staff, but for all of them I need to know their first name, last name, age, and phone number.
I mentioned that we have different kinds of employees and how for all of them I need to know first name, last name, age, and phone number. Oh yes, every employee gets a salary. In addition to that, I need to know other things depending on what the employee responsibilty is:
- A cook normally has some kind of training -- vocational school, self-taught, apprentice work, etc. I like to note that.
- The order taker is paid overtime on top of the standard salary. So I record how much we pay by the hour for every extra hour worked.
- The manager is reponsible for supervising all employees and has a budget for expenese and a target revenue for the restaurant that he/she is in charge of."That's it for now. As we expand, I may hire other types of employees, but I'm not sure what they would be at this time."
