Chapter 3 Assignment

1.  Identify the classes and associations in the following narrative, draw a class diagram with multiplicities, and then answer questions 1 to 8 below:

Dr. Franklin runs a small medical clinic specializing in family practice. She has many patients. When the patients visit the clinic, she may perform several tests to diagnose their conditions. She bills the patient one amount for the visit plus additional amounts for each test.

Required:

1. How many classes did you include in your diagram?

2. Which of the following best describes the names of the classes that you selected for your diagram?

3. Assume that the clinic maintains a lists of tests that it can provide to patients. That list might specify the nature of each test as well as the price to be charged for the test. The list is established before any patient visit. Which of the following best describes multiplicities that would appear next to the TESTS class in an association with a class for patient visits?

4. Assume that the clinic tracks each patient visit separately along with all the tests performed during that visit. Consider an association between the TESTS class and a PATIENT VISIT class. Which of the following best describes multiplicities that would appear next to the PATIENT VISIT class?

5. Assume that Dr. Franklin records information on her patients during the first patient visit. Consider an association between the PATIENTS class and the PATIENT VISITS class. Which of the following best describes multiplicities next to the PATIENT VISIT class?

6. Consider an association between the PATIENTS class and the PATIENT VISITS class. Which of the following best describes multiplicities next to the PATIENT class?

7. Which of the following best explains the reason why your diagram does not need a class to identify Dr. Franklin?

8. Now consider the possibility that each patient may have one insurance provider. So, your model includes an INSURANCE class. Which of the following best describes the association between that class and other classes on your diagram?

2.

Write out a set of relational tables that correspond to the class diagram that you prepared for Problem 1. Identify primary and foreign keys. Using Microsoft Access, define the tables and set up the relationships corresponding to your diagram. Then answer questions 1 to 6 below based on your tables.

Required:

1. How many relational tables are necessary to implement your model for Dr. Franklin’s clinic?

2. Which of the following is the best primary key for the TESTS table?

3. Which of the following is the best way to implement the association between TESTS and PATIENT VISITS tables?

4. Which of the following is the best option for the PATIENTS table primary key?

5. Which of the following is the best option for the PATIENT VISITS table primary key?

6. Which of the following is the best way to implement the association between PATIENTS and PATIENT VISITS tables?

3.  Required:

Develop a UML class diagram with classes, associations, and multiplicities based on the following narrative:

The Multnomah County Library provides a variety of services to citizens of the county. First, the library offers a number of traditional books and movies that may be checked out by patrons. Each patron may check out up to five books and two movies at one time. The library also offers several computers for patron use. The library tracks computer use sessions. Each patron may use the computer for up to 30 minutes per session. The library also maintains a number of small meeting rooms that patrons may reserve for classes or events during normal operating hours. Although library services are offered to all county citizens, each patron must obtain a library card to check out books, use the computers, or reserve a room.

Which of the following is the best name for the class designated as A in the diagram?

4.

Which of the following is the best name for the class designated as B in the diagram?

5.

Which of the following is the best name for the class designated as C in the diagram?

6.

Which of the following is the best name for the class designated as D in the diagram?

7.

Which of the following is the best name for the class designated as E in the diagram?

8.

Which of the following is the best option for multiplicities to replace F in the diagram?

9.

Which of the following is the best option for multiplicities to replace G in the diagram?

10.

Which of the following is the best option for multiplicities to replace H in the diagram?

11.

Which of the following is the best option for multiplicities to replace I in the diagram?

12.

Which of the following is the best option for multiplicities to replace J in the diagram?

13

Use the UML class diagram to create an Access database for the library. Make up at least three fields for each table including one field that will be the primary key. Then, answer the following questions based on your Access tables.

Required:

1. Match each of the tables with the corresponding primary key from the list of primary keys.

2. Match each of the tables with a primary key from the list of primary keys that would be posted in the table as a foreign key.