Description

Chapter: 3 -Problem: 10 >> How do you join tables in SQL?
Answer Preview: To join tables in SQL, use a SELE…

, Chapter: 4 -Problem: 1 >> 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 these exercises, use a copy of the original Colonial Adventure Tours database so your data will not refle
Answer Preview: The following answers indicate how to perform the specified task in SQL and in Microsoft Access. The process for other database management systems may be different, although it should be similar. Data …

, Chapter: 2 -Problem: 27 >> Describe the purpose of the product process in relational algebra.
Answer Preview: The PRODUCT command (mathematical…

, Chapter: 4 -Problem: 7 >> Write the SQL command to revoke user Stetson’s privilege.
Answer Preview: REVOKE …

, Chapter: 6 -Problem: 19 >> 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.
Answer Preview: If you assume that the student only takes the course once, then you can add the semest…

, Chapter: 6 -Problem: 9 >> 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 which the student is majoring. b. The student’s advisor does not necessarily have to be in the depart
Answer Preview: a. No change is necessa…

, Chapter: 2 -Problem: 21 >> Describe the purpose of the PROJECT command in relational algebra.
Answer Preview: The PROJECT …

, Chapter: 2 -Problem: 2 >> 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 order number, order date, customer number, and customer name for each order. 4. List the order numbe
Answer Preview: 1. PROJECT Rep OVER (RepNum, LastName, FirstName) GIVING Answer 2. SELECT Item WHERE ItemNum = 'FH24…

, Chapter: 3 -Problem: 14 >> How do you save the results of an SQL query as a table?
Answer Preview: Create a query to select the co…

, Chapter: 2 -Problem: 18 >> When do you use a make-table query?
Answer Preview: Use a make-ta…

, Chapter: 7 -Problem: 2 >> 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 transactions, list the transaction ID and the table(s) modified. Also, list whether the modification to the
Answer Preview: 1. Transaction 1 modifies the ServiceRequest (add) table. Transaction 2 modifies the Location (chang…

, Chapter: 3 -Problem: 16 >> You need to delete the Order Line table from the TAL Distributors database. Will the following command work? Why or why not?
Answer Preview: The command will delete all records in the …

, Chapter: 1 -Problem: 1 >> Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-15 through 1-19. No computer work is required. 1. List the last name of each guide that does not live in New Hampshire (NH).2. List the trip name of each trip that has the type Paddling. 3. List the trip name of each trip that has the season Late Spring. 4. List the trip name of each trip that has the
Answer Preview: Data files consist of copies of the TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group databases that are usable in Access 201…

, Chapter: 3 -Problem: 8 >> What is a sub query? When is a sub query executed?
Answer Preview: A sub query is a query …

, Chapter: 2 -Problem: 1 >> 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 complete these exercises, use a copy of the Colonial Adventure Tours database so you will still have the
Answer Preview: The following answers indicate how to perform the specified task in Microsoft Access. The process for other database management systems would be different, although it should be similar. Data files co…

, Chapter: 7 -Problem: 21 >> What is privacy? How is privacy related to security?
Answer Preview: Privacy refers to the right of individuals …

, Chapter: 2 -Problem: 29 >> In the TAL Distributors database shown in Figure 2-1, the Rep table contains four rows and the Customer table contains 12 rows. How many rows would be contained in the Cartesian product of these two tables? Figure 2-1 Transcribed Image Text: Rep RepNum LastName FirstName Street Campos Gradey Tian St
Answer Preview: The Cartesian pr…

, Chapter: 4 -Problem: 2 >> 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 Chapter 3.) If you have access to a DBMS, use the DBMS to perform the tasks and explain the steps you
Answer Preview: The following answers indicate how to perform the specified task in SQL and in Microsoft Access. The process for other database management systems may be different, although it should be similar. Data …

, Chapter: 5 -Problem: 15 >> 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 form. This table contains information about patients of a dentist. Each patient belongs to a household.
Answer Preview: Places the date of the last paymen…

, Chapter: 9 -Problem: 37 >> What is a fact table in a data warehouse?
Answer Preview: A fact table in a d…

, Chapter: 2 -Problem: 24 >> Are there any restrictions on the tables when using the UNION command? If so, what are these restrictions?
Answer Preview: The two tables must be u…

, Chapter: 9 -Problem: 34 >> What are the characteristics of OLTP systems?
Answer Preview: Online transaction processing (OLTP…

, Chapter: 2 -Problem: 26 >> Describe the purpose of the SUBTRACT command in relational algebra.
Answer Preview: The SUBTRACT comman…

, Chapter: 9 -Problem: 11 >> Why is the ability to increase system capacity an advantage in a distributed database?
Answer Preview: In a well-designed distributed database, …

, Chapter: 5 -Problem: 2 >> 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 requests), create an example of a table that is in first normal form but not in second normal form and an
Answer Preview: 1. (Many examples are possible.) 1NF but 2NF: Location (LocationNum, LocationName, (CondoID, SqrFt, …

, Chapter: 1 -Problem: 11 >> How can you get more information from the same amount of data by using a database approach instead of a non-database approach?
Answer Preview: It is possible to get more information from the same amount of data …

, Chapter: 5 -Problem: 5 >> Define first normal form.
Answer Preview: A table is in …

, Chapter: 6 -Problem: 17 >> Design a survey form of your own. Fill it out as it might have been completed during the database design forHenry Books. For any questions you have too little information to answer, make a reasonable guess.
Answer Preview: To prepare Survey form obtaining the required information from the users. The form could be filled b…

, Chapter: 3 -Problem: 2 >> 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 complete Chapter 4.) In each step, use SQL to obtain the desired results. You can use the query featur
Answer Preview: Data files consist of copies of the TAL Distributors, Colonial Adventure Tours, and Solmaris Condomi…

, Chapter: 9 -Problem: 26 >> What is a three-tier architecture?
Answer Preview: In a three-tier architecture, the clients perform …

, Chapter: 5 -Problem: 1 >> Define functional dependence.
Answer Preview: A column (attribute) B is functionall…

, Chapter: 2 -Problem: 15 >> How do you join tables in an Access query?
Answer Preview: Include the field lists from both tables …

, Chapter: 9 -Problem: 1 >> 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 fragment named CustomerRep30, customers of rep 45 form a fragment named Customer- Rep45, and custom
Answer Preview: 1. Using SQL-type statements, you can define the fragments for the Customer and Orders tables as follows: DEFINE FRAGMENT CustomerRep15 AS SELECT Cust…

, Chapter: 6 -Problem: 3 >> Under what circumstances would you not need to break down an overall design into a consideration of individual user views?
Answer Preview: If the design problem were e…

, Chapter: 4 -Problem: 18 >> 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 query results? Why or why not?
Answer Preview: Yes, Toys Galore would be included in the query result. The qu…

, Chapter: 8 -Problem: 1 >> 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, LastName, FirstName, Address, City, State, PostalCode, PhoneNum, HireDate) Trip (TripID, TripName, S
Answer Preview: 1. One possible archiving strategy is: Trip table: Do not archive data from this table because it do…

, Chapter: 2 -Problem: 13 >> How do you sort data in an Access query?
Answer Preview: Indicate the approp…

, Chapter: 7 -Problem: 18 >> What are authorization rules?
Answer Preview: Authorization rule…

, Chapter: 1 -Problem: 2 >> Answer each of the following questions using the Solmaris Condominium Group data shown in Figures 1-21 through 1-25. No computer work is required. 1. List the owner number, last name, and first name of every condominium owner. 2. List the condo ID number for each condo that is larger than 1,200 square feet. 3. List the last name, first name, and street address of every owner located in Bowton. 4.
Answer Preview: Data files consist of copies of the TAL Distributors, Colonial Adventure Tours, and Solmaris Condomi…

, Chapter: 2 -Problem: 8 >> How do you include a field in an Access query?
Answer Preview: Include the field i…

, Chapter: 4 -Problem: 1 >> 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 access to a DBMS, use the DBMS to perform the tasks and explain the steps you used in the process. I
Answer Preview: The following answers indicate how to perform the specified task in SQL and in Microsoft Access. The process for other database management systems may be different, although it should be similar. Data …

, Chapter: 4 -Problem: 2 >> 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 query to retrieve the number and name of all customers as well as the difference between their cre
Answer Preview: a. CREATE VIEW TopLevelCust AS SELECT CustomerNum, CustomerName, Stre…

, Chapter: 9 -Problem: 44 >> How do classes relate to objects?
Answer Preview: The term class refers to …

, Chapter: 5 -Problem: 14 >> 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 advisor.Student (StudentNum, StudentName, ActivityNum, ActivityName, AdvisorNum, LastName, FirstName)
Answer Preview: There is a one-to-many relationship between advisors and activities. Dependencies St…

, Chapter: 7 -Problem: 6 >> What is locking and what does it accomplish?
Answer Preview: Locking denies access by othe…

, Chapter: 6 -Problem: 18 >> Using a document at your own school (for example, a class schedule), determine the attributes present in the document. Using your knowledge of the policies at your school, determine the functional dependencies present in the document. Use these dependencies to create a set of tables and columns that you could use to produce the document.
Answer Preview: Considering the above questions, as an example, class attribu…

, Chapter: 2 -Problem: 20 >> Describe the purpose of the SELECT command in relational algebra.
Answer Preview: The SELECT c…

, Chapter: 9 -Problem: 51 >> What is generalization?
Answer Preview: Generalization …

, Chapter: 5 -Problem: 11 >> 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, PatientName, (ServiceCode, Description, Fee, Date))The following dependencies exist in the Patient table:PatientN
Answer Preview: Patient ( PatientNum , HouseholdNum, PatientN…

, Chapter: 2 -Problem: 7 >> What is a primary key? What is the primary key for each table in the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1? Figure 1-15 Transcribed Image Text: GuideNum LastName FirstName Address State PostalCode PhoneNum City HireDate Williamsburg MA 01096 Jaffrey Miles
Answer Preview: The primary key is the column or collection of columns that uniquely identifies …

, Chapter: 9 -Problem: 20 >> What additional factors must you consider during the physical-level design of a distributed database?
Answer Preview: In the physical-level design proce…

, Chapter: 2 -Problem: 2 >> 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 complete Chapter 3.) In each step, use QBE to obtain the desired results. You can use the query featur
Answer Preview: The following answers indicate how to perform the specified task in Microsoft Access. The process for other database management systems would be diffe…

, Chapter: 6 -Problem: 1 >> Define the term user view as it applies to database design.
Answer Preview: A user view is the view of data that is neces…

, Chapter: 4 -Problem: 8 >> What is the system catalog? Name three items about which the catalog maintains information.
Answer Preview: The system catalog is a structure that …

, Chapter: 4 -Problem: 6 >> 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.
Answer Preview: a. GRANT SELECT ON …

, Chapter: 2 -Problem: 10 >> How do you use an AND criterion to combine criteria in an Access query? How do you use an OR criterion to combine criteria?
Answer Preview: To combine criteria with AND, enter th…

, Chapter: 8 -Problem: 9 >> What is context-sensitive help?
Answer Preview: Context-sensitive help means that if …

, Chapter: 2 -Problem: 16 >> When do you use an update query?
Answer Preview: Use an update query …

, Chapter: 8 -Problem: 16 >> What is meant by “tuning a design?”
Answer Preview: Tuning a desig…

, Chapter: 2 -Problem: 9 >> How do you indicate criteria in an Access query?
Answer Preview: Enter the crit…

, Chapter: 9 -Problem: 24 >> What is a fat client? What is a thin client?
Answer Preview: A fat client performs the …

, Chapter: 9 -Problem: 22 >> What is the difference between a file server and a client/server system?
Answer Preview: A file server sends entire f…

, Chapter: 2 -Problem: 22 >> Describe the purpose of the JOIN command in relational algebra.
Answer Preview: The JOIN c…

, Chapter: 8 -Problem: 13 >> Who trains computer users in an organization? What is the DBA’s role in this training?
Answer Preview: The DBA does some of the tra…

, Chapter: 3 -Problem: 1 >> 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 each step, use SQL to obtain the desired results. You can use a DBMS to complete the exercises using a c
Answer Preview: Data files consist of copies of the TAL Distributors, Colonial Adventure Tours, and Solmaris Condomi…

, Chapter: 9 -Problem: 53 >> Use a Web browser to find three examples of static Web pages and three examples of dynamic Web pages, and note the URLs for each page you find. Explain the purpose of each page and why you believe it was created as a static page or a dynamic page. For dynamic pages, what kinds of processing happens on each page?
Answer Preview: Answer: Three example of Static page are given below: 1. http://hellohappy org/beautiful-web-type/ Purpose of the page : The main purpose of this website is to showcase various google fonts which are …

, Chapter: 6 -Problem: 1 >> 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 design of the TAL Distributors database to support the following situation. A customer is not necessar
Answer Preview: 1. Remove the RepNum column from the Customer table. Add a new table: CustomerRep (CustomerNum, RepNum) FK CustomerNumCustomer FK RepNum Rep Change th…

, Chapter: 9 -Problem: 36 >> What does it mean when a data warehouse is nonvolatile?
Answer Preview: Nonvolatile means that the data …

, Chapter: 4 -Problem: 17 >> 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?
Answer Preview: MemberLastName is an obvious choice for a single-field index because you …

, Chapter: 8 -Problem: 8 >> What is a LAN?
Answer Preview: A LAN (local area network) is a …

, Chapter: 8 -Problem: 1 >> 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, Street, City, State, PostalCode, Balance, CreditLimit, RepNum) Orders (OrderNum, OrderDate, Custome
Answer Preview: 1. One possible archiving strategy is: Rep table: Do not archive data from this table because the co…

, Chapter: 2 -Problem: 3 >> What is an un-normalized relation? Is it a relation according to the definition of the word relation?
Answer Preview: An un-normalized relation is a st…

, Chapter: 9 -Problem: 4 >> What is meant by a local site? by a remote site?
Answer Preview: The local site is the site …

, Chapter: 6 -Problem: 1 >> 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 guide number, guide last name, guide first name, address, city, state, postal code, telephone n
Answer Preview: 1. Guide (GuideNum, LastName, FirstName, Address, C)ity, State, PostalCode, PhoneNum, HireDate) Trip …

