Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 2.2RQ
Define the term entity, and give an example of an entity (other than the one from this chapter).
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Explain entity sets.
What does it mean to be a weak entity? Give an illustration.
Draw the associations that are described by the following business rules. Include the multiplicities
for each relationship. (4 marks)
A patient must be assigned to only one doctor, and a doctor can have one or many patient:
An employee has one phone extension, and a unique phone extension is assigned to an
employee.
A bookstore sells at least one book, and a book can be sold at up to 10 other bookstores
around town.
Chapter 2 Solutions
Database Concepts (8th Edition)
Ch. 2 - Prob. 2.1RQCh. 2 - Define the term entity, and give an example of an...Ch. 2 - Prob. 2.3RQCh. 2 - Prob. 2.4RQCh. 2 - Prob. 2.5RQCh. 2 - Prob. 2.6RQCh. 2 - Prob. 2.7RQCh. 2 - Prob. 2.8RQCh. 2 - Prob. 2.9RQCh. 2 - Define the term unique key and give an example.
Ch. 2 - Prob. 2.11RQCh. 2 - Prob. 2.12RQCh. 2 - Define the terms candidate key and primary key....Ch. 2 - Describe four uses of a primary key.Ch. 2 - Prob. 2.15RQCh. 2 - Prob. 2.16RQCh. 2 - Prob. 2.17RQCh. 2 - Explain the term foreign key, and give an example.Ch. 2 - Prob. 2.19RQCh. 2 - Prob. 2.20RQCh. 2 - Explain three possible interpretations of a null...Ch. 2 - Give an example of a null value (other than one...Ch. 2 - Prob. 2.23RQCh. 2 - Prob. 2.24RQCh. 2 - Prob. 2.25RQCh. 2 - Prob. 2.26RQCh. 2 - Prob. 2.27RQCh. 2 - Define the term primary key in terms of functional...Ch. 2 - Prob. 2.31RQCh. 2 - Examine the data in the Veterinary Office...Ch. 2 - Prob. 2.33RQCh. 2 - Describe a modification problem that occurs when...Ch. 2 - Prob. 2.35RQCh. 2 - Prob. 2.36RQCh. 2 - Prob. 2.37RQCh. 2 - Apply the normalization process to the Veterinary...Ch. 2 - Prob. 2.39ECh. 2 - Apply the normalization process to the Veterinary...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
A magic number is _______. a. a number that is mathematically undefined b. an unexplained value that appears in...
Starting Out with Python (4th Edition)
Explain what is meant by a compensation action and, using an example, show why these actions may have to be inc...
Software Engineering (10th Edition)
Would you select a decoder/driver with active-HIGH or active-LOW outputs to drive a common-cathode 7-segment LE...
Digital Fundamentals (11th Edition)
While a program is running, a control is said to lose focus when the focus moves from that control to another c...
Introduction To Programming Using Visual Basic (11th 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)
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
- Define the term entity and give an example other than those used in this book.arrow_forwardTRUE or FALSE - Generalization (is-a) is the relationship established between entities to show that sub-entities that are derived from the generalized entity. Select one: a. TRUE b.FALSEarrow_forwardAn entity in A is associated with at most one entity in B. An entity in B, however, can be associated with any number (zero or more) of entities in A. What is the cardinality ratio? a. one to many b. many to one c. one to one d. many to manyarrow_forward
- For each of the following pairs of related entities, indicate whether (under typical circumstances) there is a one-tomany or a many-to-many relationship. Then, using the shorthand notation introduced in the text, draw a diagram for each of the relationships.a. STUDENT and COURSE (students register for courses)b. BOOK and BOOK COPY (books have copies)c. COURSE and SECTION (courses have sections)d. SECTION and ROOM (sections are scheduled in rooms)e. INSTRUCTOR and COURSEarrow_forwardExplain the ambiguity in the definition of the term weak entity. Explain how this book interprets this termarrow_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_forward
- Please answer.arrow_forwardGive an example of each of the following, other than those described in this chapter, and clearly explain why your example is this type of relationship and not of some other degree.a. ternary relationshipb. unary relationshiparrow_forwardPlease provide a definition of an entity-relationship model as well as an explanation of how it works.arrow_forward
- Define Key Attribute with an example.arrow_forwardER model relationships are represented using a.) relationship keys b.) primary keys c.) crows foot symbols d.) main keys What do the cardinalities in an ER model show, (please select all that apply)? a.) only a one to one relationship. b.) the minimum number of entities that can be involved in a relationship. c.) only a many to many relationship.arrow_forwardDifferentiate among following: [at least 4 differences] 1. include and extended relation in use case diagram 2. Class and Object diagramarrow_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