Sign In Sign-Up

Section 5 lesson 2

Journal Writing: 6:50 - 7:05
Prepare day for oracle on line course
Morning Lecture: 7:10- 7:45
Activity Assignment: 7:45 - 8:30

1. Review Homework and Sept. 13 Class Activities.(Section 5 lesson 1 try it/solve it)

• Work through the lesson, and watch the videos
• Try It/ Solve It

Activity: Clubs Slide 8/10: ( Students in the Business Department join BPA (Business Professionals of America)

Draw an entity relationship diagram to represent the following:

• (a) Each CLUB must be assigned to one and only DEPARTMENT
• (b) Each DEPARTMENT may be responsible for one or more CLUBs
• (c) Each STUDENT may join one or more CLUBs
• (d) Each CLUB may be composed of one or more STUDENTs

Activity: Activity: Global Fast Foods Orders and Items Slide 9/10 - 10/10

You will be adding to the Global Fast Foods ERD. Here is what we’ve modeled so far (slide 9/10): You may work in groups, but each student must submit the completed assignment with a computer printout. List each members name on the printout and the students submitting their copy must list their name at the top of the list and place a check mark next to your name.. Please read and follow instructions.

Read the notes from a conversation with the Global Fast Foods owner and modify the ERD as needed:

"You were asking about the items that can appear on an order? Well, mostly it's food items, but sometimes a customer can also purchase a frequent-diner card. This card entitles a customer to discounts at our restaurant. Also, if a customer buys this card, we can get information such as name and address. This way we can send the customer coupons and other promotional materials. The other benefit to us is that we can now track which items the customer likes to order regularly. When a customer comes in and uses the card, we now have a record of the orders placed with that particular card.

"Each customer can have one frequent-diner card, and each card is for only one customer. Only one frequent-diner card can be used to place an order.

"We have a variety of food items on our menu. Each order is for one or more food items. And, of course, a food item (a hamburger, for example) can appear on many orders."