, Chapter: 9 -Problem: 54 >> Using your knowledge of the college environment, identify three transactions that might be handled by online transaction processing (OLTP) systems.
Answer Preview: Examples of OLTP syste…

, Chapter: 5 -Problem: 1 >> 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 table that is in first normal form but not in second normal form and an example of a table that is
Answer Preview: 1. Here is one possible solution: 1NF but not 2NF: TripGuides (TripID, GuideNum, TripName,) Conversi…

, Chapter: 1 -Problem: 23 >> An attribute is a characteristic or property of an entity. If person is an entity, would the same attributes be used to describe a person in different databases that store medical, student, and fitness club data? Why or why not?
Answer Preview: The only attributes that would be the same would be contact a…

, Chapter: 1 -Problem: 6 >> How do you create a one-to-many relationship in a database system?
Answer Preview: In a database system…

, Chapter: 7 -Problem: 1 >> 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 explain to management what steps the DBMS will take to correct the database. Using the sample log sho
Answer Preview: 1. In transaction 2, the DBMS started it at 8:01, added an Orders table record at 8:02, added an Ord…

, Chapter: 9 -Problem: 48 >> What are relationships called in UML?
Answer Preview: Relationships …

, Chapter: 7 -Problem: 15 >> What is security?
Answer Preview: Security is the pre…

