Database Systems: Design, Implementation, & Management
12th Edition
ISBN: 9781305627482
Author: Carlos Coronel, Steven Morris
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Chapter 2, Problem 15P
Program Plan Intro
The Crow’s Foot ERD for the relationship between PUBLISHER, BOOK, CONTRACT, and AUTHOR is given below. In the given model, the connectivity’s “1” is represented by a short line segment, and “M” is represented by the three-pronged crow’s foot and the relationship name “publishes”, “writes”, “signs” and “submits” is written above the relationship line.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Write the business rules that are reflected in the ERD shown in Figure P2.15. (Note that the ERD reflects some simplifying assumptions. For example, each book is written by only one author. Also, remember that the ERD is always read from the “1” to the “M” side, regardless of the orientation of the ERD components.)
FIGURE P2.15 THE CROW’S FOOT ERD FOR PROBLEM 15
Please answer.
What are the key distinctions between overlapping and disjoint constraints, and how do you
distinguish between the two?
Chapter 2 Solutions
Database Systems: Design, Implementation, & Management
Ch. 2 - Prob. 1RQCh. 2 - What is a business rule, and what is its purpose...Ch. 2 - How do you translate business rules into data...Ch. 2 - Prob. 4RQCh. 2 - Explain how the entity relationship (ER) model...Ch. 2 - Prob. 6RQCh. 2 - Prob. 7RQCh. 2 - Prob. 8RQCh. 2 - Prob. 9RQCh. 2 - Prob. 10RQ
Ch. 2 - What is a relationship, and what three types of...Ch. 2 - Give an example of each of the three types of...Ch. 2 - What is a table, and what role does it play in the...Ch. 2 - Prob. 14RQCh. 2 - Prob. 15RQCh. 2 - Prob. 16RQCh. 2 - Prob. 17RQCh. 2 - Prob. 18RQCh. 2 - Prob. 19RQCh. 2 - Prob. 20RQCh. 2 - Prob. 21RQCh. 2 - Prob. 22RQCh. 2 - Prob. 23RQCh. 2 - Prob. 1PCh. 2 - Prob. 2PCh. 2 - Prob. 3PCh. 2 - Prob. 4PCh. 2 - Prob. 5PCh. 2 - Using Figure P2.6 as your guide, work Problems 68....Ch. 2 - Prob. 7PCh. 2 - Prob. 8PCh. 2 - Typically, a hospital patient receives medications...Ch. 2 - Prob. 10PCh. 2 - Prob. 11PCh. 2 - Prob. 12PCh. 2 - Prob. 13PCh. 2 - Prob. 14PCh. 2 - Prob. 15PCh. 2 - Prob. 16PCh. 2 - Prob. 17P
Knowledge Booster
Similar questions
- Consider the following entity relationship diagram. Booking Employee Room Building • Booking ID • Employee ID • Building ID • Room ID • First Name • Room ID P • Name Description • Employee ID • Name Last Name • Date • Campus Zone • Email Address • Capacity • Start Time • Map Coordinates Phone • Bookable • End Time For each statement below, use the drop-down box to indicate whether it is true (answer 1) or false (answer2), according to the design decisions encoded in the ERD. Every booking is associated with exactly one employee. ✓ Every employee is associated with at most one booking. ✓ A building may contain no rooms that are recorded in the database. Each room may have many bookings. 1. True ✓ A room must have at least one booking. 2. False ✓ A booking can be associated with many employees. An employee may have no phone number recorded. ✓ A room must have its capacity recorded. ✓ A building is uniquely identified by its map coordinates.arrow_forwardAssignment: Problem #7 from Chapter 4 of the textbook. The case study is United Helpers. With the use of Microsoft Visio, draw YOUR entity relationship diagram (ERD) using Crow's foot notation to indicate entities, relationships, optionalities, connectivities and cardinalities. In addition, be sure to include a heading on your ERD with a brief descriptive title, your name, and a date. It is suggest that you write out business rules but the rules do not need to be submitted. 7. How would you (graphically) identify each of the following ERM components in a Crow’s Foot notation? an entity the cardinality (0,N) a weak relationship a strong relationshiparrow_forwardCreate an ER diagram that correctly describes the database for exams at Campus in Bäcksvängen in accordance with the following description: (Own assumptions must be clearly described.) Staff for various functions are involved in the exams. All staff have a full name and a unique staff code. Some people are examiners on one or more courses. A course has one name and one unique ladok code. For a course, you can add up its points based on the associated elements. One part is part of a course (for example an exam, a laboratory or project). A course can have several different parts. An element has a name, a description, a torque code, one point and two or more grades (eg: U, G, VG). An element can only belong to one course. Since the database is to process the exams, it is obvious that a part like described as an examination has an examination opportunity that is identified, among other things, by the date, start time, end time and that it is possible to calculate total writing time. A…arrow_forward
- You will need to create the database tables and choose sensible data types for each column.Make sure to maintain entity and referential integrity, and implement all the above constraints.Since other developers work in parallel on other parts of the system, you will need to strictly follow the above specification to correctly implemented in your database. Otherwise, the other software will not be able to use your database. This means, one needs to be able to rely on all constraints being correct, the spelling of table and column names being as given, and that the data types that you chose will allow for sensible data to be added to the database in the future.For testing purposes, you are asked to insert the data specified below into the tables, but no other data except this.In short:1. You will need to create the tables as specified2. You will need to add the data specified Please use the 3.sql and implement your tables using the sketched CREATE TABLE commands. Add the necessary queries…arrow_forwardDraw Schema Diagramarrow_forwardDraw three sequence diagrams for three use cases in the use case diagram attached. Please draw the sequence diagram similar to the attatched second photo.arrow_forward
- In the ER diagram for a Point of Sale system, there are entities such as Cashier, Product,Checkout, Transaction, CheckoutStand, Return, Inventory, etc. Here inventory records each storagelocation and its capacity. Sometimes, a customer may need to come back to pickup their items afterchecking out while most of the time they leave the store with their purchases. Which of the following is thebetter design for manage transactions?A) Add an attriute to transaction to indicate whether goods have been pickuped or notB) Create two subtyeps of TransactionC) Create a weak entity Pickup to link with TransactionD) Add a relationship between Transaction and Productarrow_forwardDescribe entity integrity constraint in your own words.arrow_forwardGiven the following relation that stores details of employees and their projects: ProjectID EmployeeName EmployeeSalary 100-A Salim Housni 2000 100-A Taleb Maashani 1800 100-B Taleb Maashani 1800 200-A Salim Housni 2000 200-B Salim Housni 2000 200-C Salim Housni 1350 200-C Taleb Maashani 1800 200-D Salim Housni 1350 If the functional dependencies are consistent with the above relation, put TRUE. If they are not, put FALSE ProjectID --> EmployeeName (....) ProjectID --> EmployeeSalary (....) ProjectID , EmployeeName -->EmployeeSalary (....) EmployeeName --> EmployeeSalary (....) EmployeeSalary --> ProjectID (....) EmployeeSalary --> EmployeeName , ProjectID (....)arrow_forward
- Draw an ERD for the following problem:Company organized into departments. Each department has unique, name and a particular employee who manages the department. Start date for the manager is recorded. Department may have several locations. A department controls a number of projects. Projects have a unique name, number and a single location. Company’s employees name, ssno, address, salary, sex and birth date are recorded. An employee is assigned to one department, but may work for several projects (not necessarily controlled by her dept). Number of hours/week an employee works on each project is recorded; the immediate Supervisor for the employee. Employee’s dependents are tracked for health insurance purposes (dependent name, birthdate, relationship to employee).arrow_forwardDraw an E-R diagram for each of the descriptions below. Q -An architectural design firm has a number of design projects underway at any point in time. Each of these projects is identified by a unique project identification code. Additional data stored for each project includes a description, a target completion date, and a dollar budget amount. Design associates staff these projects. These associates include architects, engineers, and computer CAD (Computer-Aided Design) specialists. Each associate is identified by a unique code. Other information about associates includes their name, specialty, their level. There are three levels of associates (gold, silver, and bronze). The bronze associates report to one and only one silver associate (who typically has at least one bronze associates reporting to her), and the silver associate reports to a gold associate in the same fashion. Each project staffed by at least one associate staff. It is also common to find any particular associate…arrow_forwardThe contrasting characteristics of overlapping and disjoint constraints are the focus of this description.arrow_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
Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
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
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning