Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 3, Problem 3.36PAE
Program Plan Intro
Draw an ERR model for the given scenario with addition of supertypes and subtypes.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
When using subtype associations, talk about the database table choices that are accessible.Decide the design you want to employ and talk about the relevant issues.
1.
Determine the functional dependencies that exist in the following table and then convert
this table to an equivalent collection of tables that are in third normal form.
OFFICE (OFFICE NUM, OFFICE NAME, (ADDRESS, SQR_FT, BDRMS,
FLOORS, MONTHLY RENT, OWNER_NUM))
2. Determine the functional dependencies that exist in the following table and then convert
this table to an equivalent collection of tables that are in third normal form.
PROPERTY (PROPERTY ID, OFFICE NUM, ADDRESS, SQR_FT,
BDRMS, FLOORS, MONTHLY RENT, OWNER NUM, LAST NAME,
FIRST NAME)
Create a relational diagram for the database using crow’s foot notation. The ERD should include all the entities, relationships, and connectivity where applicable.
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 records the date of check-out, patron’s ID, the identifier of the book copy…
Chapter 3 Solutions
Modern Database Management (12th Edition)
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Prob. 3.2RQCh. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?
Ch. 3 - Prob. 3.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - Prob. 3.16RQCh. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAECh. 3 - Prob. 3.30PAECh. 3 - Develop an EER model for the following situation,...Ch. 3 - Draw an EER diagram for the following description...Ch. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 3 - Add the following to Figure 3-16: An EMPLOYMENT...
Knowledge Booster
Similar questions
- The following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with an Entity Relationship Diagram. 3. Indicate the changes you need to make to the BITS database design to support the following situation. The region where clients are located is divided into territories. For each territory, store the territory number ( a unique identifier ) and territory name. Each consultant is assigned to a signle territory. Each client also is assigned to a single territory, but the territory must be the same as the territory to which the client's consultant is assigned.arrow_forwardThe following exercises are based on the BITS database user views as designed in Your Turn 6-1 in this chapter. In each exercise, represent your answer in DBDL and with an Entity Relationship Diagram. 4. Indicate the changes you need to make to the BITS database design to support the following situation. The region where clients are located is divided into territories. For each territory, store the territory number (a unique identifier) and territory name. Each consultant is assigned to a single territory. Each client also is assigned to a single territory, which may not be the same as the territory to which the client's consultant is assigned.arrow_forwardWhen utilizing subtype associations, it is important to discuss the database table options that are available.Decide on the design you want to use and discuss the challenges that arise as a result of it.arrow_forward
- When creating subtype associations, it is important to consider the database table possibilities accessible to you.Discuss the factors that you would consider when deciding one design to employ over the others.arrow_forwardCreate 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_forwardTasks: Considering the following E-R diagram, you need to translate it into a relational database and add some data to the tables. a) Write SQL statements to create the corresponding relations and capture as many of the participation and cardinality constraints as possible. Make sure that the data type and size for each attribute are appropriate. b) If some constraints in the diagram cannot be captured, explain why. c) Write SQL statements to insert at least two tuples for each table task name number ssn phone administrators O deptName dob Employees Caddresses salary staff's hourlySalary number M name Places N Orders M Contains N Items description P status number ID expShipDate qty deliveryDate name qtyInStock CunitCost actualShipDate salePrice email Street Customers city Addres statearrow_forward
- Create an Entity-Relationship Model for the Queen Anne Curiosity Shop The first assignment for the class project is to create an entity-relationship model of the Queen Anne Curiosity Shop database. This assignment requires you to apply the knowledge gained from study of chapter 4 of the textbook. You will create the entity-relationship model using the ERDPlus database modeling tool. The Queen Anne Curiosity Shop database contains the following tables: CUSTOMER (CustomerID, LastName, FirstName, Address, City, State, ZIP, Phone, EmailAddress) EMPLOYEE (EmployeeID, LastName, FirstName, Phone, EmailAddress) VENDOR (VendorID, CompanyName, ContactLastName, ContactFirstName, Address, City, State, ZIP, Phone, Fax, EmailAddress) ITEM (ItemID, ItemDescription, PurchaseDate, ItemCost, ItemPrice, VendorID) SALE (SaleID, CustomerID, EmployeeID, SaleDate, SubTotal, Tax, Total) SALE_ITEM (SaleID, SaleItemID, ItemID, ItemPrice) Note that the above table descriptions follow the textbook convention:…arrow_forwardMake an Entity relationship diagram and use the Erdplus and apply these requirments Using the Erdplus(use it to make this diagram, the answer should be as a Diagram) Q) Create an entity-relationship diagram (ERD) using min-max notation based on the following datarequirements of the University database:1. The university is organized into colleges, and each college has a unique number, unique name, and a particularfaculty member who is the dean of the college. Each college administers a number of academic departments.2. Each department has a unique name, a unique code number, and a particular faculty member who chairs thedepartment. We need to keep track of the start date when that faculty member began chairing the department.In addition, each department may have several faculties and must be administered by one college.3. A department offers several courses, each of which has a unique course name, a unique code number, a courselevel (Level: this can be coded as 1 for freshman level, 2…arrow_forwardWhen developing subtype associations, talk about the database table options.Discuss the factors that would influence your decision to choose one design over the others.arrow_forward
- The following exercises are based on the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. No computer work is required. 1. Using the types of entities found in the Solmaris Condominium Group database (condo locations, owners, condo units, service categories, and service requests), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your answer and show how to convert to the higher forms. 2. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form: Location (LocationNum, LocationName, (UnitNum, SqrFt, Bdrms, Baths, CondoFee)) 3. Determine the functional dependencies that exist in the following table, and then convert this table to an equivalent collection of tables that are in third normal form: CondoUnit…arrow_forwardGive some specific guidelines for defining attributes?arrow_forwardThe various database table choices should be discussed when dealing with subtype associations.Discuss the issues that are relevant to the layout you decide to utilize.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 LearningA Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
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