Sign In Sign-Up

Oracle Assignments for Section 6 and 7:

Vocabulary Test  Sections 9 and 10----------Tuesday, October 5, 2004

Daily:  Monday,

Section 10: Lesson 1, 2, 3, Review Test: (Unit 4 Internet Research)

Assignment:

• "Try It/Solve It"
  Activity : lesson 10 Lesson, Lesson 2, Lesson 3
• Speeding Ticket (slide 7)

  Each police officer may issue speeding tickets to motorists in an assigned area. Originally, the attribute date was modeled as part of the SPEEDING TICKET entity. However, the city police department wants to see if there is a relationship between weather and the frequency of speeding tickets -- do people drive faster on nice sunny days? Are there more tickets in hot weather or cool weather?Modify the ERD to address this new requirement. (slide 7)

• Classrooms and Exams -- A Time-Constrained Model (slide 8)

  (1) Why is start time part of the UID of ASSIGNMENT?
  (2) Examine the ERD that represents classroom assignments for different exams. Name at least three time-related constraints. Indicate if the constraint represents conditional nontransferability.
  

• Activity: Lesson 2, When a student’s grade is changed, we need to record information on the teacher who changed the grade and the reason for the change.

  Start with the ENROLLMENT entity, which is the resolution of the M:M between STUDENT and CLASS.
  

• Activity: Lesson 3Activity: Characteristics of Adoption Days
  Make modificatons to your animal-shelter ERD based on these additional requirements.
  
  (1) Even though we did not require employees of the shelter to be part of the design, we do need to know which employee received the animal at the shelter. No need to tie it to our employee system -- we just want to capture the name.

  (2) We also need to know the date and time the animal was taken in at the shelter.

  (3) We also need to know special information about the date the animal is adopted (was the date a holiday?) and special notes about the date. For special notes, we'd like to know things such as, "general weather conditions" or "schools finish this week for summer."

  We’re trying to find trends that affect animal adoption. We need this information so that we can give good reports to our staffing manager about the number of employees needed for each shift and on special days of the year. You don't need to design information about "shifts" (we already have that in the other system).

• Vocabulary test : Tuesday Sections 9 and 10
• Tuesday- Vocabulary for Section 11/12 Due

Everything not finished in class must be finished for homework.