Database Systems: Design, Implementation, & Management
11th Edition
ISBN: 9781285196145
Author: Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 2, Problem 6P
Using Figure P2.6 as your guide, work Problems 6–8. The Tiny College relational diagram shows the initial entities and attributes for the college.
FIGURE P2.6 THE TINY COLLEGE RELATIONAL DIAGRAM
Identify each relationship type and write all of the business rules.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Given the entity STUDENT and attributes: ST_INTIAL, ST_LNAME, ST_FNAME, ST_EMAIL, ST_PHONE . Use the Chen notation to depict the relationships:
I NEED ONLY ENTITY RELATIONSHIP & RELATIONAL DIAGRAM.
Convert the given ER diagram to Relational Schema.
Draw the complete diagram.
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. 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. 16P
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
- Draw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different…arrow_forwardModify the Er diagram given below and add 5 to 6 more additions to it such as entities attributes relationships etcarrow_forwardDraw an E-R diagram based on the following relational design.SeniorTeachers(teacherId, name, dept, division)TeachingAssistants(teacherId, name, dept, division).# These can be currently registered students who are employed part-time as teaching assistants,# or they can be PhD students who are employed full-time.Programmes(programmeCode, programmeName, dept, director)director → SeniorTeachers.teacherIdCourses(courseCode, courseName, credits, level, dept, division, ownedBy)ownedBy → Programmes.programmeCode# level is one of “first cycle” or “second cycle”.programmeCourses(programme, academicYear, studyYear, course, courseType)programme→ Programmes.programmeCodecourse → Courses.courseCode# studyYear is “1” or “2” for Master’s programmes and “1”, “2” or “3” for Bachelor’s programmes.# courseType is one of: “compulsory”, “compulsory-elective” or “elective”.# Programmes can include different courses in different academic years.# The same course could have a different courseType in different…arrow_forward
- Question: Draw a diagram showing the relationships for all the tables. The following tables need to be modified as shown (primary key attributes are bold, foreign key attributes are in italics): CID in Retail and Wholesale are defined as a primary key and a foreign key. CUSTOMER (CID, Name, Address) PHONE (PhoneNumber, Description, CID) RETAIL (CID, Type) WHOLESALE (CID, ContractID) CONTRACT (ContractID, Description) OLDCONTRACT (ContractID, Description) ORDER (OID, OrderDate, CID) PRODUCT (PID, Name, Price) DIVISION (DID, Name, Address) LINEITEM (OID, PID, Quantity, AmountCharged) PRODUCTION (DID, PID, Quantity, Rating) One-to-one Relationship If the foreign key will be the primary key or part of the primary key, choose the Identifying Relationship 1:1 icon. Otherwise, choose the Non-Identifying Relationship 1:1 icon.arrow_forwardThe entity type STUDENT has the following attributes: Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than one activity. Draw an ERD for this situation. What attribute or attributes did you designate as the identifier for the STUDENT entity? Why?arrow_forwardconvert the design (ER diagram) into relational schemas and capture as many of the constraints as possible.arrow_forward
- Create a relational diagram for the database using crow’s foot notation. The ERD should include all the entities, relationships, and connectivity where applicable. Additionally, please specify the business rules underlying your ERD 4 tables for the database: PATRON, BOOK_COPY, BOOK, and CHECKOUT. (Since a book may have multiple copies that may be purchased by the library at different time, it is better to have a BOOK_COPY table to avoid unnecessary data redundancy.) The data in the tables are as follows: PATRON table records a patron’s ID, name, address, phone number, and email address. BOOK table contains information such as author, title, publication date, subject, language, and a unique identifier (It can be the ISBN of the book) for each book. BOOK_COPY table records a unique identifier for each copy of a book, the date of purchase, and the identifier of the book from the BOOK table. CHECKOUT table…arrow_forward4-44. Figure 4-35 shows an EER diagram for Vacation Property Rentals. This organization rents preferred properties in several states. As shown in the figure, there are two basic types of properties: beach properties and mountain properties. Transform the EER diagram to a set of relations and develop a relational schema. Diagram the functional dependencies and determine the normal form for each relation. Convert all relations to third normal form, if necessary, and draw a revised relational schema. Suggest an integrity constraint that would ensure that no property is rented twice during the same time interval.arrow_forwardWrite the Relation Model, using SQL, for the gig Relationship Set shown in this ER Model: The Band and Venue Entity Sets both have the conflicting name as their Primary Keys. Only the gig relation needs to be defined for this question.arrow_forward
- Create a relational schema for this diagram:arrow_forwardDraw an Entity Relationship Diagram of Store Management System(Retail Store Database). Properly mention the entities, identify the relationships and find the cardinality of each relation very carefully. At this point of time your ERD should be final and not any major changes should occur. Properly mention following: a. Entity b. Relationship c. Attributes d. Cardinality iF HAND WRITTEN THE DIAGRAM SHOULD BE NEAT DO NOT POST COPIED DIAGRAMarrow_forwardUsing the relations ATTACHED, normalize your relations into first, second, and third normal forms. First, KINDLY describe the changes required to your relations to meet the standard of the first 1NF and then 2NF and lastly 3NF. Then, you should provide an Entity Relationship diagram that is in 3NF. All attributes, entities, keys, and relationships should be included and labelled. Hint: Remember that in the hospital software system, the “Patient” relation includes the “medicines” attribute and the “Appointment” relation includes the “allergies” attribute. Allergies describe a list of any known allergies and medicines describe a list of medicines prescribed for a patient. Please add: Define or describe the changes required to get the relations into the 1st normal form. Define or describe the changes required to get the relations into the 2nd normal form. Include an Entity Relationship diagram in the 3rd normal form. The primary and foreign keys, at a minimum, are defined for each…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
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Enhanced Entity Relationship Model; Author: Data Science Center;https://www.youtube.com/watch?v=ocQUtXPumdQ;License: Standard YouTube License, CC-BY