Draw an ERD for below scneario 1. AUniversity contains many Faculties. 2. The Faculties in turn are divided into several Schools. 3. Each School offers numerous programs and each program contains many courses. 4. Lecturers can teach many different courses and even the same course numerous times. Courses can also be taught by many lecturers. 5. A student is enrolled in only one program but a program can contain many students. 6. Students can be enrolled in many courses at the same time and the courses have many students enrolled.

Draw an ERD for below scneario 1. AUniversity contains many Faculties. 2. The Faculties in turn are divided into several Schools. 3. Each School offers numerous programs and each program contains many courses. 4. Lecturers can teach many different courses and even the same course numerous times. Courses can also be taught by many lecturers. 5. A student is enrolled in only one program but a program can contain many students. 6. Students can be enrolled in many courses at the same time and the courses have many students enrolled.

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

Suppose that you are given the following information for the articles publications: • Each article is published in a Journal only. Article may have their own identification number, name, and any other relevant information. Articles cannot be duplicated and will be only accepted in a Journal. Journal will have their identification number, name, any other relevant information. • Authors may publish one or more articles at a time, but each article must be distinctive and published in the appropriate journal. If necessary, the author may be required to present their work at a specific conference. The details of the conference must also be recorded. A reviewer will examine an article before it is published. Each reviewer is only allowed to review two articles from the same journal. Sketch an Enhanced Entity Relationship Diagram (Chen's Model) based on the scenario above. Include all the relevant entities and you are also encouraged to add any other relevant entities to specify the…
A company makes items. Each item has a name, ID and component quantity. Every item contains many components. Each component can be supplied by one or more suppliers. Suppliers have names and IDS. Each component has ID, name, description, suppliers who supply them, and items in which they are used. Not all suppliers provide components, and a component is not always associated with a supplier. Also, a component always have to be associated with one or more items. Finally, the company contact customers using their IDs, Names and Phones to sell them items. A customer can buy one or more items.
Create a Crow's Foot ERD for the following description: The KwikTite Corporation operates many factories. Each factory is located in a region, and each region can be "home" to many of KwikTite's factories. Each factory has many employees, but each employee is employed by only one factory.
Q3: A national bank and an international bank decide to merge. Assume, that both the organizations use almost similar ER diagrams. Prepare the ER diagram for the merged bank. Make, and state, suitable assumptions if any. Q4: A construction company has many branches spread all over the country. The company has two types of constructions to offer : Housing and Commercial. The housing company provides low income housing, medium style housing and high end housing schemes, while on the commercial side it offers multiplexes and shopping zones. The customers of the company may be individuals or corporate clients. Draw the ER diagram for the company showing generalization or specialization hierarchies and aggregations, if any. Also create 3NF tables of your design.
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the sam.e situa- tion using the tool you have been told to use in the course. #3 A hospital has a large number of registered physi- cians. Attributes of PHYSICIAN include Physician ID (the identifier) and Specialty. Patients are admitted to the hospital by physicians. Attributes of PATIENT include Patient ID (the identifier) and Patient Name. Any patient who is admitted must have exactly one admitting physician. A physician may optionally admit any number of patients. Once admitted, a given patient must be treated by at least one physician. A particular physician may treat any number of patients or may not treat any patients. Whenever a patient is treated by a physician, the hospital wishes to record the details of the treatment (Treatment Detail). Components of Treat- ment Detail include Date, Time, and Results. Did you draw more…
Convert this plain text to ER diagram : "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 order may be placed with the appropriatesupplier. Patients are allowed to run accounts but…
MAKE AN ER DIAGRAM FOR THE FOLLOWING PROMPT: Various physicians are working for a clinic and these doctors are identified by their respective employee numbers. The other descriptors of a doctor are: name, gender, address, and phone. Each physician’s specialty and rank are captured. Every physician serves as a primary care physician for at least one patient; however, no more than 20 patients are allotted to a physician. Every patient is assigned one physician for primary care. Data for patients include: patient number (the unique identifier of a patient), name, gender, date of birth, blood type and the code and name of allergies, if any. Physicians may prescribe medications to patients; thus, it is necessary to capture which physician(s) prescribe(s)s what medication(s) to which patient(s) along with dosage and frequency. In addition, no two physicians can prescribe the same medication to the same patient. If a physician leaves the clinic, all prescriptions written by that physician…
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to theWashington, D.C. area. In recent years, LOST has grown quickly and is havingdifficulty keeping up with all of the various information needs of the company. Thecompany’s operations are as follows:LOST offers many different tours. For each tour, the tour name, approximatelength (in hours), and fee charged is needed. Guides are identified by anemployee 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 isimportant to know which guides are qualified to lead which tours and the datethat they completed the qualification test for each tour. A guide may be qualifiedto 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 mayor may not have any qualified guides.Every tour must be designed to visit at least three…
1. Find total number(Employees) of Accountant (Job Title)-> HR schema (Employees and Jobs): 6 2. Find all the employees who has a 's' in their name and who started their job after Jun 17th 2003. HR schema: 3 3. Show all the employees who get more than average salary. → HR schema:3 4. Show how many employees working on each department where salary is more than 6000. HR schema: 5 5. .Find all the orders made on 16th Sep 2018. > CO schema (bonus):3
Consider a model of an airport with planes, models of planes, a test of planes, and technicians. Draw an ER diagram to represent these entities and the following attributes.Planes have a unique registration number. Airplane Models are each identified by a model number (e.g. DC-80), and each has a capacity and a weight. A number of technicians work at the airport. You need to store for each the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes aresafe. Each test has a unique FAA number, a name, and a maximum possible score.Extend your ER diagram with relationships to represent the following information.(a) Each airplane is of one specific model.(b) Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. (c) Transport Canada requires the airport to keep track of each time a given airplane is tested using a given test. For each testing event, the…
Use the preamble below to answer QUESTIONS I and QUESTIONS 2 A university SOG is made up of employees who belongs to the various departments and are characterized by their staff ID, first name, last name and date of birth. Also students are part of the university and can also be characterized by student ID, first ame, last name, date of admission. Every employee and student belongs to a particular department which can be characterized by the department ID and the department name. Again all students offer a particular program which can be identified by the program ID and program name and also a course that is offered by the students that can be identified by the course ID and the course name. a. Create SOG University database using SQL Data Definition Language. b. Create two (2) tables in the SOG University database from the schemas in QUESTION Ie using SQL. Data Definition Language. c. List the student ID of all students who do not belong to a department with departmentID7 in the SOG…
A publishing company produces books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more book publications. Every book require some items for publication. These items supplied by suppliers. One supplier can supply many items. Shop owner buys books from the publisher. Shop owner can buy many books but one book can be bought by one shop owner only. Books are uniquely identified by book ID. Propose EER diagram to this system?