Oracle Programming

Try It / Solve It:

When naming the relationships below, you will need to follow the components of

ERDish:

1. EACH

2. Entity A

3. OPTIONALITY (must be/may be)

4. RELATIONSHIP NAME

5. CARDINALITY (one and only one/ one or more)

6. Entity B

The example below is what your answers should include with two ERDish sentences and a diagram of the relationship between the entities.

1. Each MANAGER may manage one or more EMPLOYEE

2. Each EMPLOYEE must be managed by one and only one MANAGER

Example of ERD for relationship above:

1. Read the given business scenario below. Name the relationships using ERDish sentences between EMPLOYEE and JOB. Draw soft boxes with the entity name and identify appropriate optionality and cardinality.

“We have a lot of employees who handle one or more different jobs. We’d like to keep track of who is working on which job. Although employees can help each other, a job is assigned to one employee and is the ultimate responsibility of that individual. All our employees have at least one job. However, there are jobs that are not yet assigned to anyone.”

ERDish Sentences (2 points):

1.

2.

ERD (2 points):

2. Read the given business scenario below. Name the relationships using ERDish sentences between ORDER and WAITER. Draw soft boxes with the entity name and identify appropriate optionality and cardinality.

“We assign our waiters to certain areas, except for our trainees, who just observe and are not responsible for taking any orders yet. A waiter takes the orders for the tables in his/her area. All areas have one assigned waiter. A customer places an order with a waiter. If the customer has a question or wants to make a change to the order, he/she needs to request this with the assigned waiter.”

ERDish Sentences (2 points):

1.

2.

ERD (2 points):

3. Read the given business scenario below. Name the relationships using ERDish sentences between PARENT and CHILD. Draw soft boxes with the entity name and identify appropriate optionality and cardinality.

“At the end of each day, parents need to pick up their children at our day-care center. All children must be picked up by 6 p.m. A child may have two parents, but we need only one of them to come and pick up their child or their children. We cannot release a child to anyone but that child’s parents.”

ERDish Sentences (2 points):

1.

2.

ERD (2 points):

4. Read the given business scenario below. Name the relationships using ERDish sentences between TEACHER and STUDENT. Draw soft boxes with the entity name and identify appropriate optionality and cardinality.

“Some students request remedial help in certain subjects, such as math. We can assign a tutor who can work with the student after class. Some of our teachers agree to be tutors. If several students need tutoring in one subject, then we assign them to the same teacher. If a student needs tutoring in several subjects, then he/she will probably be assigned to several different tutors.”

ERDish Sentences (2 points):

1.

2.

ERD (2 points):

section4:

Try It / Solve It:

1. Identify the supertype and the subtypes of the entity listed below. (10 Points)

Amputation =

Visual Impairment =

Hearing Impairment =

Disability =

Paralysis =

Stesura di ricerche

Rif. progetto: #6061360

Info sul progetto