Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 1, Problem 4MC
Program Description Answer
“Some-to-many” is not an E-R model relationship.
Hence, correct answer is option “A”.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Which of the following symbols represents a many-to-many relationship in an E-R model?a. a straight lineb. a dashed linec. a straight line with a crow’s foot at both endsd. a straight line with a crow’s foot at one end
Give an example of one to one and one to many relationship?
Two attributes (columns) that have the same range of values representing the same thing demonstrate which of the following properties?
Group of answer choices
the same values of identity
the same domain of values
the same surrogate values
the same determinant values
Chapter 1 Solutions
Oracle 12c: SQL
Ch. 1 - Prob. 1RQCh. 1 - Prob. 2RQCh. 1 - Prob. 3RQCh. 1 - Prob. 4RQCh. 1 - Discuss the problems that can be caused by data...Ch. 1 - Explain the role of a primary key.Ch. 1 - Prob. 7RQCh. 1 - Prob. 8RQCh. 1 - What type of relationship can’t be stored in a...Ch. 1 - Identify at least three reasons an organization...
Ch. 1 - Prob. 1MCCh. 1 - Prob. 2MCCh. 1 - Prob. 3MCCh. 1 - Prob. 4MCCh. 1 - Prob. 5MCCh. 1 - Prob. 6MCCh. 1 - Prob. 7MCCh. 1 - Which of the following has no partial or...Ch. 1 - Prob. 9MCCh. 1 - Which of the following has no partial dependencies...Ch. 1 - Which of the following has no repeating groups but...Ch. 1 - Prob. 12MCCh. 1 - Prob. 13MCCh. 1 - A unique identifier for a data row that consists...Ch. 1 - Which of the following symbols represents an...Ch. 1 - Prob. 16MCCh. 1 - Which of the following represents a field in a...Ch. 1 - Which of the following defines a relationship in...Ch. 1 - When part of the data in a table depends on a...Ch. 1 - Which of the following is used to join data...Ch. 1 - Which tables and fields would you access to...Ch. 1 - Prob. 2HOACh. 1 - Prob. 3HOACh. 1 - Prob. 4HOACh. 1 - Access path A database table is composed of...Ch. 1 - Prob. 6HOACh. 1 - Prob. 7HOACh. 1 - Prob. 8HOACh. 1 - Prob. 9HOACh. 1 - Prob. 10HOA
Knowledge Booster
Similar questions
- Which of the following symbols represents an optional relationship in an E-R model? a. a straight line b. a dashed line c. a straight line with a crows foot at both ends d. a straight line with a crows foot at one endarrow_forwardWhat is a model, and why do models matterarrow_forwardWhich of the following about enhanced entity relationship modeling is/are correct?arrow_forward
- WHAT IS THE RELATIONSHIP THIS TABLE ZERO TO MANY OPTIONAL ? ONE TO MANY ? ONE MANDATORY ? ONE TO ONE ? ONE ? ZERO TO ONE ? MANY ? MANY TO MANY ? ONE OPTIONAL TO MANY OPTIONAL ? ONE MANDATORY TO MANY OPTIONAL ? MANY)arrow_forwardWhich of the following is the process of analyzing data before using it with a model? * a) Extra data addition b) Exploratory data analysis (EDA) c) Building a subset d) Missing data imputationarrow_forwardQuestion 20 Which of the following might result from a many-to-many relationship? Group of answer choices exclusive subtype intersection data supertype entity recursive relationshiparrow_forward
- Question 28 Which of the following is not a basic element of the E-R Model? Group of answer choices Relationships Use cases Identifiers Cardinalities Entitiesarrow_forwardWhich of the following is a key part of conceptual design in an entity relationship model? This model resolves the many-to-many relationships to multiple one-to-many relationships. This model adds all of the attributes for each entity. This model converts attributes into columns. This model does not depend on the database management software or the hardware used to implement the model.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_forward
- I asked this question on Bartleby but didn't get a very clear response, I would like further explaination please. The answer on Bartleby said that it would be none of the options but didn't really explain why. What is the cardinality of the 'writes' relationship type? a) One-to-many b) Many-to-many c) One-to-one d) None of the other options My thought process was that it would be b) Many-to-many since: A person writes many books. And one book is also written by many people. Thus the relationship will be many to many. One to many would mean that one instance is related to many other instances. For example, the address of a house contains many people living in the house. One to one would mean that one instance is associated with only one other instance. For example, one employee will have one unique ID in an organization. So why is the answer none of the other options?arrow_forwardWhich of the following data models does not contain the many-to-many relationship between entities? What are the benefits and drawbacks of employing this model?arrow_forwardWhich among the following can be an example of Aggregation relation? a. Car and Passengers b. College and Department c. Vehicle and Engine d. Person and Leg Clear my choicearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you