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
Concept explainers
Question
Chapter 5, Problem 5.28PAE
Program Plan Intro
To choose the oracle datatypes for the attributes in the normalized relations in the given figure.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
For the purpose of illustrating the structure of a database, either an E-R diagram or DBDL may be used. If that's the case, which strategy do you favor, and why?
Topic: Database Design
It is known that can use the DBMS system to create a surrogate primary key when there is a natural key. What implications does this have on the DB performancewhen searching the table for a specific column (such as ROOM). Hint: When the table is created, the DBMS setups the table to be able to search on the primary key very quickly. What if this Event table was used by a Corporate Hotel chain to keep track of every they have hosted over the past 30 years in all of their hotels across all their chains (i.e. 8000 locations, 5 events a week avg, 30 years of data ~62.4 million events)?
The following tables form part of a database held in a relational DBMS:
• Hotel (hotelNo, hotelName, city)
• Room (roomNo, hotelNo, type, price)
• Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)
• Guest (guestNo, guestName, guestAddress)
where Hotel contains hotel details and hotelNo is the primary key;
Room contains room details for each hotel and (roomNo, hotelNo) forms the primary key;
Booking contains details of bookings and (hotelNo, guestNo, dateFrom) forms the primary key;
Guest contains guest details and guestNo is the primary key.
1. Identify the foreign keys in this schema. Explain how the entity and referential integrity rules apply
to these relations.
2. Produce some sample tables for these relations that observe the relational integrity rules. Suggest
some general constraints that would be appropriate for this schema.
3. Analyze the RDBMSS that you are currently using. Determine the support the system provides for
primary keys, alternate keys, foreign keys, relational…
Chapter 5 Solutions
Modern Database Management (12th Edition)
Ch. 5 - Prob. 5.1RQCh. 5 - Prob. 5.2RQCh. 5 - Prob. 5.3RQCh. 5 - Prob. 5.4RQCh. 5 - Prob. 5.5RQCh. 5 - Prob. 5.6RQCh. 5 - Prob. 5.7RQCh. 5 - Prob. 5.8RQCh. 5 - Explain why you sometimes have to reserve much...Ch. 5 - Why are field values sometimes coded?
Ch. 5 - Prob. 5.11RQCh. 5 - Prob. 5.12RQCh. 5 - Explain why normalized relations may not comprise...Ch. 5 - Prob. 5.14RQCh. 5 - List three common situations that suggest that...Ch. 5 - Explain the reasons why some experts are against...Ch. 5 - Prob. 5.17RQCh. 5 - Prob. 5.18RQCh. 5 - Prob. 5.19RQCh. 5 - Prob. 5.20RQCh. 5 - Prob. 5.21RQCh. 5 - State nine rules of thumb for choosing indexes.Ch. 5 - One of the strongest recommendations regarding...Ch. 5 - Explain why an index is useful only if there is...Ch. 5 - Indexing can clearly be very beneficial. Why...Ch. 5 - Consider the following two relations for...Ch. 5 - Prob. 5.28PAECh. 5 - Prob. 5.29PAECh. 5 - Prob. 5.30PAECh. 5 - Prob. 5.31PAECh. 5 - Suppose you are designing a default value for the...Ch. 5 - When a student has not chosen a major at a...Ch. 5 - Prob. 5.34PAECh. 5 - Prob. 5.35PAECh. 5 - Consider the relations in Problem and Exercise...Ch. 5 - Prob. 5.37PAECh. 5 - Prob. 5.38PAECh. 5 - Prob. 5.39PAECh. 5 - Prob. 5.40PAECh. 5 - Prob. 5.41PAECh. 5 - Consider the relations specified in Problem and...Ch. 5 - Prob. 5.43PAECh. 5 - Prob. 5.44PAECh. 5 - Prob. 5.45PAECh. 5 - Prob. 5.46PAECh. 5 - Prob. 5.47PAECh. 5 - Problems and Exercises 8-65 through 8-68 refer to...Ch. 5 - Refer to the large Pine Valley Furniture Company...Ch. 5 - Problems and Exercises 8-65i5 through 8-68 refer...Ch. 5 - Refer to Figure 4-5 0. For each of the following...
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
- BITS Corporation Exercises 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 a diagram. You may use any of the styles presented in this chapter for the diagram. 1. Indicate the changes you need to make to the design of the BITS database to support the following situation. A client is not necessarily represented by a single consultant but can be represented by several consultants. 2. Indicate the changes you need to make to the design of the BITS database to support the following situation. There is no relationship between clients and consultants. When a client places an order (service request), it may be performed by any consultant. On the order, identify both the client placing the order and the consultant responsible for the order. 3. Indicate the changes you need to make to the BITS database design to support the following situation. The region where clients are…arrow_forwardQuestion 2 UNISHOP is a company that manages equipment products, invoices from their respective vendors and sales representatives (SalesRep). UNISHOP vendors have been complaining about poor management of their product handling in the current manual system. As a result, the top management has decided that information related to the vendors should be organized using a DBMS. You have been hired to design the database. Draw an Entity Relationship Diagram (ERD) to represent the database based on the requirements given below: · An Invoice is used to keep track of the Product manage by SalesRep. customerName, customerAddress and customercity. The invoice is uniquely identified by its unique invoiceld. The invoice is written by only one salesrep but a salesrep may write zero or many invoices · SalesRep stores information about SalesRepID, SalesRepName and SalesRep Tel. · SalesRep manages the products. The Products store information such as ProductId, Productname, ProductInfo, SalesReplD and…arrow_forwardTo depict the structure of a database, you can use either an E-R diagram or DBDL. Which method do you favor, and why?arrow_forward
- The 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_forwardMap each of theER diagrams given below to a relational database by specifying its SQL schema. Make sure you capture as many integrity constraints as possible and explicitly mention those that cannot by captured by the SQL schema (if any). Please provide simplified SQL schema and have it typed/ Please do not copy other answers from Chegg they are incorrect. I will upvotearrow_forwardUsing the relations that I attached, defined and normalized, create the SQL DDL statements necessary to implement database schema as an OpenOffice database. You may also implement your database in MySQL, IBM DB2 Express, Microsoft Access, SQL Server if you have access to these database systems. The answer should include a document that contains all of the SQL statements that you created and a screenshot that shows the structures that you implemented in the database of your choice. Your DDL statements must accommodate the following elements: Create statements to create tables from the entities defined as part of the attachment. Appropriate use of Null (and Not Null) parameters to ensure data validity Appropriate use of constraint clauses to implement appropriate referential integrity Use of data types and formats that is appropriate for the data in your database schema. Appropriate use of keys including automatic generation of key values if appropriate Shoulkd include: * the…arrow_forward
- Explain the concept of normalization in database development. Why is it important, and what are the normal forms?arrow_forwardYou may use either an E-R diagram or DBDL to illustrate the structure of a database. Which approach do you prefer, and why?arrow_forwardHi, can you help me with this question? I have an exam coming up, and I'm using the book problems to study. The manager of a consulting firm has asked you to evaluate a database that contains the table structure shown in Table P6.10. (This should be attached). Table P6.10 was created to enable the manager to match clients with consultants. The objective is to match a client within a given region with a consultant in that region and to make sure that the client's need for specific consulting services is properly matched to the consultant's expertise. The following basic business rules are maintained: Each client is located in one region. A region can contain many clients. Each consultant can work on many contracts. Each contract might require the services of many consultants. A client can sign more than one contract, but each contract is signed by only on client. Each contract might cover multiple consulting classifications. Each consultant is located in one region. A region can…arrow_forward
- It is essential to discuss the various database table possibilities when dealing with subtype associations.You should first settle on a layout and then talk about the issues that are directly related to that format.arrow_forwardOn what attributes should indexes be defined to speed upthis query? Give the reasons?arrow_forwardThe attribute on which a relation is partitioned can have a significant impacton the cost of a query.a. Given a workload of SQL queries on a single relation, what attributeswould be candidates for partitioning? b. How would you choose between the alternative partitioning techniques, based on the workload? c. Is it possible to partition a relation on more than one attribute? Explain your answerarrow_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
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