Ch.2 - 1. An AGENT can have many CUSTOMERs. Each CUSTOMER...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1. An AGENT can have many CUSTOMERs. Each CUSTOMER has only one AGENT. 6. The relationship types and business rules are as follows: Region- 1M- Store: A region can have many stores. Each store is located in one region. Store-1M-Employee: One store can employee many employees. Each employee works in only one store. Job-1M-Employee: A job can be held by many employees. Each employee holds only one job. 8. COURSE 1: M CLASS A course can generate many classes. Each class is a section of only one course. CLASS 1: M ENROLL A class can enroll many students. ( This means that a class can appear many times in the ENROLL table— that's because a class can have many students.) STUDENT 1: M ENROLL A student can enroll in many classes. ( This means that a student can appear many times in the ENROLL table— that's because a student can take more than one class.) 9. 25. a. Each   of   the   MegaCo   Corporation’s   divisions   is   composed   of   many  departments. Each of those departments has many employees assigned to it, 
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/03/2010 for the course CMPSC 121 taught by Professor Crawford,georgew during the Spring '07 term at Penn State.

Page1 / 5

Ch.2 - 1. An AGENT can have many CUSTOMERs. Each CUSTOMER...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online