Description

Chapter: 8 -Problem: 10 >> Write a correlated subquery to determine whether the data support the supposition in question 8.4.
Answer Preview: SELECT AlAdvisorName AlAdvisorPhone …

, Chapter: 3 -Problem: 43 >> In general, how can you transform a relation not in BCNF into ones that are in BCNF?
Answer Preview: There are two methods The first method is the stepbystep approach A relation in 1NF is modified into …

, Chapter: 9 -Problem: 17 >> What is deadlock? How can it be avoided? How can it be resolved once it occurs?
Answer Preview: Deadlock occurs when User1 locks a resource needed by User2 and User2 locks a resourc…

, Chapter: 3 -Problem: 31 >> What is a normal form?
Answer Preview: A normal form is one category i…

, Chapter: 12 -Problem: 6 >> Describe three reasons why direct reading of operational data is not feasible for BI applications.
Answer Preview: (1) BI queries can substantially burden the operational DBMS and slow …

, Chapter: 8 -Problem: 43 >> Explain how to transform a 1:N relationship into an N:M relationship.
Answer Preview: 1 Create the intersection table Foreign key constraints can be done …

, Chapter: 3 -Problem: 16 >> If A ? (B, C), then can we also say that A ? B?
Answer Preview: Yes A d…

, Chapter: 12 -Problem: 20 >> What is a dimension table? What type of data is stored in dimension tables?
Answer Preview: A dimension table is used to record valu…

, Chapter: 8 -Problem: 17 >> Why is it important to analyze the database before implementing database redesign tasks? What can happen if this is not done?
Answer Preview: You must analyze the database because you must know the impact of any changes you may make Y…

, Chapter: 9 -Problem: 28 >> Explain the serializable isolation level. Give an example of its use.
Answer Preview: Serializable isolation level will not allow …

