Database Systems Introduction To Databases And Data Warehouses 1st Edition Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov - Solutions

Unlock comprehensive learning with "Database Systems: Introduction to Databases and Data Warehouses" by Nenad Jukic, Susan Vrbsky, and Svetlozar Nestorov. Access online answers key and solutions manual to tackle complex problems effortlessly. Explore detailed solutions PDF, solved problems, and step-by-step answers for all chapters. Benefit from our extensive questions and answers section and test bank to enhance your understanding. Whether you're an instructor seeking a manual or a student relying on a textbook, we've got you covered. Enjoy the convenience of free download and excel in your studies today!

List the functional dependencies in the following table that concerns invoicing (an application Premiere Products is considering adding to its database), subject to the specified conditions. For a given invoice (identified by the InvoiceNum), there will be a single customer. The customer’s
Illustrate the physical-level design process by means of the design shown in Question 7. List the tables, identify the keys, and list the special restrictions that programs must enforce. In Question 7 a. For a department, store its number and name. b. For an advisor, store his or her number and
Is the database design method top-down or bottom-up? How can you modify this method to gain the advantages to both types of design methods?
Describe the different ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, buildings, and phone numbers) and faculty (numbers and names). No office houses more than one faculty member; no faculty member is assigned more than one office.
For each of the following collections of relations, give the assumptions concerning the relationship between students, courses, and faculty members that are implied by the collection. In each relation, only the primary keys are shown.a. Student (StudentNum, CourseNum, FacultyNum)b. Student
Describe the relationship between columns that can be null and entity subtypes. Under what circumstances would these columns lead to more than one entity subtype?
How is it possible to merge a collection of relations that is in third normal form into a cumulative design that is in third normal form but not obtain a collection of relations that is in third normal form? Give an example other than the one described in the text.
Describe the entity-relationship model. How are entities, relationships, and attributes represented in this model? What is a composite entity? Describe the approach to diagrams that uses a crow’s foot. Describe how you would represent cardinality in an E-R diagram.
What is the purpose of breaking down the overall design problem into a consideration of individual user views?
The information-level design method presented in this chapter contains steps that must be repeated for each user view. List the steps and briefly describe the kinds of activities that must take place at each step.
Describe the function of each of the following types of keys: primary, alternate, secondary, and foreign.
Suppose a given user view contains information about employees and projects. Suppose further each employee has a unique EmployeeNum and each project has a unique ProjectNum. Explain how you would implement the relationship between employees and projects in each of the following scenarios: a. Many
A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Use your own experience to determine any constraints you need that are not stated in the problem. Represent the answer in DBDL.a. For a department, store
1. Indicate the changes you need to make to the design of the Premiere Products database to support the following situation. A customer is not necessarily represented by a single sales rep but can be represented by several sales reps. When a customer places an order, the sales rep who gets the
1. Design a database for Ray. He is interested in movie DVDs and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce the following reports:a. For each director, list his or her number and name and the year he or she was born. If
1. Design a database to produce the following reports. Do not use any surrogate keys in your design.a. For each marina, list the marina number, name, address, city, state, and zip code.b. For each boat owner, list the owner number, last name, first name, address, city, state, and zip code.c. For
When users update and retrieve data, what tasks does a DBMS perform that are hidden from the users?
How do some DBMSs use timestamping to handle concurrent update?
What is journaling? What two types of images does a DBMS output to its journal?
When does a DBA use forward recovery? What are the forward recovery steps?
When does a DBA use backward recovery? What does the DBMS do to perform backward recovery?
What is encryption? How does encryption relate to security?
What is authentication? Describe three types of authentication.
What are integrity constraints? Describe four different ways to handle integrity constraints. Which approach is the most desirable?
What is replication? What is synchronization?
Describe three utility services that a DBMS should provide.
What is a procedural language? What is a nonprocedural language?
How does a catalog differ from a data dictionary?
Describe a situation that could cause a lost update.
What is a transaction?
Describe two-phase locking.
What is deadlock? How does it occur?
While users were updating the Premiere Products database, one of the transactions was interrupted. You need to explain to management what steps the DBMS will take to correct the database. Using the sample log in Figure 7-11, list and describe the updates that the DBMS will roll back if transaction
Occasionally, users at Premiere Products obtain incorrect results when they run queries that include built-in (aggregate, summary, or statistical) functions. The DBA told management that unrepeatable reads caused the problems. Use books, articles, and/or the Internet to research the unrepeatable
You’ve explained replication to management, and some managers ask you for examples of when replication could be useful to them. Describe two situations, other than the ones given in the text, when replication would be useful to an organization.
The staff of the marketing department at Premiere Products is scheduled to receive some statistical databases, and they need you to explain these databases to them. (A statistical database is a database that is intended to supply only statistical information to users; a census database is an
The DBA at Premiere Products wants you to investigate biometric identification techniques for potential use at the company for computer authentication purposes. Use books, articles, and/or the Internet to research these techniques, then write a report that describes the advantages and disadvantages
1. Many computer magazines and Web sites present comparisons of several DBMSs. Find one such DBMS comparison and compare the functions in this chapter to the listed features and functions in the comparison. Which functions from this chapter are included in the comparison? Which functions are
1. The log shown in Figure 7-19 includes four transactions that completed successfully. For each of the four transactions, list the transaction ID and the table(s) modified. Also, list whether the modification to the table added, changed, or deleted a record.2. Suppose a catastrophe destroys the
What is a DBA? Why is this position necessary?
After a DBMS has been selected, what is the DBA’s role in DBMS maintenance?
What are the DBA’s responsibilities with regard to the data dictionary?
What are the DBA’s database design responsibilities?
What are the DBA’s responsibilities regarding access privileges?
What are the DBA’s responsibilities regarding security?
What are data archives? What purpose do they serve? What is the relationship between a database and its data archives?
Name five categories that you usually find on a DBMS evaluation and selection checklist.
1. The DBA asks for your help in planning the data archive for the following Premiere Products database:Rep (RepNum, LastName, FirstName, Street, City, State,Zip, Commission, Rate)Customer (CustomerNum, CustomerName, Street, City,State, Zip, Balance, CreditLimit, RepNum)Orders (OrderNum, OrderDate,
1. The DBA asks for your help in planning the data archive for the following Henry Books database:Branch (BranchNum, BranchName, BranchLocation)Publisher (PublisherCode, PublisherName, City)Author (AuthorNum, AuthorLast, AuthorFirst)Book (BookCode, Title, PublisherCode, Type, Paperback)Wrote
1. The DBA asks for your help in planning the data archive for the following Alexamara database:Marina (MarinaNum, MarinaName, Address, City, State, Zip)Owner (OwnerNum, LastName, FirstName, Address, City, State, Zip)MarinaSlip (SlipID, MarinaNum, SlipNum, Length,RentalFee, BoatName, BoatType,
What is a distributed database? What is a DDBMS?
What is meant by local deadlock? By global deadlock?
Describe the two-phase commit process. How does it work? Why is it necessary?
Describe three possible approaches to storing data dictionary entries in a distributed system.
What different design decisions do you make to access data rapidly in a centralized database compared to a distributed database?
List and briefly describe the 12 rules against which you can measure DDBMSs.
In a two-tier client/server architecture, what problems occur when you place the business functions on the clients? On the server?
What is a three-tier architecture?
List the advantages of a client/server architecture as compared to a file server.
What are HTTP and TCP/IP?
What are dynamic Web pages? How can you augment HTML to provide the dynamic capability?
How does a homogeneous DDBMS differ from a heterogeneous DDBMS? Which is more complex?
Explain why HTTP is a stateless protocol and what types of techniques are used in e-commerce to deal with this complication.
What is XML? Why was it developed?
What is the purpose of DTDs and XML schemas?
What does XSLT accomplish?
What are the 12 rules against which you can measure OLAP systems?
What is inheritance? What are the benefits to inheritance?
What is location transparency?
What are the 14 rules against which you can measure object-oriented systems?
What is replication? Why is it used? What benefit is derived from using it? What are the biggest potential problems?
What is replication transparency?
What is data fragmentation? What purpose does data fragmentation serve?
What is fragmentation transparency?
Fragment the Customer table so that customers of rep 20 form a fragment named CustomerRep20, customers of rep 35 form a fragment named CustomerRep35, and customers of rep 65 form a fragment named CustomerRep65. (Include all fields from the Customer table in each fragment.) In addition, you need to
Create a class diagram for the Premiere Products database, as shown in Chapter 1, Figure 1-5. If you need to make any assumptions in preparing the diagram, document those assumptions.
A user queries the Part table in the Premiere Products database over the company intranet. Assume the Part table contains 5,000 rows, each row is 1,000 bits long, the access delay is 2.5 seconds, the transmission rate is 50,000 bits per second, and only 20 of the 5,000 rows in the Part table
1. Use computer magazines or the Internet to investigate one of these DBMSs: DB2, SQL Server, MySQL, Oracle, or Sybase. Then prepare a report that explains how that DBMS handles two of the following distributed database functions: deadlock, fragmentation, replication, the data dictionary or log,
1. Use computer magazines, books, or the Internet to investigate one of the following Web services: Application Programming Interface (API); Common Gateway Interface (CGI); Simple Object Access Protocol (SOAP); Universal Description, Discovery, and Integration (UDDI); or Web Services Description
Discuss the effect of the following changes on the design for the Marvel College requirements:a. More than one instructor might teach a given section of a course, and each instructor must be listed on the time schedule.b. Each department offers only a single major.c. Each department offers only a
Briefly describe the process of database implementation.
Briefly describe the process of developing the front end applications.
What are the similarities and differences between the development of the initial and subsequent versions of the database?
What are the main four categories of people involved with database projects?
Give several examples of converting data to information.
Create your own example that shows a collection of data, first without the metadata and then with the metadata.
Describe the relationship between the database and DBMS.
What are the steps in the development of a database system?
Explain the iterative nature of the database requirements collection, definition, and visualization process.
How are exact minimum and maximum cardinalities depicted in a relationship?
Create an example of an entity with several attributes.
Create requirements and the ER diagram for a scenario with two entities (both with several attributes) involved in a relationship with exact minimum and maximum cardinalities.
Create requirements and the ER diagram with several attributes for a scenario with an entity involved in a unary relationship.
Create requirements and the ER diagram for a scenario with two entities (both with several attributes) involved in two separate relationships.
Create requirements and the ER diagram for a scenario with two entities (both with several attributes), one of which is a weak entity and the other its owner entity, involved in an identifying relationship.
Create requirements and the ER diagram for a scenario with two entities (both with several attributes) involved in the following relationship: a. M relationship, where participation on the 1 side is mandatory and participation on the M side is optional. b. M relationship, where participation on the
Create requirements and the ER diagram for a scenario with two entities (both with several attributes) involved in a many-to-many relationship that has a relationship attribute.
Create an example of an entity with a composite attribute.
Create an example of an entity with a composite unique attribute.
Create an example of an entity with candidate keys (multiple unique attributes).

Showing 1000 - 1100 of 3228

First
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Last

Database Systems Introduction To Databases And Data Warehouses 1st Edition Nenad Jukic, Susan Vrbsky, Svetlozar Nestorov - Solutions

Step by Step Answers