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 is NOT true about the diagram?
Select one:
a. If the "description" attribute is separated as a class, "price" and "itemID" should be defined as attributes of the description class.
b.It is a design class diagram.
c.It captures real world concepts.
d.According to the design, there will be no record of items left in the system after all item instances are sold out.
e.It can be improved by taking out the "description" attribute and define it as a separate class.
Answer only if you are 100% sure . Correct and detailed answer will be Upvoted else downvoted.
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
- Create an in-depth description of the process you use to construct a model in Plaxis, keeping in mind the points below.arrow_forwardUsing Pseudocode, Flowchart and Unified Modelling Language (UML) Class diagrams:Write a program for a Semester registration system for registering Freshmen students (L100 students). NB:You are expected to provide:The Pseudocode for the procedureThe Flowchart for the procedureThe diagrammatic representation of the procedure using the UML class diagramsarrow_forwardWhen is it possible for an object diagram to change? What has changed?arrow_forward
- Read the prompt: A book may contain many chapters and each chapter may contain many sections. It is asked to create a digest for all the books in a library. A digest for a book includes a summary for the whole book, a summary for each chapter, and a summary for each section. You are asked to use one structural design pattern and one behavioral design pattern to develop this book digesting system. Instructions: Question 1:What design patterns would be the best fit? Pick 2 from this list (one structural design pattern and one behavioral design) Composite ⦁ Decorator ⦁ Filter ⦁ Interface+Abstract Class ⦁ Dynamic Linkage ⦁ Chain-of-Responsibility ⦁ Visitor ⦁ Proxy ⦁ Façade ⦁ Mediator ⦁ State ⦁ Null Object ⦁ Template method ⦁ State ⦁ Read-only Interface ⦁ Command ⦁ Flyweight ⦁ Snapshot ⦁ Dynamic Linkage ⦁ Observer ⦁ Cache Management ⦁ Façade NOTE: I picked template and composite Question 2: Please provide the UML class diagram design for the two design chosen above. No explanation is…arrow_forwardInstructions: Create a UML diagram for a Dog class. You can get some useful information from your book Review Chapter 5 Pg. 179-180. CLASS NAME List the instance variables in the constructor. Unified Modeling Language (UML) List the methods in the class. o - indicates private o name is the variable name o string is the data type of name CLASS NAME List the instance variables in the constructor. o + indicates public o getName is the method name o o string is the return data type List the methods in the class. The second row of the UML diagram lists the instance variables in the constructor. For example -name: string Java.util. The third row of the diagram lists the methods in the class. For example, +getName(): string empty parenthesie indicate nothing is sent to the method.arrow_forward1 Draw a Use-case diagram based on the facts below. t of A Magazine is compiled by an Editor. It is published by a publisher. Sold by Agents. Read by Adults. Moreover, for an adult to read a magazine, he/she must buy it from an agent that is selling it. Note: Option 1: Can complete the diagram on paper and snap a photo of it with your student ID placed on top right hand corner. Later send it on computer and attach or paste it in the space provided. Option 2: Can complete the diagram using any online tool such as Visio and paste the screenshot in the space provide if not attach. 三 A- TI I BIEarrow_forward
- Which of the following is not an E-R model relationship?a. some-to-manyb. one-to-onec. one-to-manyd. many-to-manyarrow_forwardNO PLAGARISM please! Correct and detailed answer will be Upvoted else downvoted. Thank you!arrow_forward1. Create the initial ER diagram for a car dealership. The dealership sells bothnew and used cars, and it operates a service facility. Base your design on thefollowing business rules:a. A salesperson can sell many cars, but each car is sold by onlyonesalesperson.b. A customer can buy many cars, but each car is sold to only onecustomer.c. A salesperson writes a single invoice for each carsold.d. A customer gets an invoice for each car(s) hebuyse. A customer might come in only to have a carserviced; that is, one need not buya car to be classified as a customer.f. When a customer takes in one or more cars for repair or service,one serviceticket is written for each car.g. The car dealership maintains a service history for each car serviced. The servicerecords are referenced by the car’s serialnumber.h. A car brought in for service can be worked on by many mechanics,and eachmechanic can work on many cars.i. A car that is serviced may or may not need parts. (For example, parts are…arrow_forward
- Which of the following relationships depicts an is-a relationship? School Building Teacher - School Students - Classroom Parents - Studentsarrow_forwardInstructions: Kindly create a UML class diagram based on the objects, properties, and behavior given below. I will like your solution if it is correct and complete. Please take note that these five (5) should be implemented and variables should have variable type. Thus, I will like your answer if it is correct and complete! Object Properties Behavior Furniture name, size, weight, color, material, manufacturedDate, brandName, manufacturer, price, design utility(), buy(), sell(), rent(), transfer(), destroy(), store() Chair numberOfLegs, legLength, armrest, wheels, portability, cushion, comfortability move(), sitOn(), getArea(), getPerimeter() Table numberOfLegs, legLength, portability, sides, shape, width, height getArea(), getPerimeter(), move(), occupy(), clean() Bed numberOfLegs, legLength, bunk move(), getArea(), getPerimeter(), layOn()arrow_forward1. Create an EER diagram to represent a museum with the information below: Note: use the attached image as a reference for what is required. The museum has a collection of art objects. Each art object has a unique identification, an artist (if known), a year (when it was created, if known), a title, an epoch (Renaissance, Modern, Ancient, etc.), and a description. The arts objects are classified in the museum in several ways as discussed below: Arts objects are categorized based on their type. The main types are: painting and sculpture, plus another type they called “other” to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is draw on (paper, canvas, wood, etc.), and style (modern, abstract, impressionism, etc.). A sculpture has a material from which it was created (wood, stone, iron, etc.), height, weight, and style. An art object in the other category has a type (print, photo,…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
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