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 solutionStudents have asked these similar questions
Based on 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.
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.
You have been hired as a Database Developer and you have been given the option to use a trigger and a procedure. Discuss what triggers are and when it would be best to use them?
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_forwardDBMS DATABASE (ignore the white space in diagram)arrow_forward
- Question a. Normalization is an important concept for database professionals. Whether you are the designer, database analyst or administrator, it is useful for designing, situation verification as well as performance tuning. In your opinion discuss the basic issues to be aware of before carrying out the normalization process. b. Given the following relational schema and its functional dependencies: Rentallnfo custNo propertyNo custName pAddress rentStart ownerNo OName fd1 fd2 fd3 fd4 fd5 Specify candidate keys and state the primary key. Assuming that the relation is in first normal form (1NF), describe and illustrate the process of normalizing the relational schema to second (2NF) and third (3NF) normal forms. Identify the primary and foreign keys in your third normal forms. ii.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. 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_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_forward
- Using 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_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_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_forward
- On 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_forwardSubject: Database Topic: EERD Please use UML Modelling Notation. (Don't use Chen’s Notation or Crow’s Feet Notation). The attached EERD is not the answer. it's for your reference only about UML Modelling Notation. -Based on the information given below, draw the conceptual EERD where you should include the enhanced features. A car dealership wishes to maintain data about the customers who purchase a car. Each customer may purchase one or more vehicles and each vehicle can be purchased by many different customers over time (for example, a customer maypurchase a new vehicle, trade that vehicle in and someone else can purchase the vehicle traded in.) Data that the dealership wishes to keep regarding customers includes customer identification number, name, address, homephone, work phone, cell phone and e-mail address. Information about vehicle includes vehicle identification number, make, model, year, transmission type, engine size and color. Vehicles can be a member of one of the following…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