Read the following description. "A hospital consists of a number of clinics and offers a number of treatments. Each treatment consists of a number of procedures and each procedure can be conducted at a different clinic. Doctors and nurses are medical staff and work at the hospital. A doctor can be in charge of one or more individual treatments and can perform any of the procedures that are part of the treatments they are in charge of. A nurse reports to an individual doctor and is based at an individual clinic and can perform all procedures offered by the clinic Patients make registration for the entire course of one or more treatments at the hospital but need to need to make individual appointments for each procedure of the treatment with a member of the medical staff." a) Make an Entity/Relationship model for the above description and clearly identify entities, attributes, relationships, cardinality ratios. b) Design an E/R diagram for the above description. (3)

Read the following description. "A hospital consists of a number of clinics and offers a number of treatments. Each treatment consists of a number of procedures and each procedure can be conducted at a different clinic. Doctors and nurses are medical staff and work at the hospital. A doctor can be in charge of one or more individual treatments and can perform any of the procedures that are part of the treatments they are in charge of. A nurse reports to an individual doctor and is based at an individual clinic and can perform all procedures offered by the clinic Patients make registration for the entire course of one or more treatments at the hospital but need to need to make individual appointments for each procedure of the treatment with a member of the medical staff." a) Make an Entity/Relationship model for the above description and clearly identify entities, attributes, relationships, cardinality ratios. b) Design an E/R diagram for the above description. (3)

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Similar questions

