ORACLE 12C: SQL
17th Edition
ISBN: 9781305449947
Author: CASTEEL
Publisher: CENGAGE L
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 1, Problem 18MC
Which of the following defines a relationship in which data can have multiple occurrences in each entity?
- a. one-to-one
- b. one-to-many
- c. many-to-many
- d. none of the above
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
Which of the following best describes a relationship in which each instance of
data in one entity is described by multiple instances of data in the other?
a. one-to-one
b. one-to-many
c. many-to-many
d. none of the above
Which of the following best describes a relationship in which each instance ofdata in one entity is described by multiple instances of data in the other?
a. one-to-one
b. one-to-many
c. many-to-many
d. none of the above
A ternary relationship is a relationship which
includes
Select one:
O a. Two entities
O b. Three entities
Oc. One entity
O d. Four entities
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
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
- What is a relation?arrow_forwardWhich of the following best describes a relationship in which each instance of data in one entity is described by multiple instances of data in the other? a)one to one b) one to many c) many to many d)nonearrow_forwardWhich statement is associated with two seperate entities. a) Attribute b) Entity Type c) Reflective Relationship d) Relationshiparrow_forward
- Which of the following defines a relationship in which each occurrence of data in one entity is represented by only one occurrence of data in the other entity?a. one-to-oneb. one-to-manyc. many-to-manyd. none of the abovearrow_forwardTRUE or FALSE - A super-entity can only have two sub-entities and no more. Select one: a.FALSE b.TRUEarrow_forwardWhich of the following defines a relationship in which each occurrence of data in one entity is represented by multiple occurrences of the data in the other entity?a. one-to-oneb. one-to-manyc. many-to-manyd. none of the abovearrow_forward
- In an ERD, entities do not have columns. Instead which of the following is used to describe the entity's characteristics? Group of answer choices attributes degrees instances relationshipsarrow_forwardReference: A --> B--> C QUestion? what is the defintion of this type of relationship and what is an example of it?arrow_forwardQ2- What is a composite entity, and when is it used?arrow_forward
- Subject - Fundamentals to Database Question 4 An entity-relationship diagram (ERD) is a specialized graphic that illustrates the relationships between entities in a database. ERD often use symbols to represent three different types of information. Draw the ERD for the following scenario: (a) Each lecturer is identified by a uniqie number, name and phone. A lecturer teaches several courses and for each course there us a unique code and title. There might be several be several lecturers in a course. (b) A university where a student may take many courses employs lecturer. Each lecturer teach one or more course but no course is taught by more than one lecturer. Each student has to complete two or three assignments for each course. (c) A car rent company wishes to create a database about its activities. The company has a number of vehicles. Each vehicle is of certain model. A customer can rent only one vehicle at a time. Every vehicle must be checked by an employee to make sure it is in…arrow_forwardA rental car agency classifies the vehicles it rents into four categories: compact, mid-size, full-size and sport utility. The agency wants to record the following data for all vehicles: Vehicle, Make, Model, Year and Color. There are no unique attributes for any of the four classes of vehicles. The entity type vehicle has a relationship named Rents with customer entity type. None of the four vehicle classes has a unique relationship with any entity type. Would you consider creating a supertype/subtype relationship for this problem? Why or why not?arrow_forwardInstructions: Create a complete ERD in Crow's Foot notation that can be implemented in the relational model using the descriptions below. The attributes required: Activity's ID, Activity's Title, Activity's description, Child's ID, Child's firstname and lastname, Child's Birthday, Parent's ID, Parent's number, Parent's address. The business rules are: An activity may or may not have a child signed up An activity may have many children signed up A child must have an activity A child may have many activities A child must have a parent A parent must have a child A child may have many parents A parent may have many children To submit: Write your answer in a clean sheet of paper and upload a picture of it to dropboxarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
dml in sql with examples; Author: Education 4u;https://www.youtube.com/watch?v=WvOseanUdk4;License: Standard YouTube License, CC-BY