i need solution for problem no 15

144 PartI Database Analysis A nonprofit organization depends on a number of dif 16. Develop an EER model for the following situation using ferent types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City/ State/Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and vol- unteers have only a Skill attribute. Donors have relationship (named Donates) with an Item entity type. A donor must have donated one or more items, and arn item may the traditional EER notation, the Visio notation, or the your supertypes no as or An international school of technology has hired you to create a database management system to assist in sched- uling classes. After several interviews with the presi- dent, you have come up with the following list of enti- ties, attributes, and initial business rules: have no donors, or one or more donors. . Room is identified by Building ID and Room No and also has a Capacity. A room can be either a lab or a classroom. If it is a classroom, it has an additional at- There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to tribute called Board Type of Media Type and Type Description. Note: Here we are tracking type of media (such as a VCR, pro- jector, etc.), not the individual piece of equipment. Tracking of equipment is outside of the scope of this two or more of these groups (e.g 13. Add a subtype discriminator (named Person Type) to the diagram you created in Problem and Exercise 12. 14. Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes . Computer is identified by CType ID and has attributes Computer Type, Type Description, Disk Capacity, and Processor Speed. Please note: As with Media Type, we are tracking only the type of computer, not an indi- vidual computer. You can think of this as a class of as specified by your instructor A technology company provides offerings to its custom- are of two separate types: products and an attribute of description. In addition, products are de- scribed by product name, standard price, and date of first release; services are described by name of the com- pany's unit responsible for the service and conditions of service. There are repair, maintenance, and other types of services. A repair service has a cost and is the repair of some product; a maintenance service has an hourly . Instructor has identifier Emp ID and has attributes Timeslot has identifier TSIS and has attributes Day Of .Course has identifier Course ID and has attributes none, or many prerequisites. Courses also have Section has identifier Section ID and attribute Name, Rank, and Office Phone Week, Start Time, and End Time Course Desc rate However, there are many potential repair services for and track of when the offering was purchased and the contact person for that offer- ing with the customer. Unfortunately, not all offerings are purchased. Customers are identified by customer ID and have descriptive data of name, address, and phone that service is billed to some customer. Because some customers pur- chase offerings for their clients, a customer may be billed for services he or she did not purchase, as well as for ones that were purchased. When a customer is billed for a service (although some may never require a ser- vice of any type), the company needs to keep track of the date the service was performed, the date the bill is a product. A customer may purchase an y needs to keep After some further discussions, you have come up with some additional business rules to help you cre- ate the initial design: number. When a service is An instructor teaches one, none, or many sections of a specifies preferred time slots. . Scheduling data are 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 one room can due, and the amount due schedules, one schedule, or no schedules; one time 15. Draw an EER diagram for the following description of a or no schedules; one section can participate in many schedules, one schedule, or no schedules. Hint: Can you associate this to anything that you have seen Each case handled by the firm has a unique case number a date opened, date closed, and judgment description are also kept on each case. A case is brought by one or more plaintiffs, and the same plaintiff may be involved in many cases. A plaintiff has a requested judgment characteristic. A case is against one or more defendants, and the same defendant may be involved in many cases A room can have one type of media, several types of Instructors are trained to use one, none, or many types A lab has one or more computer types. H classroom does not have any computers. tion. Over time, the same person or organization may be a defendant or a plaintiff in cases. In either situation, such legal entities are identified by an entity number, . A room cannot be both a classroom and a lab. There also are no other room types to be incorporated into the s and other attributes are name and net worth