The Best Essay Writing Service

Get started with the best Essay Writing Service around. Simply send us your essay question, and we’ll locate an expertly qualified writer to create an answer like no other. wycieczka do czarnobyla z kijowa po polsku

What client/server database and distributed database have in common is that in both cases the databases can be located other than “in the computer itself.”

Quiz 2 Instructions Question 1 What client/server database and distributed database have in common is that in both cases the databases can be located other than “in the computer itself.” True False Question 2 In a two-tiered client/server arrangement, data can be found on each PC’s hard drive and data can be in a database at the server. True False Question 3 In the database server approach to client/server database, the actual database processing is done at the server. True False Question 4 One use of the term three-tier approach to client/server database is that data sought from one of the client PCs can be on any one of a succession of three other PCs on the LAN. True False Question 5 When data is distributed in a distributed database arrangement, the database is no longer considered to be a single, logical database. True False Question 6 A distributed database management system manages the distributed data as a single, logical database. True False Question 7 In a network environment, a centralized database provides local autonomy over the data. True False Question 8 Distributed data with no replication provides a high degree of availability. True False Question 9 The two-phase commit process is used for asynchronous updating of replicated data. True False Question 10 In the prepare phase of the two-phase commit process, the updated data is written to a log at each site but not to the database at each site. True False Question 11 Decision support systems are designed to make decisions for managers. True False Question 12 Data warehouse data is characterized as subject oriented. True False Question 13 Data warehouse data is less problematic if denormalized than operational data would be. True False Question 14 Due to the nature of DSS applications, data warehouse data must be up-to-the-moment current. True False Question 15 A data mart is a small-scale data warehouse that is designed to support a small part of an organization, say a department or a related group of departments. True False Question 16 Data warehouses are often referred to as multidimensional databases because each occurrence of the subject is referenced by an occurrence of each of several dimensions or characteristics of the subject. True False Question 17 The star schema approach to multidimensional data design is incompatible with relational database structures. True False Question 18 A star schema has a “fact table,” which represents the data warehouse “subject”. True False Question 19 Data enrichment is the process of copying the data from the transactional databases in preparation for loading it into the data warehouse. True False Question 20 Data cleaning or cleansing or scrubbing refers to fixing errors in data as it is being loaded into the operational database. True False Question 21 All of the following are true about a two-tiered client/server LAN, except ____. a gateway computer can link the LAN to other LANs or to the Internet data can reside on a client PC’s hard drive or at the server searching for data is location transparent a printer on the LAN is available to all of the client PCs data transparency can extend to a mainframe external to the LAN Question 22 Compared to the file server approach, the database server approach to client/server database _____. generates more network data traffic requires more processing power at the server requires a gateway connection to a mainframe computer spreads security control through all of the client PCs requires “fatter” client PCs with more processing power Question 23 Consider a distributed relational database in which there is no data replication. All of the following are true, except ____. all of the table on the network is still available even if one site that has some tables goes down every table can be placed at the site at which it is most heavily used if one site goes down then the data at that site cannot be accessed there or anywhere else on the network the integration of two tables that are not located at the same site will require a distributed join if one site goes down at least some of the database’s tables will still be accessible Question 24 If a distributed database network with data replication has one node that has a copy of every table in the database ____. the problem of data concurrency is eliminated the issue of one site becoming a bottleneck is eliminated the problem of data security is eliminated at least one other copy of each table must also be stored elsewhere on the network the problem of distributed joins is eliminated Question 25 If all went well during the prepare phase of the two-phase commit, then during the commit phase ____. only the site issuing the update request writes the update to its database all of the involved sites write the update to their logs all of the involved sites write the update to their databases all of the sites except the site issuing the update request write the update to their logs all of the sites except the site issuing the update request write the update to their databases Question 26 Of the following applications or application systems, the one that would be considered a decision support system is ____. a system that links companies in a supply chain a hospital application that makes patient records available to all doctors and other health care professionals who are treating patients a university course and grade record keeping system a system that provides the management of a retail chain with data helpful in choosing sites for new stores a payroll system Question 27 Data in a typical data warehouse ____. is frequently updated by changing existing attribute values as the values change in the operational database grows as new data is appended to the end of the existing tables does not require timestamps is always fully detailed, not summarized data is organized according to the company’s TPS applications Question 28 An enterprise data warehouse (EDW) ____. must be the sum of all of a company’s data marts is designed to support a department or a related group of departments cannot exist without data marts being present must be fully normalized supports an entire company or a major part of one Question 29 There is a(n) _____ relationship between each dimension table entity and the fact table entity in a star schema data warehouse structure. standard structured unstructured many-to-many one-to-many Question 30 ____ is a decision support methodology based on viewing data in multiple dimensions. Data mining Market basket analysis Neural networks Online analytic processing Data transformation Question 31 Australian Boomerang, Ltd., wants to design a distributed relational database. The company is headquartered in Perth and has major operations in Sydney, Melbourne, and Darwin. The database involved consists of five tables, labeled A, B, C, D, and E, with the following characteristics: Table A consists of 500,000 records and is heavily used in Perth and Sydney. Table B consists of 100,000 records and is frequently required in all four cities. Table C consists of 800 records and is frequently required in all four cities. Table D consists of 75,000 records. Records 1-30,000 are most frequently used in Sydney. Records 30,001-75,000 are most frequently used in Melbourne. Table E consists of 20,000 records and is used almost exclusively in Perth. Design a distributed relational database for Australian Boomerang. Justify your placement, replication, and partitioning of the tables. (Please answer in complete sentences; do not submit any diagrams. This is a question about the architecture of how the distributed database is set up, balancing costs versus reliability, not how to design the schema.) Question 32 This question is from Chapter 13, question 2(a), page 364. Refer to the database schema on pages 363-364 to use in answering this question. Design a multidimensional database using a star schema for a data warehouse for the Best Airlines, Inc., airplane maintenance environment described by the database schema. The main subject will be maintenance event, starting with the fact table EVENT. Complete the rest of the design, including snowflake tables as appropriate. Use the Dropbox for Quiz 2: Q32 to submit a diagram or a text-based schema representation is also acceptable. Using the ERD design tool in MySQL Workbench, if you have it, is an appropriate tool for this assignment. (Hint: see Fig 13.9, p 350 for an example of a star schema design) Screenshot_2015-11-19_12.51.58 Screenshot_2015-11-19_12.52.06 Screenshot_2015-11-19_12.52.10