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.18PAE
Examine the hierarchy for the university EER diagram (Figure 3-10). As a student, you are an instance of one of the subtypes: either UNDERGRAD STUDENT or GRADUATE STUDENT. List the names of all the attributes that apply to you. For each attribute, record the data value that applies to you.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
What is the difference between a recurring group and an attribute that may take on many values?
Draw an E-R diagram for a bank. It should include at least customers, checking accounts and loans, and appropriate relationships between them.
Note: To keep this to a resonable size, you should limit yourself to at most six entities and at most eight attributes per entity.
Prepare an E-R diagram for a Aqarat (real estate) Company that lists property for sale. The
following describes this organization:
The company has a several number of offices. Attributes of office include
Office_Number (identifier) and Location.
Each office is assigned one or more employees. Attributes of employee include
Employee_ID (identifier) and Employee_Name. An employee must be assigned to only
one sales office.
For each office, there is always one employee assigned to manage that office. An
employee may manage only the office to which she is assigned.
The company lists property for sale. Attributes of property include Property_ID
(identifier) and Location.
Components of Location include Address, City, State, and Zip_Code.
Each unit of property must be listed with one (and only one) of the offices. A office
may have any number of properties listed, or may have no properties listed.
Each unit of property has one or more owners. Attributes of owners are Owner ID
(identifier) and…
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
Introduced in 1983, this application program became the “killer app” that made the IBM PC a must-have business ...
SURVEY OF OPERATING SYSTEMS
How does a computers main memory differ from its auxiliary memory?
Java: An Introduction to Problem Solving and Programming (7th Edition)
A byte is made up of eight a. CPUs b. addresses c. variables d. bits
Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
This optional Google account security feature sends you a message with a code that you must enter, in addition ...
Survey of Operating Systems, 5e
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)
The job of the _____ is to fetch instructions, carry out the operations commanded by the instructions, and prod...
Starting Out With Visual Basic (7th 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
- Let's say you wish to train and assess a classifier using just a little amount of data. Which approach would you use to assess the classifier? Why?arrow_forwardThe model above needs some improvement. Where you can apply all the normalization rules to attributes. Furthermore, you also need to explain entities and relations between them, and the purpose of attributes by showing why and how they exist ?.arrow_forwardWhat is an exclusive subtype relationship? Give an example other than one shown in this book. Draw an IE Crow’s Foot E-R diagram for your examplearrow_forward
- Create an ER model to represent the data used by the library.The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.arrow_forwardCreate an ER diagram that correctly describes the database for exams at Campus in Bäcksvängen in accordance with the following description: (Own assumptions must be clearly described.) Staff for various functions are involved in the exams. All staff have a full name and a unique staff code. Some people are examiners on one or more courses. A course has one name and one unique ladok code. For a course, you can add up its points based on the associated elements. One part is part of a course (for example an exam, a laboratory or project). A course can have several different parts. An element has a name, a description, a torque code, one point and two or more grades (eg: U, G, VG). An element can only belong to one course. Since the database is to process the exams, it is obvious that a part like described as an examination has an examination opportunity that is identified, among other things, by the date, start time, end time and that it is possible to calculate total writing time. A…arrow_forwardStudy the details below and create ERD diagram for each question below. Drone / Video: a Drone may take many Videos; a Video is taken by one Drone. A Video instance is optional for a Drone; a Drone instance is required for a Video. A Facility may be recorded by many Videos; a Video records one Facility. A Video instance is optional for a Facility; a Facility instance is required for a Video. A Video may be the basis of many Analyses; an Analysis is based on one Video. An Analysis instance is optional for a Video; a Video instance is required for an Analysisarrow_forward
- Use Lucidchart to draw an ERR Diagram with this information: EER Diagram for Royal Victoria Hospital Information System Assumptions: The diagram focuses on the entities and relationships. Attributes with cardinality are assumed to be single-valued. Dates are assumed as identifiers for visits. Entities: Person: (person_ID, name, address, birth_date, phone_number) Employee: (inherits from Person, date_hired) Nurse: (inherits from Employee, certificate) Staff: (inherits from Employee, job_class) Technician: (inherits from Employee, skill) Physician: (inherits from Person, speciality, pager_number) Patient: (inherits from Person, contact_date, resident_flag) Outpatient: (inherits from Patient) Resident: (inherits from Patient) Visit: (date, comments, outpatient_ID) Care Centre: (name, location) Laboratory: (name, location) Bed: (bed_number, room_number, care_centre_ID) Item: (item_number, description, unit_cost) Treatment:…arrow_forwardDraw an ER diagram for the following scenario- • An instructor has an ID, a name, and a phone number. An instructor teaches a course • A course has a code, course name, credits, and an instructor. Each course uses a textbook. • A textbook has ISBN, name, publisher, editor, and authors. Your ER diagram should have entities, attributes, composite attribute, multivalued attribute, key attributes, binary relationships, and a total participation. Explain your rationale behind each design choice. Please draw the ER diagram on paper showing all seperate parts for each instructor, course and textbook. Showing each connection seperately and explaining which connection is whicharrow_forwardGiven the following ERD. ID name salary Instructor Grades teaches ID name salary Student 1) What is the descriptive attribute of the relationship between instructor and student? 2) Is this relationship a one-to-one, a one-to-many, or a many-to-many relationship?arrow_forward
- Create a conceptual model In your conceptual diagram, you need to show all the relationships and data types apply (include all the entities from the case study above)arrow_forwardPrepare an entity-relationship diagram for the database in a following company: Holiday Travel Vehicles sells new recreational vehicles and travel trailers. When new vehicle arrives at Holiday Travel Vehicles, a new vehicle record is created. Included in a new vehicle record are a vehicle serial number, name, model, year, manufacturer, and base cost. When a customer arrives at Holiday Travel Vehicles, he or she works with a salesperson to negotiate a vehicle purchase. When a purchase has been agreed to, a sales invoice is completed by the salesperson. The invoice summarizes the purchase, including full customer information, information on the trade-in vehicle (if any), the trade-in allowance, and information on the purchased vehicle. If the customer request dealer-installed options, they will be listed on the invoice as well. The invoice also summarizes the final negotiated price, plus any applicable taxes and license fees. The transaction concludes with a customer signature on the…arrow_forwardDraw an ER diagram with the following data: Entities: Student, Exam, Course ⚫ Relationships: • Student takes at least one exam o An exam is given to at least one student. 。 An exam concerns only one course o A course has a least one exam ■ Attributes: Stud_Roll No, Stud Name, Stud Age, Course_No, Course_Name, Course Hours, Exam_No, Exam date, Exam Duration, Exam_Mark.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