Concepts of Database Management 8th edition Philip J. Pratt, Mary Z. Last - Solutions

The management of Colonial Adventure Tours asks you to research improvements it might make to its database processing. To help management, they would like you to complete the following exercises. You do not use the Colonial Adventure Tours database for any of these exercises.1. Create a class
For the following exercises, you will answer problems and questions from management at TAL Distributors. You do not use the TAL Distributors database for any of these exercises.1. Fragment the Customer table so that customers of rep 15 form a fragment named CustomerRep15, customers of rep 30 form a
Using your knowledge of the college environment, identify three questions to answer using online analytical processing (OLAP) software.
Using your knowledge of the college environment, identify three transactions that might be handled by online transaction processing (OLTP) systems.
What is generalization?
What is multiplicity?
What is a visibility symbol in UML?
What are relationships called in UML?
What is a method? What is a message? How do messages relate to methods?
How do classes relate to objects?
What is a domain?
What is an OODBMS?
What three types of actions do users typically perform when they use OLAP software?
When do you use OLAP?
What is a fact table in a data warehouse?
What does it mean when a data warehouse is nonvolatile?
What are the characteristics of OLTP systems?
What is a three-tier architecture?
What is a fat client? What is a thin client?
What is the difference between a file server and a client/server system?
What additional factors must you consider during the physical-level design of a distributed database?
What additional factors must you consider during the information-level design of a distributed database?
What causes query processing to be more complex in a distributed database?
What are two disadvantages of updating replicated data in a distributed database?
Why is increased efficiency an advantage in a distributed database?
Why is system availability an advantage in a distributed database?
Why is the ability to increase system capacity an advantage in a distributed database?
Why is local control of data an advantage in a distributed database?
What is meant by a local site? by a remote site?
For the following exercises, you do not use the Solmaris Condominium database.1. The DBA asks for your help in planning the data archive for the following Solmaris Condominium database:Location (LocationNum, LocationName, Address, City,State, PostalCode)Owner (OwnerNum, LastName, FirstName,
The management of Colonial Adventure Tours wants you to complete the following exercises. You do not use the Colonial Adventure Tours database for any of these exercises.1. The DBA asks for your help in planning the data archive for the following Colonial Adventure Tours database:Guide (GuideNum,
Answer each of the following questions using the TAL Distributors data shown in Figure 1-5. No computer work is required.1. List the names of all customers that have a credit limit that is less than $10,000.2. List the descriptions of all items in category GME and that are located in storehouse
What is a form?
What is database design?
What is an E-R diagram?
How do you create a one-to-many relationship in a database system?
What is a database?
What is redundancy? What problems are associated with redundancy?
For the following exercises, you do not use the TAL Distributors database.1. The DBA asks for your help in planning the data archive for the following TAL Distributors database:Rep (RepNum, LastName, FirstName, Street,City, State, PostalCode, Commission, Rate)Customer (CustomerNum, CustomerName,
For credit card processing, stock exchanges, and airline reservations, data availability must be continuous. There are many other examples of mission-critical applications. Research the Internet to find four additional mission-critical applications and explain why data availability must be
You are employed as a DBA for a medical practice. You have implemented multiple safeguards to protect patient privacy and conform to HIPAA regulations. What other practical, common-sense measures should you take to ensure that the database system is secure? Identify at least three measures and
What is denormalization?
How can splitting a table improve performance?
What is meant by “tuning a design?”
What is the difference between production and test systems?
Who trains computer users in an organization? What is the DBA’s role in this training?
What is context-sensitive help?
What is a LAN?
What is a shared lock? What is an exclusive lock?
For the following exercises, you will address problems and answer questions from the Solmaris Condominium Group staff. You do not use the Solmaris database for any of these exercises.1. The log shown in Figure 7-19 includes four transactions that completed successfully. For each of the four
The management of Colonial Adventure Tours wants to upgrade its database and wants you to help select a different DBMS. To help management, they would like you to complete the following exercises. You do not use the Colonial Adventure Tours database for any of these exercises.1. Many computer
For the following exercises, you will address problems and answer questions from management at TAL Distributors.You do not use the TAL Distributors database for any of these exercises.1. While users were updating the TAL Distributors database, one of the transactions was interrupted. You need to
Assume that you need to withdraw $100 from your checking account using your bank’s ATM machine. What set of steps does the DBMS need to perform to complete your transaction?
What is privacy? How is privacy related to security?
How do views relate to security?
What are permissions? Explain the relationship between permissions and work groups.
What are authorization rules?
What is security?
What is recovery?
What is locking and what does it accomplish?
What is meant by concurrent update?
Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.1. Design a database to produce the following reports. Do not use any surrogate keys in your design.a. For each guide, list
The following exercises are based on the TAL Distributors database as designed in Example 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
List the changes you would need to make in your answer to Question 7 if you must store the year and the semester in which a student took a course and received a grade.
Suppose in addition to the requirements specified in Question 7, you must store the number of the department in which the student is majoring. Indicate the changes this would cause in the design in the following two situations:a. The student must be assigned an advisor who is in the department in
List the changes you would need to make in your answer to Question 7 if they could have more than one advisor.
Under what circumstances would you not need to break down an overall design into a consideration of individual user views?
Define the term user view as it applies to database design.
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
The following exercises are based on the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. No computer work is required.1. Using the types of entities found in the Colonial Adventure Tours database (trips, guides, customers, and reservations), create an example of a
The requirements shown in Question 11 have changed. The dentist’s office would like to add the date of the patient’s last payment. In which relation (table) would you place this attribute? Why?Data From 11Convert the following table to an equivalent collection of tables that are in third normal
Assume the same scenario as that given in Question 13 but replace CourseNum and Description with Advisor- Num, LastName, and FirstName as shown. Advisor refers to the advisor responsible for the activity. One advisor can be responsible for many activities but each activity has only one
Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a household. Patient (HouseholdNum, HouseholdName, Street, City, State, PostalCode, Balance, PatientNum,
Define first normal form.
Define functional dependence.
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the original Solmaris Condominium Group database so your data will not reflect the changes you made in
The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. (If you use a computer to complete
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL Distributors database so your data will not reflect the changes you made in Chapter 3.) If you have
Toys Galore currently has a credit limit of $7,500. Because Toys Galore has an excellent credit rating, TAL Distributors is increasing the company’s credit limit to $10,000. If you run the SQL query in Question 2b after the credit limit has been increased, would Toys Galore be included in the
You have a table that contains the following fields: Member Last Name, Member First Name, Street, City, State, Postal Code, and Membership Fee. There are 75,000 records in the table. What indexes would you create for the table, and why would you create these indexes?
What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2013?
Write the SQL commands to obtain the following information from the system catalog:a. List every table that you created.b. List every field in the Customer table and its associated data type.c. List every table that contains a field named Item Num.
What is the system catalog? Name three items about which the catalog maintains information.
Write the SQL command to revoke user Stetson’s privilege.
Write the SQL commands to grant the following privileges:a. User Stetson must be able to retrieve data from the Customer table.b. Users Webster and Bremer must be able to add new orders and order lines.
Define a view named Item Order. It consists of the item number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file.a. Using SQL, write the view definition for Item Order.b. Write an SQL query to retrieve the item number, description,
Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are greater than or equal to $10,000.a. Using SQL, write the view definition for TopLevelCust.b. Write an SQL
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a copy of the Solmaris Condominium Group database so you will still have the original data when you
The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in Chapter 2. In each of the following steps, use SQL to obtain the desired results using the data
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL Distributors database so you will still have the original data when you complete Chapter 4.) In
You need to delete the Order Line table from the TAL Distributors database. Will the following command work? Why or why not?
In Example 1, why is the data type for the Postal Code field CHAR and not SMALLINT or INTEGER? Is the length of the field long enough? Why or why not?
How do you save the results of an SQL query as a table?
How do you join tables in SQL?
What is a sub query? When is a sub query executed?
What are the SQL built-in functions? How do you use them in an SQL query?
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a copy of the Solmaris Condominium Group database so you will still have the original data when you
The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important benefits of using a DBMS. In the following exercises, you will use the data in the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. (If you use a computer to
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. In each step, indicate how to use relational algebra to obtain the desired results.1. List the number and name of all reps.2. List all information from the Item table for item FH24.3. List the
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database so you will still have the original data when you complete Chapter 3.) In each step, use QBE to

Showing 400 - 500 of 697

Concepts of Database Management 8th edition Philip J. Pratt, Mary Z. Last - Solutions

Step by Step Answers