, Chapter: 10 -Problem: 28 >> Write SQL INSERT statements to populate the SLIDE_SHOW table using the data shown in Figure 10B-99. Run the SQL statements to populate the SLIDE_SHOW table.
Answer Preview: INSERT INTO SLIDE SHOW VALUES (seqSID nextval, 'My Dog Spot', 'My dog Spot likes to chase things', '…

, Chapter: 8 -Problem: 49 >> Suppose that tables T1 and T2 have a 1:N relationship, with T2 as the child. Show the SQL statements necessary to remove table T1. Make your own assumptions about the names of keys and foreign keys.
Answer Preview: 1 Drop the foreign key cons…

, Chapter: 9 -Problem: 47 >> Define rollback and rollforward.
Answer Preview: In a rollback we undo changes made by erroneous or partially processed transactions by und…

, Chapter: 12 -Problem: 43 >> Explain the meaning of the term object persistence.
Answer Preview: Object persiste…

, Chapter: 8 -Problem: 32 >> Describe the process for dropping primary key C1 and making the new primary key C2.
Answer Preview: 1 Drop any foreign key constraints that reference …

, Chapter: 3 -Problem: 30 >> The term domestic key is not used. If it were used, however, what do you think it would mean?
Answer Preview: The primary …

, Chapter: 12 -Problem: 17 >> What is a star schema?
Answer Preview: A star schema is a database design that uses a denormalized design to store historical data. It is …

, Chapter: 8 -Problem: 8 >> Explain how the query in your answer to Review Question 8.5 differs from the query in your answer to Review Question 8.7.
Answer Preview: First the subquery …

, Chapter: 9 -Problem: 38 >> Explain the relationships among USER, GROUP, PERMISSION, and OBJECT for a generic database security system.
Answer Preview: A USER can be assigned to one or more GROUPs also called …

, Chapter: 5 -Problem: 22 >> Explain how the notations shown in Figure 5-9 differ.
Answer Preview: The notations in Figure 5-9 sho…

, Chapter: 7 -Problem: 80 >> Explain the paradigm mismatch between SQL and programming languages.
Answer Preview: SQL is setoriented most …

, Chapter: 9 -Problem: 26 >> Explain the read committed isolation level. Give an example of its use.
Answer Preview: Read committed isolation level allows nonrepeatabl…

, Chapter: 12 -Problem: 47 >> What is an object-relational database?
Answer Preview: An object-relational database is a relational database t…

, Chapter: 4 -Problem: 6 >> Describe two advantages of normalized tables.
Answer Preview: Normalized tables hav…

, Chapter: 11 -Problem: 7 >> What is a single-tier driver?
Answer Preview: A single-tier …

, Chapter: 3 -Problem: 2 >> What is the basic premise of this and the next chapter?
Answer Preview: The basic premise is that w…

, Chapter: 11 -Problem: 19 >> What disadvantage of ODBC does OLE DB overcome?
Answer Preview: With ODBC, a vendor must create an ODBC driver for almost all DBMS features and functions in orde…

, Chapter: 9 -Problem: 54 >> Explain why a data repository is important. What is likely to happen if one is not available?
Answer Preview: A data repository is a key resource for …

, Chapter: 12 -Problem: 46 >> According to this chapter, why were OODBMSs not successful?
Answer Preview: OODBMSs were not successful because by the time …

, Chapter: 4 -Problem: 2 >> When you receive a set of tables, what steps should you take to assess their structure and content?
Answer Preview: 1 Examine the table structure and contents 2 Examine da…

, Chapter: 11 -Problem: 1 >> Describe why the data environment is complicated.
Answer Preview: Internet technology applications need to publish data…

, Chapter: 11 -Problem: 21 >> Give an example of abstraction involving rowset.
Answer Preview: A rowset is an abstraction of a rec…

, Chapter: 12 -Problem: 36 >> Explain one way to partition a database that has three tables: T1, T2, and T3.
Answer Preview: Assume we have three database servers …

, Chapter: 12 -Problem: 29 >> What is the distinguishing characteristic of OLAP reports?
Answer Preview: The distinguishing characterist…

, Chapter: 2 -Problem: 14 >> Explain how Microsoft Access uses SQL.
Answer Preview: Microsoft Access uses SQL but generally hides the SQL from …

, Chapter: 2 -Problem: 13 >> What is the SQL SELECT/FROM/WHERE framework?
Answer Preview: The SQL SELECTFROMWHERE framework is the basis for queries in SQ…

, Chapter: 2 -Problem: 11 >> What does DML stand for? What are DML statements?
Answer Preview: DML stands for data …

, Chapter: 1 -Problem: 45 >> What does the term database migration mean?
Answer Preview: Database migration is a term used to describe the process o…

, Chapter: 2 -Problem: 53 >> Explain why you cannot use a subquery in your answer to question 2.52.
Answer Preview: In a query that contains a subquery only data from fields in the tab…

, Chapter: 12 -Problem: 26 >> Describe, in general terms, how to perform an RFM Analysis.
Answer Preview: To perform an RFM analysis: (1) Sort the customer purchase records (CPRs) on the R basis into …

, Chapter: 1 -Problem: 28 >> What advantage is there in storing metadata in tables?
Answer Preview: The advantage of storing metadata in ta…

, Chapter: 12 -Problem: 28 >> What does OLAP stand for?
Answer Preview: OLAP stan…

, Chapter: 2 -Problem: 7 >> Summarize the background of SQL.
Answer Preview: SQL was developed by IBM in the late 1970s and in 1992 it w…

, Chapter: 11 -Problem: 10 >> Why are conformance levels important?
Answer Preview: Conformance levels allow all vend…

, Chapter: 1 -Problem: 21 >> What is Structured Query Language (SQL), and why is it important?
Answer Preview: Structured Query Language SQL …

, Chapter: 3 -Problem: 3 >> Explain what is wrong with the table in Figure 3-2.
Answer Preview: PRODUCT_BUYER, the table in Figure 3…

, Chapter: 2 -Problem: 37 >> Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand, grouped by WarehouseID. Omit all SKU items that have 3 or more items on hand from the sum, and name the sum TotalItemsOnHandLT3 and display the results in descending order of TotalItemsOnHandLT3.
Answer Preview: For Microsoft SQL Server Oracle Database and MySQL For Microsoft …

, Chapter: 11 -Problem: 23 >> What is the difference between an object class and an object?
Answer Preview: Strictly speaking, the definition of …

, Chapter: 1 -Problem: 24 >> Name three vendors of DBMS products.
Answer Preview: Three vendors of DBMS prod…

, Chapter: 11 -Problem: 17 >> What is the current version of the .NET Framework, and what new features does it include?
Answer Preview: As of the writing of this IM chapter, .NET Framework 4 5 1 i…

, Chapter: 2 -Problem: 54 >> Explain how subqueries and joins differ.
Answer Preview: 1 In a query that contains a subquery only data from fields in the table used in the topleve…

, Chapter: 3 -Problem: 49 >> If a determinant is part of a candidate key, is that good enough for BCNF?
Answer Preview: No the determinant must be in exactly the s…

, Chapter: 10 -Problem: 17 >> Explain how you would change the stored procedure in Figure 10A-58 to connect the customer to all artists who either (a)Were born before 1900 or  (b) Had a null value for Birthdate.
Answer Preview: Delete the code that connects customers to artists …

, Chapter: 1 -Problem: 56 >> Name three early personal computer DBMS products.
Answer Preview: Three early pe…

, Chapter: 9 -Problem: 24 >> What is the purpose of transaction isolation levels?
Answer Preview: The 1992 ANSI SQL standard defines four transaction isolation l…

, Chapter: 7 -Problem: 50 >> Write an ALTER statement to drop the constraint that Phone is an alternate key in EMPLOYEE.
Answer Preview: For all except MySQL For …

, Chapter: 11 -Problem: 3 >> Explain the author’s justification for describing Microsoft standards. Do you agree?
Answer Preview: OLE DB, ADO, and ADO NET were developed and promulgated by Microsof…

, Chapter: 1 -Problem: 19 >> Explain the components in Figure 1-9. Transcribed Image Text: Database Database DBMS Application Users • Create Process Administer
Answer Preview: Figure 19 shows the components in a database syste…

, Chapter: 3 -Problem: 34 >> What relations are in 1NF?
Answer Preview: Any relation is by definition …

, Chapter: 6 -Problem: 26 >> Describe how to represent a multivalued attribute entity relationship. Give an example other than one in this chapter.
Answer Preview: To represent a multivalued attribute we replace the multivalued attribute with a table and replace …

, Chapter: 11 -Problem: 4 >> Name the components of the ODBC standard.
Answer Preview: Application …

, Chapter: 1 -Problem: 30 >> Is Microsoft Access a DBMS? Why or why not?
Answer Preview: It is more appropriate to say …

, Chapter: 9 -Problem: 31 >> What is the advantage of using different types of cursors?
Answer Preview: Because cursors require considerable memory having many cursors open at the …

, Chapter: 7 -Problem: 3 >> Explain the meaning of the following expression: IDENTITY (4000, 5).
Answer Preview: The IDENTITY keyword is used to modify a column name and is used to specify surrogate keys The firs…

, Chapter: 12 -Problem: 42 >> What organizations should consider using a distributed database?
Answer Preview: Replicated, read-only databases present few problems, …

, Chapter: 1 -Problem: 3 >> Read the description of the search process on the Pearson Web site. Using your own computer, find another retailer Web site (other than any of those discussed or mentioned in this chapter), and search for something of interest to you. Write up a description (with screen shots if possible) of your search.
Answer Preview: You can capture a screenshot by using the PrtScn b…

, Chapter: 3 -Problem: 20 >> Under what conditions will a determinant be unique in a relation?
Answer Preview: A determinant will be unique in a relation only if it deter…

, Chapter: 7 -Problem: 42 >> Write a CREATE TABLE statement for the EMPLOYEE table. Email is required and is an alternate key, and the default value of Department is Human Resources. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.
Answer Preview: For SQL Server For Microsoft Access Microsoft Access SQL statements do NOT support 1 Parameters on t…

, Chapter: 12 -Problem: 32 >> What is drill down?
Answer Preview: Drill down is …

, Chapter: 1 -Problem: 49 >> What job functions does a database administrator perform?
Answer Preview: Figure 125 shows the working domains of knowledge workers progra…

, Chapter: 7 -Problem: 23 >> Write and run a set of SQL INSERT statements to populate the CUSTOMER_02 table. Do not use a bulk INSERT command.
Answer Preview: For Microsoft SQL Server and MySQL For Oracle Database Note the use of the Oracle DB nex…

, Chapter: 12 -Problem: 19 >> What is a measure?
Answer Preview: A measure is a quantit…

, Chapter: 1 -Problem: 60 >> What is an open source DBMS product? Which of the five DBMS products that you named in answering Review Question 1.39 is historically an open source DBMS product?
Answer Preview: The source code of open source DBMS products are generally …

, Chapter: 7 -Problem: 38 >> Write an SQL statement to create a view named Customer01DataView based on the CUSTOMER_01 table. In the view, include the values of EmailAddress, LastName as CustomerLastName, and FirstName as CustomerFirstName. Run this statement to create the view, and then test the view by writing and running an appropriate SQL SELECT statement.
Answer Preview: For Microsoft SQL Server Oracle Database XE and …

, Chapter: 12 -Problem: 31 >> Give an example, other than one in this text, of a measure, two dimensions related to your measure, and a cube.
Answer Preview: We will use PropertySales as a measure. Dimensions would be the attributes in a relational databas…

, Chapter: 5 -Problem: 21 >> Explain how the notations shown in Figure 5-7 differ.
Answer Preview: The notations in Figure 5-7 sh…

, Chapter: 12 -Problem: 8 >> What are dirty data? How do dirty data arise?
Answer Preview: Dirty data are problematic data, tha…

, Chapter: 10 -Problem: 25 >> Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW using the column characteristics, as shown in Figure 10B-96. Run the SQL statement to create the SLIDE_SHOW table in the MEDIA database.
Answer Preview: CREATE TABLE SLIDE SHOW ( ShowID ShowName ShowDescription Purpose CONST…

, Chapter: 1 -Problem: 1 >> Describe the historic development of Internet and smartphone technology from the early days of personal computers (PCs) to today’s Internet Web application and smartphone app based information systems environment.
Answer Preview: In the late 70s and early 80s early personal computers became available that i…

, Chapter: 11 -Problem: 85 >> Why do database processing and document processing need each other?
Answer Preview: // Get connection - PHP $DSN = "VRG"; $User = "VRG-User"; $Password = "VRG-User+password"; $Conn …

, Chapter: 1 -Problem: 50 >> What need drove the development of the first database technology?
Answer Preview: The development of the first database technology was driven …

, Chapter: 12 -Problem: 38 >> Explain what must be done when fully replicating a database but allowing only one computer to process updates.
Answer Preview: If only one computer accepts updates, the copies of the updates must …

, Chapter: 1 -Problem: 59 >> What characteristic of HTTP was a problem for some database processing applications?
Answer Preview: HTTP is a stateless protocol which means that …

, Chapter: 12 -Problem: 41 >> Explain what problems can occur in a distributed database that is partitioned but not replicated.
Answer Preview: If a distributed database is partitioned by not replicated, then …

, Chapter: 10 -Problem: 27 >> How are recoveries performed using MySQL Administrator?
Answer Preview: The MySQL 56 Administrator has a DATA BACKUPRESTORE that is used …

, Chapter: 1 -Problem: 54 >> Name two early relational DBMS products.
Answer Preview: Two early relational DBMS products …

, Chapter: 12 -Problem: 21 >> What is a slowly changing dimension?
Answer Preview: A slowly changin…

, Chapter: 10 -Problem: 25 >> Explain the meaning of each of the transaction isolation levels under Options shown in Figure 10C-82. Transcribed Image Text: ???? Scope Options Transaction isolation level GLOBAL READ UNCOMMITTED SESSION READ COMMITTED TRANSACTION REPEATABLE READ SERIALIZABLE
Answer Preview: The four transaction isolation levels listed in ascending level of restriction are READ UNCOMMITTED …

, Chapter: 1 -Problem: 32 >> What is the function of the application generator in Microsoft Access?
Answer Preview: The function of the ap…

, Chapter: 12 -Problem: 5 >> Explain the difference in processing between reporting and data mining applications.
Answer Preview: Reporting systems summarize the current status of the …

, Chapter: 10 -Problem: 44 >> What is the syntax of the BEGIN TRANSACTION statement in PL/SQL? How is a transaction started?
Answer Preview: In PLSQL there is no BEGIN TRANSA…

, Chapter: 1 -Problem: 31 >> Explain the components in Figure 1-17. Transcribed Image Text: FIGURE 1-17 Microsoft Access Compononte of a Microsoft Access Databasa System Form-Processing Application Data Entry Forms Report-Gonorator Application Reports DBMS Database Users Queries Query-Processing Application The DBMS can be eith
Answer Preview: Figure 117 shows the components in a database system as create…

, Chapter: 11 -Problem: 51 >> Explain the flexibility inherent in the use of the InsertCommand, UpdateCommand, and DeleteCommand properties.
Answer Preview: The one requir…

, Chapter: 10 -Problem: 48 >> Explain why INSTEAD OF triggers are needed for join views.
Answer Preview: They are used because it is impossible to write ge…

, Chapter: 2 -Problem: 15 >> Explain how enterprise-class DBMS products use SQL.
Answer Preview: The Cape Codd Outdoor Sports sale answeion database has been modified to include three additional tables the INVENTORY table the WAREHOUSE table and …

, Chapter: 12 -Problem: 37 >> Explain one way to replicate a database that has three tables: T1, T2, and T3.
Answer Preview: Assume we have three database servers x S1, S2…

, Chapter: 10 -Problem: 59 >> What is the difference between the OnLine ReDo logs and the OffLine or Archive ReDo logs? How is each type used?
Answer Preview: OnLine ReDo files are maintained on disk and contain the rollback segments from recent da…

, Chapter: 10 -Problem: 2 >> In the MySQL Workbench folder structure in your Documents folder, create a folder named DBP-e14-Media-Database in the Schemas folder. Use this folder to save and store *.sql scripts containing the SQL statements that you are asked to create in the remaining Review Questions in this section.
Answer Preview: Use the usual Windows c…

, Chapter: 1 -Problem: 35 >> Why would someone choose to replace the native Microsoft Access DBMS engine with SQL Server?
Answer Preview: We would replace the Microsoft Access …

, Chapter: 11 -Problem: 5 >> What role does the driver manager serve? Who supplies it?
Answer Preview: The driver manager serves as an intermediary between the application and the DBMS drivers. When the …

, Chapter: 10 -Problem: 20 >> Explain how you would use SQL Developer to create an index on the salary field of an employee table. What sorts of queries will benefit from this, and how?
Answer Preview: One approach is to simply type the appropriate SQL Create Index command and execute it in SQL Develo…

, Chapter: 11 -Problem: 72 >> How are comments designated in HMTL code?
Answer Preview: In HTML co…

, Chapter: 1 -Problem: 38 >> How do database applications read and write database data?
Answer Preview: All database applications rea…

, Chapter: 10 -Problem: 26 >> Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics, as shown in Figure 10B-97. SLIDE_SHOW_PICTURE_INT is an intersection table between PICTURE and SLIDE_SHOW, so create appropriate relationships between PICTURE and SLIDE_SHOW_PICTURE_INT and between SLIDE_SHOW and SLIDE_SHOW_PICTURE_INT. Set the referential integrity properties to disall
Answer Preview: CREATE TABLE SLIDE_SHOW_PICTURE_INT ShowID Int Int IntPK Pic…

, Chapter: 5 -Problem: 13 >> What is a binary relationship?
Answer Preview: A relati…

, Chapter: 11 -Problem: 69 >> What is PHP, and what function does it serve?
Answer Preview: PHP which is an abbreviation for PHP Hypertext Process…

, Chapter: 1 -Problem: 2 >> Why do today’s Internet Web applications and smartphone apps need databases?
Answer Preview: Many Web sites and smartphone apps connect to a database usually residing on a …

, Chapter: 12 -Problem: 45 >> What does OODBMS stand for, and what is its purpose?
Answer Preview: OODBMS stands for object-o…

, Chapter: 12 -Problem: 1 >> What are BI systems?
Answer Preview: Business Information BI systems are …

, Chapter: 2 -Problem: 39 >> In your answer to Review Question 2.38, was the WHERE or HAVING applied first? Why?
Answer Preview: The WHERE clause is always applied be…

, Chapter: 12 -Problem: 40 >> What solution is used to prevent the problems in Review Question 12.39?
Answer Preview: If more than one computer can …

, Chapter: 10 -Problem: 2 >> What is the Oracle Universal Installer (OUI), and what is its purpose?
Answer Preview: The OUI is an installation utility that Oracle Corpor…

, Chapter: 2 -Problem: 8 >> What is SQL-92? How does it relate to the SQL statements in this chapter?
Answer Preview: SQL92 is the version of SQL endorsed as a national standard by …

, Chapter: 7 -Problem: 28 >> Are there any significant differences between the sets of SQL INSERT statements used to populate the CUSTOMER_02 table and rows 1-3 of the CUSTOMER_04 table? If so, what are they?
Answer Preview: The data for CUSTOMER02 uses sequential and nonpreexisting surrogate key values for the pr…

, Chapter: 12 -Problem: 14 >> Explain the difference between a data warehouse and a data mart. Use the analogy of a supply chain.
Answer Preview: A data warehouse stores data …

, Chapter: 11 -Problem: 39 >> What is the chief disadvantage of ADO.NET DataSets? When is this likely to be a problem?
Answer Preview: Datasets are disconnected from underlying D…

, Chapter: 1 -Problem: 23 >> What are the functions of the DBMS?
Answer Preview: A DBMS creates p…

, Chapter: 5 -Problem: 53 >> What entity type should come to mind when you see the words “For use by” in a form?
Answer Preview: The words Fo…

, Chapter: 11 -Problem: 8 >> What is a multiple-tier driver?
Answer Preview: A multiple-tier driver processes ODBC calls, …

, Chapter: 11 -Problem: 81 >> In general terms, how are sessions managed by database applications when using HTTP?
Answer Preview: The Web server …

, Chapter: 1 -Problem: 53 >> What were the early objections to the relational model?
Answer Preview: Early objections 1 too theoretica…

, Chapter: 6 -Problem: 27 >> Describe how to represent a archetype/instance entity relationship. Give an example other than one in this chapter.
Answer Preview: To represent a version Archetypeinstance entity relationship we place th…

, Chapter: 11 -Problem: 18 >> Why is OLE DB important?
Answer Preview: OLE DB is one of the foundations of data ac…

, Chapter: 11 -Problem: 34 >> How can ADO.NET be used to process a database without using DataReaders or DataSets?
Answer Preview: ADONET provides a comm…

, Chapter: 1 -Problem: 48 >> What job functions does a database administrator perform? Explain.
Answer Preview: Figure 125 shows the working domains of knowledge workers progra…

, Chapter: 6 -Problem: 5 >> What is a surrogate key? What are its advantages
Answer Preview: A surrogate key is a unique DBMSsupplied identifier used as …

, Chapter: 11 -Problem: 70 >> How is PHP code designated in a Web page?
Answer Preview: PHP sta…

, Chapter: 11 -Problem: 58 >> List the four steps of using a JDBC driver.
Answer Preview: 1 Load the driver 2 Est…

, Chapter: 2 -Problem: 12 >> What does DDL stand for? What are DDL statements?
Answer Preview: DDL stands for data …

, Chapter: 6 -Problem: 47 >> Explain why the enforcement of M-M relationships is particularly difficult.
Answer Preview: The enforcement of MM relationships is particularly difficult because two s…

, Chapter: 11 -Problem: 86 >> How are HTML, SGML, and XML related?
Answer Preview: Database processing needs docum…

, Chapter: 2 -Problem: 16 >> There is an intentional flaw in the design of the INVENTORY table used in these exercises. This flaw was purposely included in the INVENTORY tables so that you can answer some of the following questions using only that table. Compare the SKU and INVENTORY tables, and determine what design flaw is included in INVENTORY. Specifically, why did we include it?
Answer Preview: The flaw is the inclusion of the SKUDescription att…

, Chapter: 6 -Problem: 1 >> Identify the three major tasks for transforming a data model into a database design.
Answer Preview: 1 Replacing entities and attributes with tables a…

, Chapter: 12 -Problem: 23 >> What is a conformed dimension?
Answer Preview: A conformed dimension is a dimensio…

, Chapter: 1 -Problem: 43 >> Describe the general process for designing a database for a new information system.
Answer Preview: To design a database for a new information system System require…

, Chapter: 6 -Problem: 42 >> State which of the actions in Figure 6-29 must be applied for M-O relationships, O-M relationships, and M-M relationships.
Answer Preview: This information is summarized in Figure 631 in the text Cells in …

, Chapter: 12 -Problem: 7 >> Summarize the problems with operational databases that limit their usefulness for BI applications.
Answer Preview: The problems that inhibit the usefulness of oper…

, Chapter: 2 -Problem: 9 >> What features have been added to SQL in versions subsequent to SQL-92?
Answer Preview: Versions of SQL subsequent to SQL92 …

, Chapter: 6 -Problem: 9 >> What does the notation LastName (AK2.2) mean?
Answer Preview: The notation LastNa…

, Chapter: 11 -Problem: 2 >> Explain how ODBC, OLE DB, and ADO are related.
Answer Preview: ODBC was created to address concerns about relational databases and dat…

, Chapter: 1 -Problem: 22 >> What does DBMS stand for?
Answer Preview: DBMS sta…

, Chapter: 4 -Problem: 37 >> Give an example in which the general-purpose remarks column causes difficulties when multiple values are stored in the same column. How is this problem solved?
Answer Preview: Consider the following table from a real estate database PROPERTY PropertyID …

, Chapter: 7 -Problem: 18 >> Write and run an SQL CREATE TABLE statement to create the SALE_02 table. Note that the foreign key is CustomerID, which references CUSTOMER_04.CustomerID. In this database, CUSTOMER_04 and SALE_02 records are never deleted, so that there will be no ON DELETE referential integrity action. However, you will need to decide how to implement the ON UPDATE referential integrity action.
Answer Preview: For Microsoft SQL Server For Oracle Database Oracle crea…

, Chapter: 11 -Problem: 13 >> Explain how the three types of data sources differ.
Answer Preview: 1) A file data source is a file that can be shared among database users. The only requirement is t…

, Chapter: 1 -Problem: 42 >> What is a data warehouse? What is a data mart?
Answer Preview: A data warehouse is a database that uses data ex…

, Chapter: 4 -Problem: 30 >> Describe two ways to identify inconsistent values. Are these techniques certain to find all inconsistent values? What other step can be taken?
Answer Preview: A null value is …

, Chapter: 7 -Problem: 47 >> Write an ALTER statement to add the column AreaCode to EMPLOYEE. Assume that AreaCode is not required.
Answer Preview: For all AL…

, Chapter: 12 -Problem: 35 >> Define distributed database.
Answer Preview: A distributed database is a database that: (1) Has been …

, Chapter: 1 -Problem: 63 >> What is the NoSQL movement? Name two applications that rely on NoSQL databases.
Answer Preview: The NoSQL movement is really a no r…

, Chapter: 5 -Problem: 41 >> Explain why two forms or reports are usually needed to infer maximum cardinality.
Answer Preview: Each form or report only shows the …

, Chapter: 7 -Problem: 30 >> Are there any significant differences between the sets of SQL INSERT statements used to populate the CUSTOMER_02 table and rows 4-6 of the CUSTOMER_04 table? If so, what are they?
Answer Preview: No Because both sets of data use sequ…

, Chapter: 12 -Problem: 25 >> What do the letters RFM stand for in RFM analysis?
Answer Preview: R = Recent when was the customers most …

, Chapter: 1 -Problem: 57 >> What happened to the products in your answer to Review Question 1.56?
Answer Preview: In 1991 Microsoft Acce…

, Chapter: 2 -Problem: 24 >> Write an SQL statement to display the SKU and SKU_Description for products having QuantityOnHand equal to 0.
Answer Preview: SELECT FROM WHERE SKU SKUDescription INVENTORY QuantityOnHand 0 SQLQ…

, Chapter: 7 -Problem: 35 >> Are there any significant differences between the sets of SQL INSERT statements used to populate the SALE_01 table and the SALE_02 table? If so, what are they?
Answer Preview: No Both tables use surrogate data v…

, Chapter: 12 -Problem: 3 >> Name and describe the two main categories of BI systems.
Answer Preview: The two main categories of BI systems are: (1) Repo…

, Chapter: 10 -Problem: 49 >> Explain a limitation on the use of AFTER triggers.
Answer Preview: Because of the way that Oracle Database manages conc…

, Chapter: 1 -Problem: 16 >> How do the e-commerce companies use the databases discussed in Review Question 1.15?
Answer Preview: The ecommerce companies Webactivity da…

, Chapter: 2 -Problem: 30 >> Write an SQL statement to display the SKU, SKU_Description, WarehouseID, and QuantityOnHand for all products having a QuantityOnHand greater than 1 and less than 10. Use the BETWEEN keyword.
Answer Preview: SELECT FROM WHERE SKU SKUDescription Warehouse …

, Chapter: 6 -Problem: 44 >> What design decisions must be made to enforce required parents?
Answer Preview: Referential integrity rules must be …

, Chapter: 10 -Problem: 12 >> Show the SQL statement necessary to create a table named T1 with columns C1, C2, and C3. Assume that C1 is a surrogate key. Assume that C2 has character data of maximum length 50 and that C3 contains a date.
Answer Preview: CREATE TABLE …

, Chapter: 10 -Problem: 24 >> Explain why the lack of an INSTEAD OF trigger disallows updating views in MySQL.
Answer Preview: The INSTEAD OF trigger is the only trigger that …

, Chapter: 1 -Problem: 55 >> What are some of the reasons for the success of Oracle Database?
Answer Preview: Oracle is successful because 1 it w…

, Chapter: 5 -Problem: 23 >> What is an ID-dependent entity? Give an example of an ID-dependent entity (other than one presented in this chapter).
Answer Preview: An IDdependent entity is one in which the identifier of one entity includes the ide…

, Chapter: 6 -Problem: 15 >> What is a range constraint? Give an example.
Answer Preview: A range constraint limits the values of a c…

, Chapter: 11 -Problem: 25 >> What is an interface?
Answer Preview: An object interface is a pac…

, Chapter: 4 -Problem: 15 >> Describe three uses for a read-only database.
Answer Preview: Three uses for …

, Chapter: 1 -Problem: 62 >> What is XML? What comment did Bill Gates make regarding XML?
Answer Preview: XML is a variant of HTML designed t…

, Chapter: 5 -Problem: 6 >> Explain the difference between an entity class and an entity instance.
Answer Preview: An entity class is a collection of entities and is described by the s…

, Chapter: 6 -Problem: 48 >> Explain the need for each of the design decisions in Figure 6-34. Transcribed Image Text: Design Decisions to Be Made Design Documentation Relationship Minimum Cardinality • Update cascade or prohibit? • Delete cascade or prohibit? • Policy for obtaining paront on insort of child M-O Referential int
Answer Preview: 1 MO design decisions The MO design decisions are based on a mandatory parent If the primary key is …

, Chapter: 11 -Problem: 12 >> Summarize the three SQL grammar conformance levels.
Answer Preview: Minimum SQL Grammar CREATE TABLE, DROP TABLE simple SELECT (does not …

, Chapter: 10 -Problem: 22 >> What is the primary factor that influences MySQL locking behavior?
Answer Preview: The transaction is…

, Chapter: 1 -Problem: 11 >> Give an example of information that could be determined using the two tables you provided in your answer to question 1.6.
Answer Preview: In the example above information that could be determined from th…

, Chapter: 4 -Problem: 38 >> Why should one be wary of general-purpose remarks columns?
Answer Preview: We should never use a generalpurpose remarks column in our own designs because we know what kind…

, Chapter: 7 -Problem: 43 >> Write a CREATE TABLE statement for PROJECT table. The default value for MaxHours is 100. Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.
Answer Preview: For SQL Server For Microsoft Access Microsoft Access SQL statements do NOT support 1 Parameters on t…

, Chapter: 11 -Problem: 9 >> Do the uses of the term tier in the three-tier architecture and its use in ODBC have anything to do with each other?
Answer Preview: No, t…

, Chapter: 10 -Problem: 16 >> Explain the problems inherent in using sequences for surrogate key columns.
Answer Preview: Using sequences does not guarantee valid surrogate …

, Chapter: 11 -Problem: 43 >> What is the purpose of the SelectCommand property of a Data Adapter?
Answer Preview: The SelectCommand property is t…

, Chapter: 1 -Problem: 15 >> What is the purpose of the largest databases used by e-commerce companies such as Amazon.com?
Answer Preview: The largest databases …

, Chapter: 2 -Problem: 28 >> Write an SQL statement to display SKU, SKU_Description, and WarehouseID for all products that have a QuantityOnHand equal to 0 or a QuantityOnOrder equal to 0. Sort the results in descending order by WarehouseID and in ascending order by SKU.
Answer Preview: SELECT FROM WHERE OR ORDER BY SKU SKUDescription WarehouseID INVENTORY Quanti…

, Chapter: 6 -Problem: 18 >> What tasks should be accomplished when verifying normalization of a database design?
Answer Preview: When verifying normalization o…

, Chapter: 12 -Problem: 55 >> As illustrated in Figure 12-33, what is column family database storage, and how are column family database storage systems organized? How do structured storage systems compare to RDBMS systems? Transcribed Image Text: Name: LastName Value: Able Timestamp: 40324081235
Answer Preview: (a) A Column (b) A Super Column (c) A Column Family A generalized structured storage system (in this case, a column family database) is shown in Figur…

, Chapter: 10 -Problem: 30 >> Explain the differences between simple, full, and bulk-logged recovery models. Under what conditions would you choose each one?
Answer Preview: In the simple recovery model no database changes are logged Databases must be restored …

, Chapter: 11 -Problem: 77 >> Show a snippet of PHP code for displaying the contents of a RecordSet. Explain the meaning of the code.
Answer Preview: This is actually a combination of HTML and …

, Chapter: 1 -Problem: 34 >> Why does Microsoft Access hide important database technology?
Answer Preview: Microsoft hides important databas…

, Chapter: 4 -Problem: 32 >> How does a null value differ from a blank value?
Answer Preview: A blank value is a …

, Chapter: 7 -Problem: 24 >> Are there any significant differences between the sets of SQL INSERT statements used to populate the CUSTOMER_01 and CUSTOMER_02 tables? If so, what are they?
Answer Preview: Although the SQL code appears identical the SQL INSERT st…

, Chapter: 12 -Problem: 52 >> What is the NoSQL movement? What are the four categories of NoSQL databases used in this book?
Answer Preview: The NoSQL movement is now usually referred to as t…

, Chapter: 4 -Problem: 8 >> If data duplication is only reduced, how can we say that the possibility of data inconsistencies has been eliminated?
Answer Preview: Data inconsistencies are initially eliminated by …

, Chapter: 10 -Problem: 7 >> Write SQL INSERT statements to populate the PICTURE table using the data shown in Figure 10C-101. Run the SQL statements to populate the PICTURE table.
Answer Preview: INSERT INTO PICTURE VALUES 1 SpotAndBall My dog Spot chasing a ball 20150907 spot00001jpg INSERT INTO PICTURE VALUES 2 SpotAndCat My dog Spot chasing …

, Chapter: 1 -Problem: 8 >> Explain how the two tables you provided in Review Question 1.6 are related. Which table contains the foreign key, and what it is the foreign key?
Answer Preview: In the example above the tables MEMBER and PAYMENT are related by the field MemberNumber This …

, Chapter: 5 -Problem: 39 >> Describe two tests for determining if an entity is a strong entity.
Answer Preview: The two tests are 1 Does the …

, Chapter: 6 -Problem: 6 >> When should you use a surrogate key?
Answer Preview: A surrogate key is used …

, Chapter: 10 -Problem: 27 >> Explain the meaning of each of the cursor concurrency settings listed in Figure 10A-72.
Answer Preview: Type Options Transaction isolation level Connection-all transactions READ UNCOMMITTED READ COMMITTED …

, Chapter: 10 -Problem: 63 >> What is media failure, and how does Oracle Database recover from it?
Answer Preview: A media failure occurs when Oracle Database is unable to write …

, Chapter: 10 -Problem: 15 >> Show an SQL statement for querying the row created in question 10B.14.
Answer Preview: SELECT FROM T1 …

, Chapter: 1 -Problem: 58 >> What was the purpose of OODBMS products? Describe two reasons that OODBMS products were not successful.
Answer Preview: The purpose of objectoriented DBMS OODBMS products is to easily store data en…

, Chapter: 5 -Problem: 43 >> Explain why the form and report in Figure 5-19 indicate that the underlying relationship is N:M.
Answer Preview: The form shows that the relationshi…

, Chapter: 6 -Problem: 13 >> Describe three ways that a default value can be assigned.
Answer Preview: Default values can be …

, Chapter: 11 -Problem: 16 >> What is the Microsoft.NET Framework? What basic elements does it include?
Answer Preview: The .NET Framework is Microsofts comprehensive application development platform. Web …

, Chapter: 10 -Problem: 17 >> Show SQL statements for creating a relationship between table T2 and table T3. Assume that T3 has a foreign key column named FK1 that relates to T2 and that deletions in T2 should force deletions in T3.
Answer Preview: ALTER TABLE T3 AD…

, Chapter: 10 -Problem: 13 >> Can the SQL DELETE statement be used with the PopularShowsView view? Why or why not?
Answer Preview: No this view invol…

, Chapter: 2 -Problem: 6 >> Explain, in general terms, the relationships of the RETAIL_ORDER, ORDER_ITEM, and SKU_DATA tables. What is the relationship of these tables to the CATALOG_SKU_2014 and CATALOG_SKU_2015 tables?
Answer Preview: In general each sale in RETAILORDER relates to one or more rows in ORDERITEM that detail the items s…

, Chapter: 5 -Problem: 48 >> How do the forms in Figures 5-26 and 5-28 differ? How does this difference affect the data model?
Answer Preview: The archetypeinstance pattern generally has one entity that is a manifestat…

, Chapter: 5 -Problem: 45 >> Explain how the association pattern differs from the N:M strong entity pattern. What characteristic of the report in Figure 5-21 indicates that an association pattern is needed?
Answer Preview: The association pattern differs from the NM strong entity pat…

, Chapter: 12 -Problem: 27 >> Explain the characteristics of customers that have the following RFM scores: {1 1 5}, {1 5 1}, {5 5 5}, {2 5 5}, {5 1 2}, {1 1 3}.
Answer Preview: RFM SCORE {1, 1,5} {1, 5, 1} {5, 5, 5} {2, 5, 5}, {5, 1, 2} {1, 1, 3} R …

, Chapter: 10 -Problem: 33 >> Can the SQL DELETE statement be used with the PopularShowsView View? Why or why not?
Answer Preview: Yes Since Oracle can determine that a r…

, Chapter: 11 -Problem: 37 >> List the primary structures of an ADO.NET DataSet, as described in this chapter.
Answer Preview: Multiple tables Relationships between tables Foreign keys Referential integrity Referenti…

, Chapter: 2 -Problem: 4 >> What does SKU stand for? What is an SKU?
Answer Preview: SKU stands for stock ke…

, Chapter: 4 -Problem: 34 >> Show SQL for determining the number of null values in the column EmployeeFirstName of the table EMPLOYEE.
Answer Preview: The solution to review question 434 is contained in the Microsoft Access database DBPe1…

, Chapter: 7 -Problem: 44 >> Write a CREATE TABLE statement for the ASSIGNMENT table. Cascade only deletions from PROJECT to ASSIGNMENT; do not cascade either deletions or updates from EMPLOYEE to ASSIGNMENT.
Answer Preview: For SQL Server and MySQL For Microsoft Access Microsoft Access SQL statements do NOT support 1 Param…

, Chapter: 12 -Problem: 18 >> What is a fact table? What type of data is stored in fact tables?
Answer Preview: A fact table is a table in a dimensional databa…

, Chapter: 10 -Problem: 23 >> Create a connection named Media-Database in SQL Developer, and use it to connect to the MEDIA database. Open a new tabbed SQL Worksheet window, and save it as MEDIA-CH10B-RQ-Solutions.sql in the DBPe14-Media-Database folder. Use this script to record and save the SQL statements that you are asked to create in the remaining Review Questions in this section.
Answer Preview: The connection is created as in Figure 10B32 Name the connection MediaDatabase and use the username …

, Chapter: 10 -Problem: 14 >> Under what circumstances can PopularShows be used for inserts and modifications?
Answer Preview: If they involve …

, Chapter: 1 -Problem: 26 >> Why is a database considered to be self-describing?
Answer Preview: A database is considered to be selfdescri…

, Chapter: 5 -Problem: 2 >> In general terms, explain how a data model could be used to design a database for a small video rental store.
Answer Preview: The two steps of designing a database are 1 Creating a data model in which we work out th…

, Chapter: 6 -Problem: 24 >> List four uses for ID-dependent entities.
Answer Preview: IDdependent entities may be used 1 For …

, Chapter: 10 -Problem: 29 >> Write SQL INSERT statements to populate the SLIDE_SHOW table using the data shown in Figure 10B-99. Run the SQL statements to populate the SLIDE_SHOW table.
Answer Preview: INSERT INTO SLIDE SHOW_PICTURE_INT VALUES (1000, 1); INSERT INTO SLIDE SHOW_PICTURE_INT VALUES (1000…

, Chapter: 2 -Problem: 55 >> Write an SQL statement to join WAREHOUSE and INVENTORY and include all rows of WAREHOUSE in your answer, regardless of whether they have any INVENTORY. Run this statement.
Answer Preview: The specify which columns to retrieve we retrieve all colum…

, Chapter: 10 -Problem: 3 >> What is the Oracle Database Configuration Assistant (DBCA), and what is its purpose?
Answer Preview: The DBCA is an Oracle Database to…

, Chapter: 1 -Problem: 46 >> Summarize the various ways that you might work with database technology.
Answer Preview: You might work with database …

, Chapter: 7 -Problem: 48 >> Write an ALTER statement to remove the column AreaCode from EMPLOYEE.
Answer Preview: For all A…

, Chapter: 10 -Problem: 27 >> Write SQL INSERT statements to populate the PICTURE table using the data shown in Figure 10B-98. Run the SQL statements to populate the PICTURE table.
Answer Preview: INSERT INTO PICTURE VALUES (seqPID nextVal, 'SpotAndBall', 'My dog Spot chasing a ball', '07-Sep-15'…

, Chapter: 10 -Problem: 57 >> Explain how Oracle Database processes the read-only transaction isolation level.
Answer Preview: With this isolation level the transaction reads only rows having committed changes with …

, Chapter: 11 -Problem: 75 >> Show a snippet of PHP code for creating a connection to a database. Explain the meaning of the code.
Answer Preview: The PHP code uses the ODBC files source VRG to connect to the database using …

, Chapter: 1 -Problem: 41 >> Explain two ways that a database can be designed from existing data.
Answer Preview: A database can be designed from e…

, Chapter: 6 -Problem: 11 >> Explain why primary keys may never be null, but alternate keys can be null.
Answer Preview: Primary keys can never be null since each row must have a uniqu…

, Chapter: 12 -Problem: 56 >> Explain MapReduce processing. Transcribed Image Text: INPUT: DOCUMENT MAP Computer 01: List individual words and count how many times each word appears Document Section 01 REDUCE Computer: Combine lists of individual words and total counts of how many times each word appears Computer 02: List indivi
Answer Preview: The MapReduce process is used to break a large analytical task into smaller tasks, assign each small…

, Chapter: 10 -Problem: 25 >> Explain what limitation must be enforced for the trigger in Figure 10A-66 to be effective.
Answer Preview: The necessary limitation is …

, Chapter: 10 -Problem: 11 >> Explain the use of User account, Profiles, System privileges, Object privileges, and Roles in Oracle Database security.
Answer Preview: Oracle Database security is built on a security model …

, Chapter: 1 -Problem: 5 >> What is the most commonly used type of database?
Answer Preview: The relationa…

, Chapter: 5 -Problem: 54 >> Give examples of 1:1, 1:N, and N:M recursive relationships (other than those presented in this chapter).
Answer Preview: The words For use by indicate a supertypesubtype entity pattern 11 Recursive To be a member of the N…

, Chapter: 12 -Problem: 11 >> Why are data warehouses necessary?
Answer Preview: Data warehouses are n…

, Chapter: 4 -Problem: 17 >> For read-only databases, how persuasive is the argument that normalization reduces file space?
Answer Preview: Although a readonly database may requ…

, Chapter: 11 -Problem: 32 >> What is a data provider?
Answer Preview: An ADONET data provide…

, Chapter: 1 -Problem: 10 >> Define the terms data and information. Explain how the two terms differ.
Answer Preview: Data are facts and figures Information is defi…

, Chapter: 6 -Problem: 17 >> What is an interrelation constraint? Give an example.
Answer Preview: An interrelation constraint limits the values of a column by a comp…

, Chapter: 7 -Problem: 4 >> If you are using Microsoft SQL Server, Oracle Database, or MySQL, create a folder in your Documents folder to save and store the *.sql scripts containing the SQL statements that you are asked to create in the following Review Questions about the CH07_RQ_TABLES database. • For SQL Server Management Studio, create a folder named CH07-RQ-TABLES-Database in the Projects folder in your SQL Server Manag
Answer Preview: This is self-explanatory. …

, Chapter: 10 -Problem: 40 >> In PL/SQL, what is the purpose of the RETURN keyword?
Answer Preview: The keyword RETURN signifies the end of the …

, Chapter: 11 -Problem: 52 >> What does JDBC stand for?
Answer Preview: JDBC now stands for Java Database Connectivity Accor…

, Chapter: 1 -Problem: 51 >> What are Data Language/I and CODASYL DBTG?
Answer Preview: Data LanguageI DLI was an early method of using hierarc…

, Chapter: 7 -Problem: 12 >> Write and run an SQL CREATE TABLE statement to create the CUSTOMER_04 table.
Answer Preview: For Microsoft SQL Server For Oracle Database XE Oracle creates primary key surrogate values by …

, Chapter: 12 -Problem: 30 >> Define measure, dimension, and cube.
Answer Preview: An OLAP measure is a data item of interest x it is the items that will be …

, Chapter: 10 -Problem: 24 >> Explain why the view CustomerInterestsView in Figure 10A-36 is not updateable. Describe the logic of the INSTEAD OF UPDATE trigger in Figure 10A-66.
Answer Preview: Views created by joins are not normally updateable and the CustomerInterests view shown in Fig…

, Chapter: 11 -Problem: 57 >> Explain how Java accomplishes portability.
Answer Preview: To accomplish portability Java programs are not compiled into a particular machine lang…

, Chapter: 2 -Problem: 1 >> What is an online transaction processing (OLTP) system? What is a business intelligence (BI) system? What is a data warehouse?
Answer Preview: An OLTP system is typically one in which a database is …

, Chapter: 8 -Problem: 24 >> Explain the problems that can occur when changing the name of a table.
Answer Preview: Constraints that define th…

, Chapter: 7 -Problem: 31 >> Write and run a set of SQL INSERT statements to populate the SALE_01 table.
Answer Preview: For Microsoft SQL Server and MySQL 56 MySQL uses differe…

, Chapter: 11 -Problem: 14 >> Which data source type is recommended for Web servers?
Answer Preview: In general, the best choice for Web application…

, Chapter: 2 -Problem: 49 >> Write an SQL statement to show the WarehouseID and average QuantityOnHand of all items stored in a warehouse managed by ‘Lucille Smith’. Use a join, but do not use JOIN ON syntax.
Answer Preview: That the GROUP BY clause is necessary here since wa…

, Chapter: 11 -Problem: 56 >> Define applet and servlet.
Answer Preview: An applet is a Java bytecode program that runs on the ap…

, Chapter: 1 -Problem: 47 >> What job functions does a knowledge worker perform?
Answer Preview: A knowledge worker …

, Chapter: 8 -Problem: 28 >> Under what conditions is the following SQL statement valid?
Answer Preview: The statement is valid when T2 is an existing tab…

, Chapter: 6 -Problem: 43 >> Explain what must be done for the DBMS to enforce required parents.
Answer Preview: For the DBMS to enforce required p…

, Chapter: 12 -Problem: 9 >> What are dirty data? How do dirty data arise?
Answer Preview: Server time is an example of inconsistent data. For example, an on…

, Chapter: 10 -Problem: 23 >> Explain why the strategy for storing CHECK constraint values in a separate table is better than implementing them in a table-based constraint. How can this strategy be used to implement the constraint on ARTIST.Nationality?
Answer Preview: The strategy used in the Trigger in Figure 1021 is to put certain data values i…

, Chapter: 11 -Problem: 59 >> What is the purpose of Java Server Pages?
Answer Preview: Java Server Pages JSP p…

, Chapter: 2 -Problem: 38 >> Write an SQL statement to display the WarehouseID and the sum of QuantityOnHand grouped by WarehouseID. Omit all SKU items that have 3 or more items on hand from the sum, and name the sum TotalItemsOnHandLT3. Show Warehouse ID only for warehouses having fewer than 2 SKUs in their TotalItemsOnHandLT3. Display the results in descending order of TotalItemsOnHandLT3.
Answer Preview: For Microsoft SQL Server Oracle Database and MySQL For Microso…

, Chapter: 5 -Problem: 36 >> Explain two ways forms and reports are used for data modeling.
Answer Preview: Forms and reports ar…

, Chapter: 6 -Problem: 7 >> Describe two disadvantages of surrogate keys.
Answer Preview: First foreign keys that are based on surrogate keys hav…

, Chapter: 11 -Problem: 6 >> What role does the DBMS driver serve? Who supplies it?
Answer Preview: A driver processes ODBC requests and submits s…

, Chapter: 10 -Problem: 1 >> Describe the general characteristics of Oracle Database 12c and the Oracle Database 12c product suite. Explain why these characteristics mean there is considerable complexity to master.
Answer Preview: Oracle Database is a powerful and robust DBMS that runs on many diff…

, Chapter: 11 -Problem: 71 >> How are comments designated in PHP code?
Answer Preview: PHP code segments with two forward slas…

, Chapter: 1 -Problem: 37 >> Name and explain the four categories of database applications that would use an enterprise-class database system.
Answer Preview: The four categories of database applications are ClientServer applications Client so…

, Chapter: 4 -Problem: 28 >> Explain ways in which inconsistent values arise.
Answer Preview: Inconsistent values occur 1 …

, Chapter: 6 -Problem: 49 >> Explain the implications of each of the minimum cardinality specifications in Figure 6-40. Transcribed Image Text: Cardinality MAX MIN Relationship Parent Child Type Nonidentifying 1:N Nonidentifying 1:N Nonidentifying 1:N ARTIST WORK M-O WORK TRANS M-M CUSTOMER TRANS O-O CUSTOMER_ARTIST_INT Identif
Answer Preview: CUSTOMER OO TRANSACTION CUSTOMERs do not require TRANSACTIONs and TRANSACTIONS do not require CUSTOM…

, Chapter: 12 -Problem: 10 >> What is click-stream data? How is it used in BI applications?
Answer Preview: Click-stream data is a recording of every action …

, Chapter: 4 -Problem: 20 >> Summarize the reasons for creating customized duplicated tables.
Answer Preview: Customized duplicate tables are used to create more efficient applications w…

, Chapter: 10 -Problem: 7 >> Write SQL INSERT statements to populate the PICTURE table using the data shown in Figure

Additional Information

11 Reviews for Database Processing Fundamentals, Design, and Implementation Textbook Questions And Answers