Database Systems: Design, Implementation, & Management
Database Systems: Design, Implementation, & Management
11th Edition
ISBN: 9781285196145
Author: Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher: Cengage Learning
Expert Solution & Answer
Chapter 4, Problem 7P

Explanation of Solution

Entity Relational (ER) Diagram:

The following figure illustrates the ER Diagram for given business rules using Crow’s Foot notation:

Explanation:

The above ERD, contains several entities such as “VOLUNTEER”, “ASSIGNMENT”, “LIST”, “ACTION”, “ITEM”, “PACKAGE_CONTENT” and “PACKAGE”. Each entity has its own attributes.

  • A volunteer can have assignment for several tasks. Similarly, a task can be done by several volunteers. Hence the relationship between the entities “VOLUNTEER” and “ACTION” is M: N...

Blurred answer
Students have asked these similar questions
Using the Crow’s Foot notation, create an ERD that can be implemented for a medical clinic, using the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. Show all connectivities, relationship…
Using the Crow's foot notation,create an ERD that can be implemented for a medical clinic using the following business rules:A patient can make many appointments with one or more doctors in the clinic,and a doctor can accept appointments with many patients.however each oppointment is made with only one doctor and one patient.Emergency patients do not ned an appointment .However,for appointment management purposes,an emergency is entered in the appointment book as"unscheduled."If kept,an appointment yields a visit with the doctor specified in the appointment.The visit yields a diagnosis and ,when appropriate, treatment.With each visit,the patient's records are updated to provide a medical history.Each patient visit creates a bill.Each patient visit is billed by one doctor,and each doctor can bill many patients.Each bill must be paid.However a bill may be paid in many instalments,and a payment may cover more than one bill.A patient may pay the bill directly,or the bill may be the basis…
Suppose we want to develop a browser-based training system to help people prepare for such a certification exam. A user can request a quiz for the system. The system picks a set of questions from its database, and compose them together to make a quiz. It rates the user’s answers, and gives hints if the user requests it. In addition to users, we also have tutors who provide questions and hints. And also examinators who must certify questions. List down the functional requirements of the above said system? Use Form based method for specifying   “Make Quiz” functional requirement
Knowledge Booster
Similar questions
  • Consider a school system in which data is recorded about the movie industry. The data requirements are summarized as follows: Each subject is owned by a department and each department ismanaged by a teacher, called Head of Department (HOD). Eachdepartment has a name and a unique code number. Each subjecthas a name, unique number and credit value. All teachers have aunique ID. A HOD cannot manage more than one department at atime. Also, a HOD does not teach subjects. A subject cannot betaught by more than one teacher. Finally, the system needs toknow each student’s contact details, including, full name, studentID, address, age and gender, as well as date of enrolment in thesubject. Design an Entity-Relationship diagram for the movie database
    Using the Crow’s Foot methodology, create an ERD that can be implemented for a medical clinic, using at least the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor and one patient. Emergency cases do not require an appointment. However, for appointment management purposes, an emergency is entered in the appointment book as “unscheduled.” If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. With each visit, the patient’s records are updated to provide a medical history Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be paid in many installments, and a payment may cover more than one bill. A patient may pay the bill…
    The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
  • The objective is to create a system that allows you to completely manage the functions of thecompany through an optimal design of the data model, to be adapted to a system connected to aSQL database. StatementThe pharmacy chain “Recetas Rayos X” needs a system to manage information about its operations, such as the purchase, sale and administration of medications, other patients and who prescribed them.a medicine. The information that must be stored is the following:1. Patients are identified by the RUT and the name, surname, date of birth, email,address, several telephone numbers and pension system.2. There are various health provisions, both social and private, and they are correctly codified.3. Doctors are identified by the RUT. For each doctor you have to store the first name, last name,date of birth, specialties and years of practice.4. There are various specialties which are adequately codified.5. Each pharmaceutical company is identified by a code, the name and a telephone…
    Damon Davis was creating the Drano Plumbing Company's spreadsheet. He determined that the net income would be $50,000. When he tallied the columns on the Balance Sheet, the totals were as follows: debit, $400,000; and credit, $300,000. What was the most likely reason for this discrepancy? If this was not the case, how should he proceed to determine the source of the error?
    Question 1: Create an ERD that can be implemented for a medical clinic, using at least the following business rules:                                                                            A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor, and each appointment references a single patient.   Emergency cases do not require an appointment. However, an emergency is entered into the appointment book as "unscheduled" for appointment management purposes.   If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment.   Each visit updates the patient's records to provide a medical history.   Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients.   Each bill must be paid. However, a bill may be…
  • ABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…
    ABC is a pharmaceutical company that recruits volunteers for clinical trials on drugscurrently under development at the company. The company conducts multipleclinical trials concurrently. Each clinical trial is assigned a trial code together with description of theclinical trial, start date, end date, and the lead scientist. Each clinical trialinvolves at least one treatment, and each treatment belongs to only one trial.Treatment has its conduct date. When volunteers sign up for a treatment of a clinical trial, their contact detailsincluding full name, address, contact number, email address, as well as theirunique volunteer number are recorded. Each volunteer is involved in at leastone treatment, while each treatment is tested on at least 30 volunteers. In addition, medical details for each volunteer including weight, height, bloodtype, race, gender, and medical condition are also recorded separately. At each treatment each volunteer involves a specific drug of certain type,…
    Consider a fast food restaurant in which employees take orders for food from customers. The data requirements are summarized as follows: The restaurant has employees, each identified by a unique employee number, first and last name. Each customer of the restaurant is identified by a unique customer number, first and last name. Each food item sold is identified by a unique number, a name, price, and quantity in stock. Each order placed by a customer is taken by an employee and is given a unique number. Each order contains specified quantities of one or more food items. Each order has a date of receipt and order time. The actual delivery time is also recorded. Construct an ER diagram for this application.                                              (CLO  1)
    • SEE MORE QUESTIONS
    Recommended textbooks for you
  • Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Information Technology Project Management
    Computer Science
    ISBN:9781337101356
    Author:Kathy Schwalbe
    Publisher:Cengage Learning
  • Database Systems: Design, Implementation, & Manag...
    Computer Science
    ISBN:9781305627482
    Author:Carlos Coronel, Steven Morris
    Publisher:Cengage Learning
    Information Technology Project Management
    Computer Science
    ISBN:9781337101356
    Author:Kathy Schwalbe
    Publisher:Cengage Learning