Read the following description. "A hospital consists of a number of clinics and offers a number of treatments. Each treatment consists of a number of procedures and each procedure can be conducted at a different clinic. Doctors and nurses are medical staff and work at the hospital. A doctor can be in charge of one or more individual treatments and can perform any of the procedures that are part of the treatments they are in charge of. A nurse reports to an individual doctor and is based at an individual clinic and can perform all procedures offered by the clinic Patients make registration for the entire course of one or more treatments at the hospital but need to need to make individual appointments for each procedure of the treatment with a member of the medical staff." a) Make an Entity/Relationship model for the above description and clearly identify entities, attributes, relationships, cardinality ratios. b) Design an E/R diagram for the above description. c) Implement SQL…
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington, D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all of the various information needs of the company. The company's operations are as follows: LOST offers many different tours. For each tour, the tour name, approximate length (in hours), and fee charged is needed. Guides are identified by an employee ID, but the system should also record a guide's name, home address, and date of hire. Guides take a test to be qualified to lead specific tours. It is important to know which guides are qualified to lead which tours and the date that they completed the qualification test for each tour. A guide may be qualified to lead many different tours. A tour can have many different qualified guides. New guides may or may not be qualified to lead any tours, just as a new tour may or may not have any qualified guides. Every tour must be designed to visit at least…
Draw a Use Case Diagram for Patient management system Vic’s hospital has a patient management system. A patient must register with the hospital before start of the treatment. Once registered, a doctor is assigned to the patient. The patient must be provided with an appointment date based on the urgency. A doctor meets the patient and request tests to be performed by labs. When the lab results are ready, a new appointment is set with doctor. Doctor meets the patient again and prescribe medicines and treatments/rehabilitation.
DFD Case Study The keepers in an animal park look after the feeding of the animals. Each animal is located in a different area of the park. Each area has its own keeper who reports to the head keeper. The head-keeper maintains a record of the sorts of food that each animal species or type in the park should be fed, and in what quantities. There is no distinction made between different animals of the same species. The keepers access the information so they know what to feed each animal type. Each animal type may be given more than one type of food, and each type of food may be fed to a number of animal types. Each day the keepers will take out the food needed for the animals in their care and record this on the information system. These food types can be perishable or non-perishable according to their shelf life. For example, fresh fruit and vegetables would be perishable where tinned produce or cereals would be considered to be non-perishable. The office staff keeps a track of the food…
Draw a complete ER-diagram for the following case. A lecturer (having an ID, name and room number) is responsible for organizing a number of course modules. Each module has a unique code and also a name and each module can involve a number of lectures who deliver part of it. A module is composed of a series of lectures and sometimes lectures a on a given topic can be part of more than one module. A lecture has a time room and date and is delivered by a lecturer and a lecturer may deliver more than one lecture. Students, identified by number and name, can attend lectures and a student must be registered for a number of modules. We also store the date on which the student first registered for that module. Finally, a lecturer acts as a tutor for a number of students and each student has only one tutor. Also show relational database schema including Primary and Foreign key constraints. (Please draw this on a paper)
In a PhD program, students join a particular specialization offered by a department. Aspecialization with same title (e.g., DBMS) may be offered by one/more depts independently. Teachers are appointed to a specific department and given a room and telephone. Each department should have a teacher who serves as its head. Courses are offered under various specializations. A teacher may teach many courses and a course may be taught by many. A student studies a course under a teacher during some semester (e.g., semester 1 of 2019), and is awarded a grade. At eacher’s research interest may lie in one/more specializations. Courses have one/more/zerop prerequisites Construct an E-R diagram for the above specification. Document all assumptions. Please don't copy answer form internet..i will give negative feedback
Q : Draw an ERD from the following business rules: Use proper notations for the type of attributes. A software system is to be developed for an educational institute. The software is intended to be used by faculty members, students and designated support staff. System administrator will also use system for system administration and management. Student’s data including names, registration number, cell numbers and address will be added and edited by Clerk. The data will be added at the time of student reporting at campus. Student can enroll into any course of their choice from the offered courses. They can also request for dropping a course. Approval of course dropping of a student will be granted or refused by academic coordinators.
Instructions: Read the following Case Study and create a context diagram . When a patient arrives at ACME Medical with a prescription refill, the receptionist checks the prescription file for the previous prescription number and adds the prescription to the system. This has to be electronically authorized by a doctor before the resident pharmacist can dispense the medication. The system sends a cell phone notification to the doctor of any incoming prescriptions. The pharmacist dispenses the medication to the patient after receiving authorization. If the patient is entitled to free prescriptions, the pharmacist verifies this in the system and fills in the appropriate details on an electronic form, which is filed in the free prescriptions file. Otherwise the pharmacist takes the customers payment information, enters it into the system and gives the patient a receipt.
Exercise 3: school system Each subject is owned by a department and each department is managed by a teacher, called Head of Department (HOD). Each department has a name and a unique code number. Each subject has a name, unique number and credit value. All teachers have a unique ID. A HOD cannot manage more than one department at a time. Also, a HOD does not teach subjects. A subject cannot be taught by more than one teacher. Finally, the system needs to know each student's contact details, including, full ID, address, age and gender, as well as date of enrolment in the subject. name, student
School system scenario Students come at the beginning of the school year to register in a school system and pay for the year’s fees..Each student is added to the appropriate class . each class has several teachers already registered in the system, tests are made by the teachers and the teacher adds the students' grades in the system, and at the end of the year the system issues students ’certificates. draw Entity Relationship diagram(ERD) from above scenario
A company has various rules for how payments to suppliers are to be authorized.Some payments are in response to an approved purchase order. For approved purchase orders under $5,000, the accountingclerk can immediately issue a check againstthat purchase order and sign the check. Forapproved purchase orders between $5,000and $10,000, the accounting clerk can immediately issue a check but must additionallyobtain a second signature. Payments for approved purchase orders over $10,000 alwaysrequire the approval of the accounting manager to issue the check as well as the signature of two accounting clerks. Payments thatare not covered by a purchase order that areunder $5,000 must be approved by the accounting manager and a departmental manager who will absorb the cost of the paymentinto that department’s budget. Such checkscan be signed by a single accounting clerk.Payments that are not covered by a purchaseorder that are between $5,000 and $10,000must be approved by the accounting…
A Fitness Company offers a number of exercise classes for its members. A member can participate in several exercise classes or none at all. Each exercise class has one employee assigned as its instructor. Each instructor teaches at least one class and may teach several classes. Each exercise is taught in a specific room, on a specified date and time.