Oracle 12c: SQL
3rd Edition
ISBN: 9781305251038
Author: Joan Casteel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 1, Problem 15MC
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 crow’s foot at both ends
- d. a straight line with a crow’s foot at one end
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 an optional 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
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
Which of the following is not an E-R model relationship?a. some-to-manyb. one-to-onec. one-to-manyd. many-to-many
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
- Which type of relationship is shown in each case below? Motivate youranswerarrow_forwardWhich of the followings describe the relationship between “super key” and “candidate key”?(a) A super key is also a candidate key.(b) A Super key K is a candidate key, if K is minimal(c) A candidate key K is a super key, if K is minimal(d) A candidate key is also a super keyarrow_forwardWhich is not an example of the "is a" relationship? Question 1 options: A poodle is a dog. A house has a bathroom A car is a vehicle. A rectangle is a shape.arrow_forward
- Question: Determine for each update anomaly whether or not the relation Abnormal_Rel is susceptible to that anomaly. Support your determination with adequate explanation and a small example. Abnormal_Rel( ProductID, BrachID, campaignID, MemberID, ProductType, PackageType, YearProduced, Price, Brand, StockLevel, CampaignStartDate, CampaignEndDate, FirstName, LastName, eMail, MembershipLevel, MemberExpDate, Discount )arrow_forwardWhat is used to indicate a weak relationship in an ERD in Crow’s Foot notation? Dashed line between entities Double rectangular box Solid line between entities Single rectangular boxarrow_forwardWHAT 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_forward
- Which of the following is the term for a primary key of one relation placed into a second relation to establish a relationship? Group of answer choices foreign key field key referential integrity candidate key relocated keyarrow_forwardWhich of the following, when used in an E-R model, indicates the need for an additional table?a. sometimes-to-always relationshipb. one-to-one relationshipc. one-to-many relationshipd. many-to-many relationshiparrow_forwardwhich rules apply to desigining table with less redundancy? a) Binary Relationship b) Reflective Relationship c) Weak entity d) Normal formarrow_forward
- Which the following question,Subject_Code is a(n) __________ and Subject is a(n) __________? A)entities,attribute B)tuple,entity C)entity,table D)attribute,relationarrow_forward95. The keyword "inverse" is used in which of the following? a. Class b. Attribute c. Relationship d. All of the above.arrow_forwardwhich object describes a set of values in a table? a) A relationship b) An attribute c) An entity d) A rulearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
SQL Basics for Beginners | Learn SQL | SQL Tutorial for Beginners | Edureka; Author: edureka;https://www.youtube.com/watch?v=zbMHLJ0dY4w;License: Standard YouTube License, CC-BY