Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Related questions
Concept explainers
Question
thumb_up100%
Consider the scenario described by the statement "A customer can make many payments, but each payment is made by only one customer." Use this scenario as the basis for an entity relationship diagram (ERD) representation.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 4 steps with 3 images
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
- Transform an entity-relationship (E-R) diagraminto an equivalent set of well-structured(normalized) relations.arrow_forwardDraw the E/R diagram. Use an arrow in the direction of any 1 in the cardinality. This has the sense of determines, for example, student determines (a unique) classroom in the dynamically changing relationship.arrow_forwardDraw an ER diagram to represent the following situation: When appropriate, model an associative entity. B.D. Owen’s Library would like to store information about AUTHORs, BOOKs, book COPYs, and PATRONs. For each AUTHOR, the library stores a unique author ID and the author’s name. For each PATRON, the library will store a unique patron ID, the patron’s name, any phone numbers the patron has, the date the patron joined the library, and the years the patron has been a member, which can be calculated from the date joined. For each BOOK, the library would like to use the ISBN as the identifier. In addition, it would like to store the book’s title, name of the publisher, date of publication, and the number of copies owned by the library. Each book COPY will have a copy number, which uniquely identifies that copy in conjunction with a particular BOOK. The library will also record the condition code of the copy (i.e. excellent, good, fair, poor), last date checked out, and last date returned.…arrow_forward
- Prepare an Entity Relationship Diagram for the application described in the following paragraph. Pick and Shovel Construction Company is a multi-state building contractor specializing in medium-priced town homes. Assume that Pick and Shovel’s main entities are its customers, employees, projects and equipment. A customer can hire the company for more than one project, and employees sometimes work on more than one project at a time. Equipment, however, is assigned to only one project at a time. Draw an ERD showing those entities.arrow_forwardPLZ help with the following: Create a Crow’s Foot ERD. Draw YOUR entity relationship diagram (ERD) to indicate entities, relationships, connectives, and resolve M:N relationships. For the following: The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have neverbeen checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book number, book title, book subject, and year of publication. For each author, the library records the author ID,…arrow_forwardQuiz-2 Section C 1. What is the purpose of activity diagram? Give a situation where you should use the forking concept. [4] 2. Draw an activity diagram for the following case [16] A swimline diagram for the following scenario to withdraw money from an ATM. Use only this description (do not make up your own information!). The customer inserts the ATM card and then enters their pin number. The Bank system then validates the pin. If the pin is invalid, the ATM machine ejects the card, the customer takes the card, and the scenario ends. Assuming the card pin was valid, the customer enters an amount to withdraw. The bank checks the account balance. If the balance is less than the amount to withdraw, the ATM shows the balance, and then ejects the card. Once ejected the customer then takes the card and the scenario ends. Assuming the amount is available, the customer takes money from the slot and at THE SAME TIME the bank debits the account. Once the customer has taken money and the account…arrow_forward
- what can be very interesting about the Entity-Relationship (ER) Modeling that people may forget about ( i am not talking about the main function or explication but just a concept/part that people tend to overlook when they study it for the first time?arrow_forwardCreate an Entity-Relationship model for the following descriptions: Doctors, nurses, and patients have the following unique numbers respectively: doctorNo, nurseNo, and patientNo.arrow_forwardQuestion 3 Draw a complete ER diagram using Crow's foot notation based on the given business rules below: A sales representative can write many invoices. (In a business environment, each invoice represents a sales transaction. Given the "commission set" label, one might infer that the sales rep earns a commission on each sale for which an invoice is written) Each invoice is written by a single sales representative. A customer can generate many invoices. (Each time a customer makes a purchase of one or more items, and invoice is generated) Each invoice is generated by a single customer. Each invoice includes one or more invoice lines. (Each item purchased is recorded in an invoice line) Each invoice line is associated with one (and only one) invoice. Each invoice line records a single product. Each product can be recorded in many invoice lines. (If the inventory contains 100 hammers, each one may be sold and, therefore, each of those 100 hammers may at some point be recorded in an…arrow_forward
- Draw an ER diagram for the EMU Slimming Center based on the specification given below. Case Study 01 There are many dietitians in the center. There are also many clients in the center. A dietitian gives a menu to a client every week. Many diet menus are available. A diet menu consists of many food items and each food items belongs to one food category. Instructions • Identify the relationship between Entities (clearly showing the cardinality and participation)arrow_forwardCan you define the weak entity type for me? Is there a secret to it? Provide an instance Just what does it mean to specialize in attribute?Where does ia fit into an ER diagram? Provide Illustration or Diagramarrow_forwardThere are certain constraints imposed by selection structures in computer programming, notwithstanding their use. The same procedure must be followed in all cases, whether dealing with consumers, online clients, or other sorts of transactions. Is it true that various criteria apply to various occupations? So, why are these structures so special? There are certain constraints imposed by selection structures in computer programming, notwithstanding their use. The same procedure must be followed in all cases, whether dealing with consumers, online clients, or other sorts of transactions. Is it true that various criteria apply to various occupations? So, why are these structures so special? There are certain constraints imposed by selection structures in computer programming, notwithstanding their use. The same procedure must be followed in all cases, whether dealing with consumers, online clients, or other sorts of transactions. Is it true that various criteria apply to…arrow_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