Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
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
Give me UML diagram
A football association is comprised of something like four football crews. Every football crew is made out of eleven to seventeen players, and one player is the commander of the group. The football crews mess around against one another. A group has here and there a chief, and is dependably lead by a mentor. A chief can deal with various groups. Individuals (player, mentor, chief) are distinguished by a name and a location.
Give me the UML diagrams with explanation
A consultancy firm provides consultancy, outsourcing, and interim management services. The firm considers acquisition of projects as part of those services. Acquisition can both be done for existing clients and for new clients, because it concerns acquisition of projects rather than clients. Acquisition is typically started at ‘networking events’ by partners of the consultancy firm. It is handled according to a fixed procedure, but no standard document is used. When a client shows interest in a consultancy service, an intake is done with the client. To maintain a long-term relationship with clients as much as possible, the firm will always try to establish a framework contract with new clients during the intake. For existing clients a framework contract does not have to be established. As another form of relationship management, regular meetings are held with existing clients. During these meetings the client’s organization is discussed with the client. This enables the client to…
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.
Chapter 3 Solutions
Modern Database Management (12th Edition)
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Prob. 3.2RQCh. 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 - Prob. 3.16RQCh. 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 - Prob. 3.30PAECh. 3 - Develop an EER model for the following situation,...Ch. 3 - Draw an EER diagram for the following description...Ch. 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 ER diagram for the following scenario: A designer has a store of designer dresses both for male and female. People can buy as well as take dresses on rent from the store. Each dress in the designer's store, is identified by unique ID. A dress in the store can be categorized into various categories Western, Indian, Indo-westem, etc. The designer maintains the name, phone number of people who have taken dresses on rent. The designer also maintains the name, phone number, and address of people who have bought dresses from the store. The designer also collects feedback from the people who have bought or taken dresses on rent from the store. Design the ER diagram by mentioning all the structural constraints. You may also include additional information in addition to the requirements listed??arrow_forwardQ1. Draw an E-R Diagram for the following situation. At the university system each STUDENT must be assigned an ADVISOR who counsels students about degree requirements and helps students register for classes (COURSE). Each student must register (REGISTRATION) for classes with the help of an advisor, but if the student's assigned advisor is not available, the students may register with any advisor, We must keep track of students, the assigned advisor for each, and the name of the advisor with whom the students registered for the current term. Tips: Attributes of STUDENT include Student ID (the identifier), Name, and Major. Attributes of ADVISOR include Advisor ID (the identifier), Name, and Department. Attributes of COURSE include Course ID (the identifier), Title, and Credits. Attributes of REGISTRATION include Semester, and Year. Based on your background, think of logical and standard relationships between the given entities.arrow_forwardER Modeling Assignment Question 1. A company is organized into departments. Each department has a unique name, a unique number, and a particular employee who manages the department. We keep track of the start date when that employee began managing the department. A department may have several locations. A department controls a number of projects, each of which has a unique name, a unique number, and a single location. We store each employee's name, social security number.i address, salary, sex, and birth date. An employee is assigned to one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee works on each project. We also keep track of the direct supervisor of each employee. We want to keep track of the dependents of each employee for insurance purposes. We keep each dependent's first name, sex, birth date, and relationship to the employee. Question 2 A company has a…arrow_forward
- ER Modeling Assignment Question 1. A company is organized into departments. Each department has a unique name, a unique number, and a particular employee who manages the department. We keep track of the start date when that employee began managing the department. A department may have several locations. A department controls a number of projects, each of which has a unique name, a unique number, and a single location. We store each employee's name, social security number.i address, salary, sex, and birth date. An employee is assigned to one department but may work on several projects, which are not necessarily controlled by the same department. We keep track of the number of hours per week that an employee works on each project. We also keep track of the direct supervisor of each employee. We want to keep track of the dependents of each employee for insurance purposes. We keep each dependent's first name, sex, birth date, and relationship to the employee. Question 2 A company has a…arrow_forwardDraw an entity realtionship diagram (ERD) with the instruction given below: in a private hospital there are many doctors working Doctors examine many patients Each patient examined by only one doctore Each doctor wrires many prescripitons A prescription is written by only one doctorarrow_forwardExplain the concept of level of abstraction and how it applies to models that we use in systems analysis and design. Give at least one example of a model with a higher level of abstraction versus a model with a lower level of abstractionarrow_forward
- 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) (4)arrow_forwardRead 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…arrow_forwardDraw an entity-relationship diagram, including minimum and maximum cardinality, for the following: The system stores information about two things: cars and owners. A car has attributes for make, model, and year. The owner has attributes for name and address. Assume that a car must be owned by one owner and an owner can own many cars, but an owner might not own any cars (perhaps she just sold them all, but you still want a record of her in the system).arrow_forward
- Draw a UML class diagram to capture the following situation: “Every student is enrolled in a course. Each student may be enrolled in a set of units. Some units are core units for one or more courses and some units are elective units for one or more courses.arrow_forwardDraw an Entity Relationship Diagram for all of those below. (a simple one) Each lecturer is identified by a unique number, name and phone. A lecturer teaches several courses, and for each course there is a unique code and title (not necessarily unique). There might be several lecturers in a course. Each course requires one or more text books. Each text book is used in at least one course. A text book is identified by a unique ISBN, and its title, authors, publisher and year of publication are known. Each course has a unique code. The bank has many customers. Every customer has at least one account with the bank. An account may be shared by several customers. Each customer has a unique number, type, the opening date and the balance. A flight carries many passengers on a specific airplane. Each airplane has a unique number, while each flight has a code (unique), destination and origin. A passenger has a name, passport number and nationalityarrow_forwardTransfer the following description into an ER Diagram: A company has one or more locations referred to as "Plants" (Plant-ID). Several plants are uniquely assigned to the same company code (CC-ID). Plants can have several storage locations (S-loc-#) in which the manufactured and purchased items are stocked, a storage location however, can only be assigned to one plant. A purchase organisation (PO-ID) can be assigned to several plants and a plant to several purchase organisations. A company code is related to one or more purchase organisations, the latter is uniquely related to a company code. A distribution channel (DC-#) can be assigned to several divisions (Div-ID), whereas a division is uniquely assigned to a distribution channel. A sales organisation (Sales-Org-ID) can have several distribution channels, whereas a distribution channel is uniquely assigned to a sales organisation. A company code can have several sales organizations. Sales organisations are assigned to one…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