Tuesday, December 27, 2005


SECTION 6 LESSON 1


SECTION 5 LESSON 2
(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

Wednesday, December 21, 2005



VIDEO STORE




SECTION 5 LESSON 1



SECTION 4 LESSON 3

Wednesday, December 14, 2005

SECTION 3 LESSON 3

B. Each employee may be assigned to one and only one department.
Each department may be responsible for one or more employees.

Each person must be born in one and only one town.
Each town may be the birthplace of one or more persons.

Each person must be living in one and only one town.
Each town may the hometown of one or more persons.

Each person may be the visitor of one or more towns.
Each town may be visited by one or more persons.

Each person may be the mayor of one and only one town.
Each town must be governed by one and only one person.

SECTION 3 LESSON 2

HARISTYLIST: first name(m), last name(m), address(o), phone number(o), social-security number(m), salary(m)
CILENT: first(m), last name(o), phone number(o)

Each haristylist may be assigned by one or more cilents.
Each cilent must assign one and only oneharistylist.

Sunday, December 11, 2005

SECTION 3 LESSON 1
a.
each job may be handled by one or more employees.
each empolyee must handle one or more jobs.
b.
each assigned waiter may take one or more orders.
each order must be taken one assigned waiter.
c.
each parent may pick up one or more children.
each child must be picked up by one parent.
d.
each teacher may teach one or more students.
each student must be taught by one or more teachers.

SECTION 2 LESSON 4

Using the partial ERD of a restaurant with entities ORDER, FOOD ITEM, AND CUSTOMER, identify the attributes for each entity.
If possible, indicate whether the attribute is mandatory or optional. Can you pick out the UIDs for each entity?

A.
ORDER----- order number, price
FOOD ITEM----- single price, food name
CUSTOMER----- last name, first name, address

B.
1.what does this report mean?
2.what data was collected?
3.what information does this table provide?
4.how do tou think these data are used?
5.generate five conclusions based on the data provided.
6.generate three questions that you could ask about the data provided.

1.the report shows the situation of the sale of different foods and the source of sales
2. 12/02/2003
3. numbers of the different foods sales and numbers of defferent source sales
4.compare which kind of food is popular and which group is the major customers
5.a. the students are the mojar customers
b. hamburger/taco bar is the most popular food
c. pizza bar is more popular
d. faculty/staff aslo buy foods
e. the fewest customers that buy foods and foods comparing to last days at last day
6.a. why fewer faculty/staff buy foods?
b. why is hamburger/taco bar most popular?
c. why do fewest foods sold at last day?

SECTION 2 LESSON 3

Concept E/A/I ? Example Instance or Entity
vehicle ,E, bus
diet coke ,I, cocacoke
price ,A ,product
cumtomer number ,A ,service center
green ,A ,color
奥力奥, E, cookie
color ,A, cookie
food, I ,cookie

SONG ----- title, release date, type
EVENT----- title, description, venue
CUSTOMER----- first name, phone number, last name, email address

Entity: STUDENT
Attributes: student ID, first name, last name, address
Entity: MOVIE
Attributes: title, date released, producer, director
Entity: LOCKER
Attributes: size, location, number

SECTION 2 LESSON 2
Discuss the business of a barbershop/hair salon. Can you name the entities that are the 搈ain things?about this business? Can you name instances of each entity?

customer( dacong), hairdresser( jiangshan),equipment( forfex ), newspaper( world journal ), ornament flower),