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.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 (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
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
- Can you elucidate the distinction between an attribute that possesses multiple values and a recurrent group?arrow_forwardLet'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_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
- Modify the Er diagram given below and add 5 to 6 more additions to it such as entities attributes relationships etcarrow_forwardCreate 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_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
- Given 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_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_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_forward
- Please draw the E-R Diagram for the following system, being sure to include the attributes and note which attributes are the identifiers. Imagine a sales system that tracks customers, orders, and sales representatives. Customers can place multiple orders, but each order is associated with a single customer. Additionally, every customer is classified as being either a “Major Customer” or a “Minor Customer.” Major Customers are assigned to a single Sales Representative who acts as their primary point of contact, while Minor Customers have no connection to the Sales Representatives. Sales Representatives can be assigned to multiple customers, and whenever one of their customers places an order, the Sales Representative is also associated with the order. Overall, the system tracks the customer IDs, customer contact number(s), order numbers, goods ordered, payment status, sales representative ID, and sales representative name, as well as the customer point-of-contact for major customers.arrow_forwardPlease find the question below and help me with the answer?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