• Develop an Context Diagram to model the following description given by the Head of the Centre for Professional Development (CPD) at GTUC: "We make our revenue from training courses. We have courses which we schedule at different locations. Once we have scheduled a course, customers phone in to place bookings for them and we assign instructors to teach the course. Sometimes the person making the bookings is not always the one who will attend the course hence we try to keep track of all the people who are authorized to book places in this way".

• Develop an Context Diagram to model the following description given by the Head of the Centre for Professional Development (CPD) at GTUC: "We make our revenue from training courses. We have courses which we schedule at different locations. Once we have scheduled a course, customers phone in to place bookings for them and we assign instructors to teach the course. Sometimes the person making the bookings is not always the one who will attend the course hence we try to keep track of all the people who are authorized to book places in this way".

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Draw an ER diagram for the EMU Slimming Center based on the specification given below. Case Study 01 There are many dietitians in the center. There are also many clients in the center. A dietitian gives a menu to a client every week. Many diet menus are available. A diet menu consists of many food items and each food items belongs to one food category. Instructions • Identify the relationship between Entities (clearly showing the cardinality and participation)
b. Develop a sequence diagram showing the interactions involved when a student registers for a course in a university. Courses may have limited enrolment, so the registration process must include checks that places are available. Assume that the student accesses an electronic course catalog to find out about available courses.
Draw a context diagram and level-0 diagram for the following hospital pharmacy system.The pharmacy at Mercy Hospital fills medical prescriptions for all patients and distributes these medications to the nurse station responsible for the patient's care. Medical prescriptions are written by doctors ad sent to the pharmacy. A pharmacy technician reviews the prescriptions and sends them the appropriate pharmacy station. Prescriptions for drugs that must be formulated are sent to lab station, prescription for off-the-shelf are sent to shelving station and prescription for narcotics are sent to secure station. At each station a pharmacist reviews the order, checks the patient file to determine the appropriateness of the prescriptions, and fills the order if the dosage is at safe level and is will not negativity interact with the other medications or allergic indicated in the Patient's file. If the pharmacist does not fill the order, the prescribing doctor is contacted to discuss the…
This is a continuation to the question above. The directions continue as follows: Also, create a Use Case diagram. Make sure to identify the entities as actors and show the interaction between each of the actors. Be sure to identify at least two processes and show all the actions between them. Don't forget to include a system boundary so we can determine which actions occur within the system and which are external to SIM. With the creation of the use case diagram, you should be able to create a model (or table) showing each object. For each object, be sure to outline associated attributes and methods. Hopefully, the use case diagram and the DFD will make this process fairly straightforward. The developers need 3 instance examples for each of the entities. I suggest that you use the data library and previously developed organizational chart to find examples.
Draw a DFD that represents the processes involved in cooking and serving a three-course dinner, including all such associated tasks as laying out the table. Seeking to ensure that your solution does not impose any unnecessary assumptions about the sequencing of actions.
convert this plain text to ER diagram , I attached a picture with question for one diagram and it's wrong because there is no bookning "Each office employs one or more dentists, hygienists, andreceptionists each of whom have an employee number. Patientsare free to use any dental office but, naturally, must makeappointments in advance. A record of all such appointments iskept which specifies the patient’s name, the date and time ofthe appointment and a list of services performed. Adultpatients have a SIN (Social Insurance Number) but theirchildren typically do not. Each office provides specific services(e.g. cleaning, filling, X-rays, extraction, etc.) to the patients andbills them accordingly. Performing certain services consumessupplies (e.g. floss, amalgam, X-ray film, etc.). Such suppliesare purchased from a variety of suppliers each of whom isidentifiable by a unique supplier code. The current amount ofeach type of supply available is tracked so that when suppliesrun low, a new…
Construct an E-R diagram for the following hospital: In this hospital, we have many patients (characterized by social security number, name, insurance, the admission date, and the date of check out) received by medical doctor. Each medical doctor in the hospital is characterized by: ID number, name, and specialization. For every patient, the medical doctor will perform one or more tests and examinations to diagnose his illness. Each test or examination is characterized by an ID, name, date, time, and result. In your ER-Diagram, you must specify the key for each entity and all relationship cardinalities.
Draw a data flow diagram (DFD) for the development of the admission and registration system, bearing in mind that the users of the system, the processes and the stored data are as follows: system users processes saved data students - Deletion and addition - withdrawal from the course - apology for the semester - student schedule - withdrawal requests - apology requests faculty members -recording attendance and absence - monitoring grades, - attendance and absence detection - Transcript for class department heads approving requests Deanship of Admission and Registration implementing requests Draw a data flow diagram starting from the zero level to the second level. Please add the detailed processes and data saved by level
Draw an ER Diagram, or EER Diagram as appropriate, for each of these scenarios. A soccer league has a set of teams, each of which has a team ID number, name, stadium name, and location (city). Each team has many players, and each player belongs to only one team. Each player has a player ID number, name, date of birth, start year, and a jersey number. Teams play matches. In each match there is a host team and a guest team. Information about a given match includes the date on which the game is played, and the score (one value for the guest team and one value for the host team). The league has referees, each of which as a referee ID number, a name, date of birth, and start year. Each match is assigned three referees, one of which is designated as the main referee (the other two are assistant referees). Note that a referee may be the main referee for some matches and an assistant referee on others. [Hint: Make Match its own entity type. Include two relationships between Team and Match,…
Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associate with each patient a log of the various tests and examinations conducted.
answer should be handwritten and the ER MODEL should be be completeDraw the Entity Relationship Diagram (ERD) with appropriate mapping cardinalities for the following scenario, Patients are treated in a single ward by the doctors assigned to them. Healthcare assistants also attend to the patients; a number of these are associated with each ward. Each patient is required to take a variety of drugs a certain number of times per day and for varying lengths of time. The system must record details concerning patient treatment and staff payment. Some staffs are paid part time and doctors and healthcare assistants work varying amounts of overtime at varying rates, the system will also need to track what treatments are required to what patients
Create a Use Case Diagram for the below scenario: In The University of Technology Library Systems, whenever a new books arrives to the university that books information will be entered by the inventory officer into the inventory. Library staff will allow the students to borrow the books and also return the books. Students in the university can search the books and reserve that book automatically to borrow. Also there is a Library manager who will have permission to print the books titles delete the book copy information, view overdue or books which are not returned on time and also view who has reserved the books in advance Now draw the use case diagram by identifying actors, use cases etc.