New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
database management systems
Modern Database Management 12th Global Edition Topi Hoffer, Venkataraman - Solutions
What are the benefits of a hash index table?
Which index is most suitable for decision support and transaction processing applications that involves online querying? Explain your answer.
What are the advantages and disadvantages of horizontal and vertical partitioning?
Explain the reasons why some experts are against the practice of denormalization.
Why would a database administrator create multiple tablespace? What is its architecture?
Explain why it makes sense to first go through the normalization process and then denormalize.
Explain why normalized relations may not comprise an efficient physical implementation structure.
Describe three ways to handle missing field values.
What is a partition view in Oracle? What are its limitations?
Why are field values sometimes coded?
Explain why you sometimes have to reserve much more space for a numeric field than any of the initial stored values require.
Suggest some limitations of normalized data as outlined in the text.
Explain how physical database design has an important role in forming a foundation for regulatory compliance.
How are data usage statistics estimated and depicted in physical design?
What are the key decisions in physical database design?
Is a proper physical design only about storage? List the consequences of a proper design.
Contrast the following terms:a. horizontal partitioning; vertical partitioningb. physical file; tablespacec. normalization; denormalizationd. range control; null controle. secondary key; primary key
Translate a relational data model into efficient database structures, including knowing when and how to denormalize the logical data model.
Describe the purpose of indexes and the important considerations in selecting attributes to be indexed.
Describe three important types of file organization.
Select an appropriate file organization by balancing various important design factors.
Choose storage formats for attributes from a logical data model.
Describe the physical database design process, its objectives, and its deliverables.
If necessary, revisit and modify the EER diagram you created in Chapter 3, 3-44 to reflect any changes made in answering 4-64 and 4-65 above.
Does it make sense for FAME to use enterprise keys? If so, create the appropriate enterprise keys and revise the relational schema accordingly.
Analyze and document the functional dependencies in each relation identified in 4-63 above. If any relation is not in 3NF, decompose it into 3NF, using the steps described in this chapter. Revise your relational schema accordingly.
Map the EER diagram you developed in Chapter 3, 3-44 to a relational schema using the techniques described in this chapter. Be sure to appropriately identify the primary and foreign keys as well as clearly state referential integrity constraints.
Find a form or report from a business organization, possibly a statement, bill, or document you have received.Draw an EER diagram of the data in this form or report.Transform the diagram into a set of 3NF relations.
Using the online Appendix B, available on the book’s Web site, as a resource, interview a database analyst/designer to determine whether he or she normalizes relations to higher than 3NF. Why or why not does he or she use normal forms beyond 3NF?
Obtain an EER diagram from a database administrator or system designer. Using your understanding from the text, convert this into a relational schema in 3NF. Now interview the administrator on how they convert the diagram into relations? How do they impose integrity constraints?What was the need
Interview system designers and database designers at several organizations. Ask them to describe the process they use for logical design. How do they transform their conceptual data models (e.g., E-R diagrams) to relational schema? What is the role of CASE tools in this process?Do they use
A bus company is responsible for offering public transportation in the suburbs of a large metropolitan area. The company has significant data management requirements:It needs to keep track of its 150 vehicles, 400 drivers, 60 bus routes, and hundreds of scheduled departures every day. In addition,
A start-up is working on an online personal financial management system. The goal of the system is to provide the users an opportunity to obtain item-level purchase data from as many sources as possible in order to improve the accuracy of budget management and control activities(instead of only at
The following attributes represent data about a movie copy at an online video rental service. Each movie is identified by a movie number and has a title and information about the director and the studio that produced the movie. Each movie has one or several characters, and there is exactly one
The following attributes form a relation that includes information about issue and return of books by students from a university library. Students of each department in university, are authorized to issue and return the books for a specific time period (characterized with attributes Issue Start
Explore the data included in Table 4-9.Assume that the primary key of this relation consists of two components: Author’s ID (AID) and Book number(BNbr). The relation includes data regarding authors, books, and publishers. In addition, it tells what an individual author’s per book royalty amount
Figure 4-40 shows an EER diagram for a gym which appoints trainers based on their expertise and has designed programs to be offered to its members.a. Transform the EER diagram to a set of relations and develop a relational schema.b. Diagram the functional dependencies and determine the normal form
How would Problems and Exercises 4-50 and 4-51 change if a type of fish could be supplied by multiple suppliers?
For Problem and Exercise 4-50, draw the ER diagram based on the normalized relations.
A pet store currently uses a legacy flat file system to store all of its information. The owner of the store, Peter Corona, wants to implement a Web-enabled database application.This would enable branch stores to enter data regarding inventory levels, ordering, and so on. Presently, the data for
Examine the set of relations in Figure 4-39.What normal form are these in? How do you know this? If they are in 3NF, convert the relations into an EER diagram.What assumptions did you have to make to answer these questions?
Figure 4-38 includes an EER diagram for a mediumsize software vendor. Transform the diagram into a relational schema that shows referential integrity constraints(see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.
Figure 4-37 includes an EER diagram describing a publisher specializing in large edited works. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.
Figure 4-36 includes an EER diagram describing a scenario where group of institutes organizes workshops.Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are
For your answers to Problem and Exercise 3-33 from Chapter 3, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form.
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.a. Transform the EER diagram to a set of relations and develop a
Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment (identified by Shipment#) uniquely identifies the shipment Origin, Destination, and Distance. The shipment Origin and Destination pair also uniquely identifies the Distance.a. Develop a diagram that shows
The materials manager at Pine Valley Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data required for this application.a. Draw a dependency diagram for this data. You may assume the
The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space.)a. Convert this table to a relation in first normal
Transform Figure 2-15a, attribute version, to 3NF relations.Transform Figure 2-15b, relationship version, to 3NF relations. Compare these two sets of 3NF relations with those in Figure 4-10.What observations and conclusions do you reach by comparing these different sets of 3NF relations?
For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form.a. Chapter 3, Problem and Exercise 3-31.b. Chapter 3, Problem and
Transform the relational schema developed in Problem and Exercise 4-37 into an EER diagram. State any assumptions that you have made.
Table 4-5 below shows an invoice for an order. Your assignment is as follows:a. Draw a relational schema and diagram the functional dependencies in the relation.b. In what normal form is this relation?c. Decompose invoice into a set of 3NF relations.d. Draw a relational schema for your 3NF
Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows:a. Draw a relational schema and diagram the functional dependencies in the relation.b. In what normal form is this relation?c. Decompose GRADE REPORT into a set of 3NF relations.d. Draw a relational
Figure 4-34 (page 197) shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. Your assignment is to:a. Develop a relational schema.b. Show the functional dependencies.c. Develop a set of 3NF relations using an enterprise key.
Table 4-3 (page 196) contains sample data for vehicles and for operators who ply these vehicles.In discussing these data with users, we find that vehicle ID (but not descriptions) uniquely identify vehicles and that operator names uniquely identify operators.a. Convert this table to a relation
Figure 4-33 (page 196) shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants. Each charge is identified by the date and time of the charge as well as the primary keys
Figure 4-32 shows the performance ranking for Motion Bank.Convert this user view to a set of 3NF relations using an enterprise key. Assume the following:• A branch has a unique location.• An employee has a unique designation.• A department has a unique name.
For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form:a. Chapter 2, Problem and Exercise 2-37bb. Chapter 2, Problem and
For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies (other than those implied by the primary key) are shown where appropriate.a. EMPLOYEE(EmployeeNo, ProjectNo)b.
For each of the following EER diagrams from Chapter 3:I. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).II. For each relation, diagram the functional dependencies (see Figure 4-23 for an example).III. If
For each of the following E-R diagrams from Chapter 2:I. Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema):II. For each relation, diagram the functional dependencies(see Figure 4-23 for an example).III. If any
Why is it important to understand merge relations?
Explain three conditions that suggest a surrogate key should be created for the primary key of a relation.
Describe the difference between how a 1:M unary relationship and an M:N unary relationship are implemented in a relational data model.
Explain what can be done with primary keys to eliminate key ripple effects as a database evolves.
Under what conditions must a foreign key not be null?
What is the relationship between the primary key of a relation and the functional dependencies among all attributes within that relation?
How do you represent an associative entity in a relational data model?
How do you represent an M:N ternary relationship in a relational data model?
How do you represent a 1:M unary relationship in a relational data model?
What are the benefits of enforcing the integrity constraints as part of the database design and implementation process (instead of doing it in application design)?
Explain how each of the following types of integrity constraints is enforced in the SQL CREATE TABLE commands:a. entity integrityb. referential integrity
List three conditions that you can apply to determine whether a relation that is in first normal form is also in second normal form.
Discuss how transitive dependencies in a relation can be removed when it leads to anomalies.
Why is normalization useful, given that EER conversion will typically lead to a normalized set of relations?
What do you understand by domain constraint?
Describe how the following components of an E-R diagram are transformed into relations:a. regular entity typeb. relationship (1:M)c. relationship (M:N)d. relationship (supertype/subtype)e. multivalued attributef. weak entity g. composite attribute
Does normalization place any constraint on storage of data in physical form or on its processing performance?Explain.
List four reasons why an instance of relational schema should be created with sample data.
Fill in the blanks in each of the following statements:a. A relation that has no partial functional dependencies is in normal form.b. A relation that has no transitive dependencies is in normal form.c. A relation that has no multivalued attributes is in normal form.
Demonstrate each of the anomaly types with an example.
Describe three types of anomalies that can arise in a table and the negative consequences of each.
What is a schema? Discuss two common methods of expressing a schema.
List the three components of relational data model.
Describe the primary differences between the conceptual and logical data models.
Contrast the following terms:a. normal form; normalizationb. candidate key; primary keyc. partial dependency; transitive dependencyd. composite key; recursive foreign keye. determinant; candidate keyf. foreign key; primary key g. natural primary key; surrogate primary key h. enterprise key;
Define each of the following terms:a. determinantb. functional dependencyc. transitive dependencyd. recursive foreign keye. normalizationf. composite key g. relation h. normal form i. partial functional dependency j. enterprise key k. surrogate primary key
Use normalization to decompose a relation with anomalies into well-structured relations.
Create relational tables that incorporate entity integrity and referential integrity constraints.
Transform an E-R (or EER) diagram into a logically equivalent set of relations.
Briefly describe four problems that may arise when merging relations.
Give a concise definition of each of the following: first normal form, second normal form, and third normal form.
Create a plan for reviewing your deliverables with the appropriate stakeholders. Which stakeholders should you meet with? Would you conduct the reviews separately or together? Who do you think should sign off on your EER model before you move to the next phase of the project?
Use the narratives in Chapters 1, 2, and above to identify the typical outputs (reports and displays) the various stakeholders might want to retrieve from your database.Now, revisit the EER diagram you created in 3-45 to ensure that your model has captured the information necessary to generate the
Document your thought process around what changes you made to the model developed in Chapter 2, 2-60, to accommodate the new information. Pay particular attention to what changes you had to make to the original model to accommodate the need for supertype/subtype relationships that emerged from the
Interview a DB analyst or system administrator in your university or a local company which has adopted a packaged data model. Discuss how they adopted the model.What was the process of customization or mapping involved? Was the process complex? What challenges did they face during customization?
There are other extensions to ER notation than just supertype/subtype relationships. Use the Internet to search for such extensions. One such mentioned in the text is Aggregation. Look for its examples on the Internet. Report your findings stating the extensions, what they are intended for, some
Ask a database administrator or database or system analyst in a local company to show you an EER (or E-R)diagram for one of the organization’s primary databases.Does this organization model have supertype/subtype relationships? If so, what notation is used, and does the CASE tool the company uses
Visit two local small businesses, one in the service sector and one in manufacturing. Interview employees from these organizations to obtain examples of both supertype/subtype relationships and business rules (such as “A customer can return merchandise only with a valid sales slip”). In which
Showing 600 - 700
of 3225
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
Last
Step by Step Answers
Get 50% OFF
Claim Now