, Chapter: 8 -Problem: 2 >> 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, Address, City, State, PostalCode) CondoUnit (CondoID, LocationNum, UnitNum, SqrFt, Bdrms, Baths, CondoFe
Answer Preview: 1. One possible archiving strategy is: Location table: Do not archive data from this table because i…

, Chapter: 2 -Problem: 5 >> Describe the shorthand representation of the structure of a relational database. Illustrate this technique by representing the database for Colonial Adventure Tours shown in Figures 1-15 through 1-19 in Chapter 1. Figure 1-15 Transcribed Image Text: GuideNum LastName FirstName Address State PostalCo
Answer Preview: In the shorthand representation, each table is listed, and afte…

, Chapter: 1 -Problem: 1 >> 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 number 3. 3. List the order numbers for orders placed by customer number 586 on October 15, 2015. 4. Li
Answer Preview: Data and solution files are available at www cengage com. Data files consist of copies of the TAL Di…

, Chapter: 5 -Problem: 2 >> Give an example of a column A and a column B such that B is functionally dependent on A. Give an example of a column C and a column D such that D is not functionally dependent on C.
Answer Preview: Let suppose, there is a table Tutor, Tutor ID Tutor Name Tutor Address Tutor Qualification T…

, Chapter: 8 -Problem: 17 >> How can splitting a table improve performance?
Answer Preview: If users access only certain fields in …

, Chapter: 1 -Problem: 5 >> What is a database?
Answer Preview: A database is a structure that c…

, Chapter: 4 -Problem: 16 >> What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2013?
Answer Preview: A trigger is an action that occurs automaticall…

, Chapter: 1 -Problem: 12 >> What is meant by the sharing of data?
Answer Preview: Sharing of data means t…

, Chapter: 7 -Problem: 19 >> What are permissions? Explain the relationship between permissions and work groups.
Answer Preview: Permissions specify what kind of ac…

, Chapter: 9 -Problem: 15 >> What causes query processing to be more complex in a distributed database?
Answer Preview: Query processing is more complex in …

, Chapter: 9 -Problem: 50 >> What is multiplicity?
Answer Preview: Multiplicity indicates th…

, Chapter: 4 -Problem: 9 >> 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.
Answer Preview: a. SELECT Name FROM Systables WHERE Cre…

, Chapter: 1 -Problem: 10 >> What is a form?
Answer Preview: A form is a scre…

, Chapter: 1 -Problem: 1 >> What is redundancy? What problems are associated with redundancy?
Answer Preview: Redundancy is the duplication of data or t…

, Chapter: 9 -Problem: 1 >> 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 diagram for the Colonial Adventure Tours database, as shown in Figures 1-15 through 1-19 in Chapter 1. If
Answer Preview: 1. The class diagram for the Colonial Adventure Tours database should …

, Chapter: 1 -Problem: 7 >> What is an E-R diagram?
Answer Preview: An E-R diagram represents a database in a visual …

, Chapter: 9 -Problem: 19 >> What additional factors must you consider during the information-level design of a distributed database?
Answer Preview: The information-lev…

, Chapter: 9 -Problem: 14 >> What are two disadvantages of updating replicated data in a distributed database?
Answer Preview: Updating replicated data in a di…

, Chapter: 8 -Problem: 15 >> What is the difference between production and test systems?
Answer Preview: The production system is the hardware…

, Chapter: 9 -Problem: 38 >> When do you use OLAP?
Answer Preview: You use OL…

, Chapter: 3 -Problem: 1 >> 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 shown in Figures 1-15 through 1-19 in Chapter 1. (If you use a computer to complete these exercises, use
Answer Preview: Data files consist of copies of the TAL Distributors, Colonial Adventure Tours, and Solmaris Condominium Group databases that are usable in Access 201…

, Chapter: 2 -Problem: 28 >> Describe the results of the division process in relational algebra.
Answer Preview: When one table is divided by a s…

, Chapter: 2 -Problem: 4 >> How is the term attribute used in the relational model? What is a more common name for attribute?
Answer Preview: In the relational model, an at…

, Chapter: 7 -Problem: 20 >> How do views relate to security?
Answer Preview: If a user is accessing a database th…

, Chapter: 2 -Problem: 11 >> How do you create a computed field in an Access query?
Answer Preview: Type the computation inste…

, Chapter: 2 -Problem: 30 >> In Example 23 on page 58, would you get the same result if you performed the PROJECT command before the JOIN command? Why or why not?
Answer Preview: You cannot use the PROJECT …

, Chapter: 1 -Problem: 9 >> What is database design?
Answer Preview: Database design is …

, Chapter: 9 -Problem: 43 >> What is a domain?
Answer Preview: A domain is t…

, Chapter: 9 -Problem: 42 >> What is an OODBMS?
Answer Preview: An object-oriented DBMS …

, Chapter: 8 -Problem: 20 >> 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 continuous for these applications. Be sure to cite your references.
Answer Preview: One application is nucle…

, Chapter: 9 -Problem: 39 >> What three types of actions do users typically perform when they use OLAP software?
Answer Preview: Using OLAP softw…

, Chapter: 8 -Problem: 18 >> What is denormalization?
Answer Preview: Denormalization is the conversion o…

, Chapter: 9 -Problem: 10 >> Why is local control of data an advantage in a distributed database?
Answer Preview: Local control of data is an advantage …

, Chapter: 9 -Problem: 55 >> Using your knowledge of the college environment, identify three questions to answer using online analytical processing (OLAP) software.
Answer Preview: Examples of OLAP systems include: an…

, Chapter: 9 -Problem: 12 >> Why is system availability an advantage in a distributed database?
Answer Preview: Other users can continue their proce…

, Chapter: 9 -Problem: 45 >> What is a method? What is a message? How do messages relate to methods?
Answer Preview: A method is an action defined fo…

, Chapter: 9 -Problem: 13 >> Why is increased efficiency an advantage in a distributed database?
Answer Preview: Increased efficiency is an advantag…

, Chapter: 1 -Problem: 22 >> If a database is not maintained or if incorrect data is entered into the database, serious problems can occur. What problems could occur if a student database is not maintained?
Answer Preview: Any error to a student transcript/record, such as inc…

, Chapter: 8 -Problem: 19 >> 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 explain the purpose of each one.
Answer Preview: One practical measure is to make sure that the computer …

, Chapter: 9 -Problem: 49 >> What is a visibility symbol in UML?
Answer Preview: A visibility symbol in …

, Chapter: 2 -Problem: 1 >> 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 obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a co
Answer Preview: The following answers indicate how to perform the specified task in Microsoft Access. The process for other database management systems would be different, although it should be similar. Data files co…

, Chapter: 4 -Problem: 3 >> 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, order number, and quoted price for all orders in the Item Order view for items with quoted prices
Answer Preview: a. CREATE VIEW ItemOrder AS SELECT Item ItemNum, Description, Price, OrderNum, OrderDate, Num…

, Chapter: 8 -Problem: 7 >> What is a shared lock? What is an exclusive lock?
Answer Preview: A shared lock permits oth…

, Chapter: 3 -Problem: 15 >> 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?
Answer Preview: The data type for Postal Code is CHAR because the …

, Chapter: 7 -Problem: 27 >> 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?
Answer Preview: DBMS needs to do the following: Accept card number input and check that ca…

, Chapter: 3 -Problem: 7 >> What are the SQL built-in functions? How do you use them in an SQL query?
Answer Preview: Use an SQL built-in function (…

, Chapter: 7 -Problem: 1 >> 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 magazines and Web sites present comparisons of several DBMSs. Find one such DBMS comparison and compare t
Answer Preview: 1. The answer depends on the particular DBMS co…

, Chapter: 6 -Problem: 8 >> List the changes you would need to make in your answer to Question 7 if they could have more than one advisor.
Answer Preview: Instead of the AdvisorNum being incl…

, Chapter: 7 -Problem: 4 >> What is meant by concurrent update?
Answer Preview: Concurrent update o…

, Chapter: 7 -Problem: 11 >> What is recovery?
Answer Preview: Recovery is the process …

, Chapter: 2 -Problem: 25 >> Describe the purpose of the INTERSECT command in relational algebra.
Answer Preview: The INTERSEC…

, Chapter: 2 -Problem: 23 >> Describe the purpose of the UNION command in relational algebra.
Answer Preview: The UNION command …

Additional Information

9 Reviews for Concepts of Database Management Textbook Questions And Answers