Pine Valley Furniture Company has implemented electronic payment methods for some customers. These customers will no longer require an invoice. The send- Invoice and receivePayment methods will still be used for those customers who always pay by cash or check. However, a new method is needed to receive an electronic payment from those customers who use the new payment method. How will this change impact the Pine Valley Furniture class diagram? Redraw the diagram to include any changes that you think are necessary.

In the given Chapter, we presented a case study for the Fitchwood Insurance Agency. As you may recall, we developed the E-R diagram shown in the given Figure for this agency. Convert this E-R diagram into a class diagram. State any assumptions that you make.

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships, for the following situation: Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security Consultants. Fin and Finicky consults with corporations to determine their security needs. You have been hired by Wally and Henry to design a database management system to help them manage their business. Due to a recent increase in business, Fin and Finicky has decided to automate its client tracking system. You and your team have done a preliminary analysis and come up with the following set of classes, attributes, and business rules: consultant There are two types of consultants: business consultants and technical consultants. Business consultants are contacted by a business in order to first determine security needs and provide an estimate for the actual services to be performed. Technical consultants perform services according to the specifications developed by the business consultants. Attributes of business consultant are the following: employee ID (identifier), name, address (street, city, state, zip code), telephone, date of birth, age, business experience (number of years, type of business [or businesses]), degrees received. Attributes of technical consultant are the following: employee ID (identifier), name, address (street, city, state, zip code), telephone, date of birth, age, technical skills, degrees received. customer Customers are businesses that have asked for consulting services. Attributes of customer are customer ID (identifier), company name, address (street, city, state, zip code), contact name, contact title, contact telephone, business type, and number of employees. Location Customers can have multiple locations. Attributes of location are customer ID, location ID (which is unique only for each customer ID), address (street, city, state, zip code), telephone, and building size. service A security service is performed for a customer at one or more locations. Before services are performed, an estimate is prepared. Attributes of service are service ID (identifier), description, cost, coverage, and clearance required. Additional Business Rules In addition to the classes outlined above, the following information will need to be stored and should be shown in the model. These may be classes, but they also reflect a relationship between more than one class: Estimates: date, amount, business consultant, services, customer Services performed: date, amount, technical consultant, services, customer In order to construct the class diagram, you may assume the following: A customer can have many consultants providing many services. We wish to track both actual services performed and services offered. Therefore, there should be two relationships between customer—service and consultant—one to show services performed and one to show services offered as part of the estimate.

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation: An international school of technology has hired you to create a database management system in order to assist in scheduling classes. After several interviews with the president, you have come up with the following list of classes, attributes, and initial business rules: room Attributes: buildingID, roomNo, capacity Room is identified by buildingID and roomNo. A room can be either a lab or a classroom. If it is a classroom, it has an additional attribute called board type. Media type Attributes: mTypeID (identifying attribute), typeDescription Please note: We are tracking the type of media (such as a VCR, projector, etc.), not individual pieces of equipment. Tracking of equipment is outside of the scope of this project. computer type Attributes: cTypeID (identifying attribute), typeDescription, diskCapacity, processorSpeed Please note: As with Media Type, we are tracking only the type of computer, not individual computers. You can think of this as a class of computers (e.g., those based on a 3.4 GHz Intel Core i7 processor). instructor Attributes: empID (identifying attribute), name, rank, officePhone time slot Attributes: tsID (identifying attribute), dayofWeek, startTime, endTime course Attributes: courseID (identifying attribute), courseDescription, credits Courses can have one, none, or many prerequisites. Courses also have one or more sections. Section has the following attributes: sectionID, enrollmentLimit After some further discussions, you have come up with some additional business rules to help create the initial design:

• An instructor teaches one, none, or many sections of a course in a given semester.
• An instructor specifies preferred time slots.
• Scheduling data is kept for each semester, uniquely identified by semester and year.
• A room can be scheduled for one section or no section during one time slot in a given semester of a given year. However, one room can participate in many schedules, one schedule, or no schedules; one time

Doctors Information Technology (DocIT) is an IT services company supporting medical practices with a variety of computer technologies to make medical offices more efficient and less costly to run. Medical offices are rapidly becoming automated with electronic medical records, automated insurance claims processing and prescription submissions, patient billing, and other typical aspects of medical p actices. In this assignment you will address only insurance claims processing; however, what you de elop must be able to be generalized and expanded to these other areas of a medical practice. Your assignment is to draw a class diagram showing the relevant classes, attributes, operations, and relationships to represent each phase of the development of an insurance claims processing system. a. The first phase deals with a few core elements. Draw a class diagram to represent this initial ph ase, described by the following:

• A patient is assigned a patient ID and you need to keep track of a patient’s gender, data of birth h, name, current address, and list of allergies.
• A staff member (doctor, nurse, physician’s assistant, etc.) has a staff ID, job title, gender, nam e, address, and list of degrees or qualifications.
• A patient may be included in the database even if no staff member has ever seen the patient (e.g., family member of another patient or a transfer from another medical practice). Similarly, some sta ff members never have a patient contact that requires a claim to be processed (e.g., a receptionis t greeting a patient does not generate a claim).

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation: Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed the following list of business rules and specifications:

• Customers place orders through a branch.
• Wally would like to track the following about customers: name, address, city, state, zip code, telephone, date of birth, and primary language.
• A customer may place many orders.

