Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 3, Problem 3.38PAE
Add the following to Figure 3-16: An EMPLOYMENT party relationship is further explained by the positions and assignments to positions during the time a person is employed. A position is defined by an organization unit, and a unit may define many positions over time. Over time, positions are assigned to various employment relationships (i.e., somebody employed by some organization unit is assigned a particular position). For example, a position of Business Analyst is defined by the Systems Development organization unit. Carl Gerber, while employed by the Data Warehousing organization unit, is assigned the position of systems analyst. In the spirit of universal data modeling, enhance Figure 3-16 for the most general case consistent with this description.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
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…
Make the entity-relationship model in Luicdchart for the following case:
In the company Tecno1818 it is necessary to carry out an inventory of the products that are handled, for this the following information is available. Each product has a code, name, price and a manufacturer code. For the manufacturer you have the code and name
Create Entity-Relationship (E-R) model for the internal view of gym membership system including all
workers and organization units affected by processing gym memberships. When members join the gym,
they pay a fee for a certain length of time. Most memberships are for one year, but memberships as
short as two months are available. Throughout the year, the gym offers a variety of discounts on their
regular membership prices (e.g., two memberships for the price of one for Valentine's day). It is
common for members to pay different amounts for the same length of membership. The gym wants to
mail out reminder letters to members asking them to renew their memberships one month before their
memberships expire. Some members have become angry when asked to renew at a much higher rate
than their original membership contract, so the club wants to track the prices paid so that the manager
can override the regular prices with special prices when members are asked to renew. The system must
track…
Chapter 3 Solutions
Modern Database Management
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Match the following terms and definitions:...Ch. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?
Ch. 3 - Prob. 3.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - In Figure 3-5b, why must the minimum cardinality...Ch. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAECh. 3 - Draw an EER diagram for the following situation:...Ch. 3 - Develop an EER model for the following situation,...Ch. 3 - Prob. 3.32PAECh. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 3 - Add the following to Figure 3-16: An EMPLOYMENT...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Run the hello, world program on your system. Experiment with leaving out parts of the program, to see what erro...
C Programming Language
Suppose that we create an array A of GameEntry objects, which has an integer scores field, and we clone A and s...
Data Structures and Algorithms in Java
What is an uninitialized variable?
Starting Out with Programming Logic and Design (4th Edition)
Explain the difference between using a computer program and programming a computer.
Big Java Late Objects
Are reflex actions (such as flinching from a hot stove) rational? Are they intelligent?
Artificial Intelligence: A Modern Approach
Porter’s competitive forces model: The model is used to provide a general view about the firms, the competitors...
Management Information Systems: Managing the Digital Firm (15th Edition)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Draw an Entity Relationship Diagram for the following scenario A, B, and C are entities. There is a relationship between all three, called D. For each A and B there is one C. For each B and C there can be many A’s. For each A and C, there is one B. Every time the relationship, D, is satisfied, a single value, “Note”, will be storedarrow_forwardDraw 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)arrow_forwardconvert 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…arrow_forward
- Would you look if i got ER diagram right ? I am asked to design a conceptual data model using ER /EER diagramming for the business functions of a group of dental offices from the natural language description given below. Be sure to consider the cardinality of, and participation in, each relationship. Also, be sure to identify all key attributes. Document any assumptions you make due to the imprecise nature of the problem specification. "Each office employs one or more dentists, hygienists, and receptionists each of whom have an employee number. Patients are free to use any dental office but, naturally, must make appointments in advance. A record of all such appointments is kept which specifies the patient’s name, the date and time of the appointment and a list of services performed. Adult patients have a SIN (Social Insurance Number) but their children typically do not. Each office provides specific services (e.g. cleaning, filling, X-rays, extraction, etc.) to the patients and bills…arrow_forwardWith examples, explain the distinctions between is-a relationship and has-a relationship.arrow_forwardanswer 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 patientsarrow_forward
- Use ER Assistant to draw your diagram. Draw a self-referencing entity type for the Employee entity type for which an employee is supervised by a maximum of one other employee and doesn’t have to be supervised by any employee at all. Conversely, an employee can supervise zero or many other employees. The attributes of the Employee entity are as follows: EmpNo (primary key), EmpName, EmpAddress.arrow_forwardConstruct 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.arrow_forwardMake a UML diagram, Entity Relationship Model with the following data from the tablearrow_forward
- Design an Entity Relationship Diagram for the following example:arrow_forwardDistinguish between the ways in which functional dependencies may be utilized to express the following: • Between the entity sets student and teacher, there is a one-to-one relationship set that exists.• There is a many-to-one connection set between the entity setsstudent and teacher, which is defined asarrow_forwardProvide a separate ER diagram representing each of the following situations. 1.A is an entity. It has an attribute, “a_id” as its identifier. B is a weak entity that depends on A. It has “b_id” as its discriminator. Many instances of B may belong to the same instance of A. 2. A, B, and C are entities. There is a relationship between all three, called D. For each A and B there is one C. For each B and C there can be many A’s. For each A and C, there is one B. Every time the relationship, D, is satisfied, a single value, “Note”, will be stored.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill Education
Starting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSON
Digital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSON
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
Programmable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY