Concepts of Database Management 7th edition Philip J. Pratt, Joseph J. Adamski - Solutions

Unlock the full potential of your database studies with our comprehensive solutions for "Concepts of Database Management 7th edition" by Philip J. Pratt and Joseph J. Adamski. Access an extensive range of resources including a detailed answers key and solutions manual, all available online. Dive into step-by-step answers and solved problems to enhance your understanding. Our solutions PDF and instructor manual provide the essential chapter solutions and test bank insights you've been looking for. This textbook, along with its questions and answers, is available for free download, making your study experience seamless and efficient.

Create a System DSN ODBC connection called Ch02_SaleCo using the Administrative Tools section of the Windows Control Panel.
Use MS Excel to list all of the invoice lines for Invoice 1003 using the Ch02_SaleCo System DSN.
Create a System DSN ODBC connection called Ch02_TinyCollege using the Administrative Tools section of the Windows Control Panel.
Use MS Excel to list all classes taught in room KLR200 using the Ch02_TinyCollege System DSN.
Create a sample XML document and DTD for the exchange of customer data.
Create a sample XML document and DTD for the exchange of product and pricing data.
Create a sample XML document and DTD for the exchange of order data.
Explain the difference between data and information. Give some examples of raw data and information.
Define dirty data and identify some of its sources.
What is data quality, and why is it important?
Explain the interactions among end user, data, information, and decision-making. Draw a diagram and explain the interactions.
Suppose that you are a DBA. What data dimensions would you describe to top-level managers to obtain their support for endorsing the data administration function?
How and why did database management systems become the organizational data management standard in organizations? Discuss some of the advantages of the database approach over the file-system approach.
Define security and privacy. How are these two concepts related?
What special considerations must you take into account when introducting a DBMS into an organization?
Describe the DBA's responsibilities.
How can the DBA function be placed within the organization chart? What effect(s) will such placement have on the DBA function?
Why and how are new technological advances in computers and databases changing the DBA's role?
What are the typical activities involved in the maintenance of the DBMS and its utilities and applications? Would you consider application performance tuning to be part of the maintenance activities? Explain your answer.
In Oracle, what is a datafile? How does it differ from a file systems file?
In Oracle, what is a database schema?
How is it possible to get more information from the same amount of data by using a database approach as opposed to a nondatabase approach?
What is a DBA? What kinds of responsibilities does a DBA have in a database environment?
How does consistency result from controlling redundancy?
What is an integrity constraint? When does a database have integrity?
What is security? How does a DBMS provide security?
What is data independence? Why is it desirable?
How is file size a disadvantage in a database environment?
How can the complexity of a DBMS be a disadvantage?
Besides redundancy, what other problems are associated with the nondatabase approach to processing data?
Why can a failure in a database environment be more serious than an error in a nondatabase environment?
Why might recovery of data be more difficult in a database environment?
What is an entity? An attribute?
What is a relationship? A one-to-many relationship?
What is an E-R diagram?
1. List the names of all customers that have a credit limit less than $10,000.2. List the descriptions of all parts in item class AP and located in warehouse number 3.3. List the order numbers for orders placed by customer number 608 on October 23, 2013.4. List the part number, part description,
1. List the name of each publisher that’s not located in New York.2. List the title of each book published by Penguin USA.3. List the title of each book that has the type MYS.4. List the title of each book that has the type SFI and that is in paperback.5. List the title of each book that has the
1. List the owner number, last name, and first name of every boat owner.2. List the names of all boats that are stored in a slip with a length of less than 30 feet.3. List the last name, first name, and street address of every owner located in Glander Bay.4. List the last name, first name, and city
What is a relation?
In which row of the Access design grid do you include functions? What functions can you use in Access queries?
When sorting data on more than one field in an Access query, which field is the major sort key? Which field is the minor sort key? What effect do these keys have on the order in which the rows are displayed?
What is relational algebra?
Describe the shorthand representation of the structure of a relational database. Illustrate this technique by representing the database for Henry Books as shown in Chapter 1.
What does it mean to qualify a field name? How would you qualify the Street field in the Customer table?
What is a primary key? What is the primary key for each table in the Henry Books database shown in Chapter 1?
1. List the number and name of all customers.2. List the complete Part table.3. List the number and name of all customers represented by sales rep 35.4. List the number and name of all customers that are represented by sales rep 35 and that have a credit limit of $10,000.5. List the number and name
1. List the number and name of all sales reps.2. List all information from the Part table for part FD21.3. List the order number, order date, customer number, and customer name for each order.4. List the order number, order date, customer number, and customer name for each order placed by any
1. List the name of each publisher that’s not located in New York.2. List the title of each book published by Penguin USA.3. List the title of each book that has the type MYS.4. List the title of each book that has the type SFI and that is in paperback.5. List the title of each book that has the
1. List the owner number, last name, and first name of every boat owner.2. List the complete Marina table (all rows and all columns).3. List the last name and first name of every owner located in Bowton.4. List the last name and first name of every owner not located in Bowton.5. List the marina
Describe the process of creating a table in SQL and the different data types you can use for fields.
How do you qualify the name of a field in an SQL query? When is it necessary to do so?
How do you take the union of two tables in SQL? What criteria must the tables meet to make a union possible?
Describe the three update commands in SQL.
What is the purpose of the WHERE clause in SQL? Which comparison operators can you use in a WHERE clause?
How do you write a compound condition in an SQL query? When is a compound condition true?
What is a computed field? How can you use one in an SQL query? How do you assign a name to a computed field?
How do you use the LIKE and IN operators in an SQL query?
How do you sort data in SQL? When there is more than one sort key, how do you indicate which one is the major sort key? How do you sort data in descending order?
How do you group data in SQL? When you group data in SQL, are there any restrictions on the items that you can include in the SELECT clause? Explain.
1. List the number and name of all customers.2. List the complete Part table.3. List the number and name of every customer represented by sales rep 35.4. List the number and name of all customers that are represented by sales rep 35 and that have credit limits of $10,000.5. List the number and name
1. List the name of each publisher that’s not located in New York.2. List the title of each book published by Penguin USA.3. List the title of each book that has the type MYS.4. List the title of each book that has the type SFI and that is in paperback.5. List the title of each book that has the
1. List the owner number, last name, and first name of every boat owner.2. List the complete Marina table (all rows and all columns).3. List the last name and first name of every owner located in Bowton.4. List the last name and first name of every owner not located in Bowton.5. List the marina
What is a view? How do you define a view? Does the data described in a view definition ever exist in that form? What happens when a user accesses a database through a view?
Why is it a good idea for the DBMS to update the catalog automatically when a change is made in the database structure? Could users cause problems by updating the catalog themselves? Explain.
What are nulls? Which field cannot accept null values? Why?
State the three integrity rules. Indicate the reasons for enforcing each rule.
The Orders table contains a foreign key, CustomerNum, that must match the primary key of the Customer table. What type of update to the Orders table would violate referential integrity? If deletes do not cascade, what type of update to the Customer table would violate referential integrity? If
How would you use SQL to change a table’s structure? What general types of changes are possible? Which commands are used to implement these changes?
What are stored procedures? What purpose do they serve?
What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2010?
Using data from the Premiere Products 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
Define a view named PartOrder. It consists of the part 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 PartOrder.b. Write an SQL query to retrieve the part number, description,
What is an index? What are the advantages and disadvantages of using indexes? How do you use SQL to create an index?
Describe the GRANT statement and explain how it relates to security. What types of privileges may be granted? How are they revoked?
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 PartNum.
Create the TopLevelCust view described in Review Question 2. Display the data in the view. Review Question 2 Using data from the Premiere Products database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that
Write the code for the following triggers following the style shown in the text.a. When adding a customer, add the customer’s balance times the sales rep’s commission rate to the commission for the corresponding sales rep.b. When updating a customer, add the difference between the new balance
If you are using Access 2010, create the following data macros.a. Create a data macro associated with the After Insert event for the Customer table to implement the trigger in Step 12a. Test the data macro by adding a customer and ensuring that the corresponding sales rep’s commission is updated
Create the PartOrder view described in Review Question 3. Display the data in the view. Review Question 3 Define a view named PartOrder. It consists of the part number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file.
Create a view named OrdTot. It consists of the order number and order total for each order currently on file. (The order total is the sum of the number ordered multiplied by the quoted price on each order line for each order.) Display the data in the view.
Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.a. Create an index named PartIndex1 on the PartNum field in the OrderLine table.b. Create an index named PartIndex2 on the Warehouse field in the Part table.c. Create an index named PartIndex3 on
Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values for the Class field are AP, HW, and SG. Ensure that the PartNum field is the primary key and that the PartNum field in the OrderLine
Add a field named Allocation to the Part table. The allocation is a number representing the number of units of each part that have been allocated to each customer. Set all Allocation values to zero. Calculate the number of units of part number KV29 currently on order. Change the Allocation value
Increase the length of the Warehouse field in the Part table to two characters. Change the warehouse number for warehouse 1 to 1a. Display all the data in the Part table.
1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view.2. Create a view named Paperback. It consists of the book code, book title, publisher name, branch number, copy number, and
1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data in the view.2. Create a view named InitialService using the slip ID, category number, category
If you are using Access 2010, complete the following steps.a. Add the TotalValue field to the Branch table. Create and run a query on the Copy table to determine the appropriate values for this field, and then update the Branch table with these values.b. Create a data macro associated with the
Assume the Branch table contains a column called TotalValue that represents the total price for all books at that branch. Following the style shown in the text, write the code for the following triggers.a. When inserting a row in the Copy table, add the price to the total value for the appropriate
1. Using the types of entities found in the Henry Books database (books, authors, and publishers), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in third normal form. In each case, justify your
1. Using the types of entities found in the Alexamara Marina Group database (marinas, owners, boat slips, categories, and service requests), create an example of a table that is in first normal form but not in second normal form and an example of a table that is in second normal form but not in
Consider a Student table containing StudentNum, StudentName, student’s StudentMajor, student’s AdvisorNum, student’s AdvisorName, student’s AdvisorOfficeNum, student’s AdvisorPhone, student’s NumCredits, and student’s Class (freshman, sophomore, and so on). List the functional
Using your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. Student (StudentNum, StudentName,
Again, using your knowledge of the college environment, determine the functional or multivalued dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in fourth normal form. ActivityNum and
Define primary key.
Define candidate key.
Define second normal form. What types of problems would you find in tables that are not in second normal form?
Define third normal form. What types of problems would you find in tables that are not in third normal form?
Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form?
Define interrelation constraint and give one example of such a constraint. How are interrelation constraints addressed?
Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent collection of tables that are in third normal form. Part (PartNum, Description, OnHand, Class,

Showing 900 - 1000 of 3228

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

Concepts of Database Management 7th edition Philip J. Pratt, Joseph J. Adamski - Solutions

Step by Step Answers