• A customer does not always have to order through the same branch all the time.
• Customers may have one or more accounts, and they may also have no accounts.
• The following information needs to be recorded about accounts: balance, last payment date, last payment amount, and type.
• A branch may have many customers.
• The following information about each branch needs to be recorded: branch number, location (address, city, state, zip code), and square footage.
• A branch may sell all items, or may sell only certain items.
• An order is composed of one or more items.
• The following information about each order needs to be recorded: order date and credit authorization status.
• Items may be sold by one or more branches.
• Wally wants to record the following about each item: description, color, size, pattern, and type.
• An item can be composed of multiple items; for example, a dining room wallcovering set (item 20) may consist of wallpaper (item 22) and borders (item 23).
• Wally employs 56 employees. He would like to track the following information about employees: name, address (street, city, state, zip code), telephone number, date of hire, title, salary, skill, and age.
• Each employee works in one and only one branch.
• Each employee may have one or more dependents. Wally wants to record the name of the dependent as well as the age and relationship.
• Employees can have one or more skills. Indicate any assumptions that you have made.

Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for the following situation:

Emerging Electric wishes to create a database with the following classes and attributes:

Customer $\quad$ with attributes customerID, name, address (street, city, state, zipCode), telephone

Location $\quad$ with attributes locationID, address (street, city, state, zipCode), type (business or residential)

Rate $\quad$ with attributes rateClass, ratePerKwh

After interviews with the owners, you have come up with the following business rules:

• Customers can have one or more locations.

• Each location can have one or more rates, depending upon the time of day.

An organization has been entrusted with developing a registration and title system that maintains information about all vehicles registered in a particular state. For each vehicle that is registered with the office, the system has to store the name, address, and telephone number of the owner; the start date and end date of the registration; plate information (issuer, year, type, and number); sticker (year, type, and number); and registration fee. In addition, the following information is maintained about

Refer to the class diagram for hospital relationships (Figure 14-9b). Add notation to express the following business rule: A resident patient can be assigned a bed only if that patient has been assigned a physician who will assume responsibility for the patient’s care.

State the activities involved in each of the following phases of the object-oriented development life cycle: object-oriented analysis, object-oriented design, and object-oriented implementation.

A bank has three types of accounts: checking, savings, and loan. The following are the attributes for each type of account:

CHECKING $\quad$ acctNo, dateOpened, balance, serviceCharge

SAVINGS $\quad$ acctNo, dateOpened, Balance, interestRate

LOAN $\quad$ acctNo, dateOpened, Balance, interestRate, payment

Assume that each bank account must be a member of exactly one of these subtypes. At the end of each month, the bank computes the balance in each account and mails a statement to the customer holding that account. The balance computation depends on the type of account. For example, a checking account balance may reflect a service charge, whereas a savings account balance may include an interest amount. Draw a class diagram to represent the situation. Your diagram should include an abstract class, as well as an abstract operation for computing the balance.

Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram): SeeALeopard (SAL) is a company that organizes tours in the Kruger National Park in South Africa. These tours last several hours and sometimes an entire day. They do not, however, include an overnight stay in the park. The company serves both travel agents and other organizers of multiday trips and individual customers who are traveling on their own. Organizers of multiday trips can get credit from SAL up to an approved credit limit as long as they negotiate this with SAL in advance, and they typically have a negotiated discount rate with SAL. The credit limit and the discount rate are elements of a contract; one trip organizer can have only one contract at one point in time with SAL, but it is important that contract history be maintained. Individual travelers can register with SAL if they want to. They can also ask SAL to store their preferred mode of payment (typically a

Draw a class diagram to model the following situation (state any assumptions you believe you have to make in order to develop a complete diagram, and add any attributes that you believe are necessary to provide the specified service): A landscaping company offers snow removal services in a region consisting of eight cities and towns that all belong to a large metropolitan area. The company wants to use an IT solution to support its goal of providing its customers with the highest level of service. It negotiates a separate service contract with each of its customers for every winter season; the contract specifies the snow amount threshold for triggering a removal request (based on information received from the cities and towns electronically), the services that are included (such as driveway, walkway, front stairs, back stairs), a map of areas to be cleaned, and pricing for different amounts of snow received during a storm. In addition, each customer can specify three special event days for the season during which the customer will get an automatic highest possible priority for the timing of snow removal. Otherwise, route planning is based on the company’s own optimization needs, the length of time a customer has been with the company, and priority positioning fees some customers pay. During each snowstorm, the company maintains and makes available for its customers on the Web a snow removal schedule, which is updated as necessary with explanations regarding the changes. It also provides its customers with current location information for each of its removal units, which is updated once every 30 seconds. Once a snow removal job has been completed, this information is updated in the system, with pictures verifying the completion.

Draw a class diagram for the following situation (state any assumptions you believe you have to make in order to develop a complete diagram): A consulting firm is organized as a partnership with five different types of employees: senior partners, junior partners, senior associates, associates, and assistants. Each employee has an annual salary; partners and associates also have a billing rate specified for them. The firm needs to also know the amount of money each of the partners (both junior and senior) has invested in it. It is important for the firm to keep track of the history of salaries and billing rates. The firm works with a large number of clients; at any point in time, the firm may have several simultaneous engagements with any of the clients (or none). For each engagement, there is a billing factor that depends on the nature of the engagement; for final billing purposes, each employee’s billing rate is multiplied by the factor to determine the actual hourly rate charged for each employee’s work. Employees are required to specify (with an application running on their smart phones) every transition from one engagement to another so that billable hours can be recorded with the highest level of accuracy possible.