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.21PAE
Refer to the employee EER diagram in Figure 3-2. Make any assumptions that you believe are necessary. Develop a sample definition for each entity type, attribute, and relationship in the diagram.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Please provide a definition of an entity-relationship model as well as an explanation of how it works.
QI/ Draw ER diagram representing entity sets and relationship set
described below, also determine the cardinality of the relationship:
Entities: Employees(SSN, name, title), Departments (D_ID, name,
budget)
Relationship: Work_in(since)
Note: the attributes of each entity or relationship are between the
parenthesis of them.
Use the ER Diagram shown on Figure 2 to anewer questions 6 and 7:
6. According to the ER diagram on Figure 2, which of the following is true?
A) YearEnrolled is a derived attribute.
B) STUDENT entity has multiple unique attributes.
C) StudEmail is an optional attribute.
D) None of the above.
Answer:
7. According to the ER diagram on Figure 2, which of the following is true?
A) A student must attend a college but can only attend a single college.
B) Each college must have multiple students attending it.
C) NumOfStudents is a composite attribute.
D) None of the above.
Answer:
StudiD
CollD
StudName
STUDENT
Allends
COLLEGE
ColName
StudEmail
***
YearEnrolled (0)
NumOIStudents
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...
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
- Please include the eer diagramarrow_forwardDesign the Entity Relationship Diagram (ERD) showing entities, attributes, primary key and relationship cardinality for the following scenario. Any employee works for only a department and under supervision of a manager (where manager is also an employee). Employee's address, city code & city name also has been recorded. Every employee may work for multiple project, but an employee may be on vacation and not assigned to any projects. Working hour may be different for an employee for different projects. Projects are broken into tasks; A task is created for one project and assigned to one department. Requisitions are made for projects; Each requisition could ask for any number of items; Items could be: equipment item or materials item and are coded in a similar way; Each requisition is for one project and is made to one supplier. The important data fields are employee_id, employee_name ,employee_address, employee_email, department_id, department_name, location, city_code, city_name,…arrow_forwardThe entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity. Draw an ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?arrow_forward
- Create a ER Diagram for Flying Instruction School , School will have 2 Intructors , and 10 students also 2 training planes . No maintnance staff needed to be added to the er diagram since there will be third party maintaining the planes. Please identify Entities, attributes, keys, and relationships in the er diagramarrow_forwardPlease Design an Entity Diagram for the following Fictional Scenario using entities: SEASON, LEAGUE, DIVISION, CLUB and TEAM. Also, please show the relationship type and datatype. Thank You!arrow_forwardPlease explain the purpose of the Entity-Relationship model and describe it.arrow_forward
- Entity Relationship Diagram of the business, as shown in the case. Completely and correctly specify all Entities, Relationships and Attributes Order: has one or many items; half by member half by anonymous member (no member number)Has: order number, each order item has total cost (with and without gst), number of store, cashier who took the order, member number (if provided), date on which the order was places, and, if the order is not picked up in-person, the date on which the order is shipped. Order-Item (one of the 1600 products):to identify: useorder number as well as a small “item sequence number” (which is unique within each order). product number, quantity ordered and the actial "unit price paid" If a valid member number is on the order, the system should use the product’s special “member price”, otherwise the product’s “regular price” is used. The average order includes 11 distinct order-items. Member (places 5 orders per month on avg):last name, given names, email…arrow_forwardWrite down the various types of characteristics in the Entity-Relationship (ER) model.arrow_forwardExplain the rules and style guidelines for creating entity relationship diagramarrow_forward
- Explain the Entity-Relationship model and how it works.arrow_forwardcreate an Enhanced Entity-Relationship (EER) diagram based on the provided information. Based on the following description, try creating the diagram using a tool such as draw.io, Lucidchart, or any other ER diagram tool: Entities: Person: person_ID (PK), name, address, birth date, phone number Subtypes: Employee, Physician, Patient, Volunteer Visit: date (PK, partial identifier), comments Care Centre: care_centre_ID (PK), name, location Laboratory: lab_ID (PK), name, location Bed: bed_number (PK), room_number, care_centre_ID (FK) Item: item_number (PK), description, unit_cost Treatment: treatment_ID (PK), treatment_number, treatment_name, treatment_date, treatment_time, results Relationships: Works_In (Person - Care Centre): Person (1, M) ----< Works_In >---- (1, M) Care Centre Assigned_To (Employee - Care Centre): Employee (1, M) ----< Assigned_To >---- (1, M) Care Centre Assigned_To (Physician - Care Centre): Physician (1, M)…arrow_forwardDraw this ER Diagram, but note that: Ths diagram should adhere to compressed Chen notation : The ER diagram consists of four entities: Pet, Challenge, User, and Vote. The Pet entity has attributes such as id (primary key), name, species, age, and description to store information about each pet profile. The Challenge entity has attributes such as id (primary key), pet1_id and pet2_id (foreign keys referencing the Pet entity), start_date, end_date, and likes to store information about each challenge between two pets. The User entity has attributes such as id (primary key), name, and email to store information about users who participate in voting and challenge creation. The Vote entity has attributes such as id (primary key), challenge_id (foreign key referencing the Challenge entity), user_id (foreign key referencing the User entity), and vote to store information about user's vote for a particular challenge.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