Database Concepts 7th edition David M. Kroenke, David J. Auer - Solutions

What is the relationship between 1 MB of storage and 1EB of storage? FIGURE 8-1 Approximate Value for Reference Name Symbol Actual Value Storage Capacity Terms 8 bits (Store one character] Byte 210 = 1,024 bytes About 103 Kilobyte KB 220 = 1,024 KB About 106 Megabyte MB About 109 230 = 1,024 MB
What were the first nonrelational data stores to be developed, and who developed it?
As illustrated in Figure 8-21, what is column family database storage and how are such systems organized? How do column family database storage systems compare to RDMS systems? FIGURE 8-21 Name: LastName A Generalized Column Value: Able Family Database Storage System Timestamp: 40324081235
Explain MapReduce processing. FIGURE 8-22 MapReduce MAP INPUT: DOCUMENT 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
Based on the discussion of the Heather Sweeney Designs operational database (HSD) and dimensional database (HSD-DW) in the text, answer the following questions.A. What transformations of data were made before HSD-DW was loaded with data? List all the transformations, showing the original format of
What is SQL Server 2014 Express?
What is the primary advantage of using SQL Server 2014 Express instead of Microsoft Access?
What is the set of Microsoft programs that are recommended as a necessary set of SQL Server 2014 Express Advanced software products? In what order should you install these products?
What is the purpose of Microsoft SQL Server Management Studio?
How do you create a new database in SQL Server 2014?
How do you specify the active database in SQL Server 2014?
How do you specify the active database in SQL Server 2014?
What tool(s) can be used to create a script?
What is the purpose of the Oracle SQL Developer utility?
What file extension should you use for SQL scripts?
How do you open and run a script in SQL Server?
How do you create and run an SQL query in SQL Server?
How do you create and run an SQL query in SQL Server?
Using SQL Server, run the SQL queries in the “SQL for RelationalQueries” section of Chapter 3. Save each query as follows:
Use Microsoft SQL Server Management Studio to run one or more of the saved SQL queries you created in question A.14:
What is Oracle Database Express Edition 11g Release 2?
What is the primary advantage of using Oracle Database Express Edition 11g Release 2 instead of Microsoft Access?
What are the two Oracle programs that are recommended as a necessary set of Oracle Database Express Edition 11g Release 2 software products? In what order should you install these products?
What is the purpose of the Oracle Database 11g XE Web utility?
How do you create a new database in Oracle Database Express Edition 11g Release 2?
How do you connect to a database in Oracle Database Express Edition 11g Release 2?
What tool(s) can be used to create a script?
What file extension should you use for SQL scripts?
How do you create and run an SQL query in Oracle Database Express Edition?
What is MySQL?
What is the primary advantage of using MySQL instead of SQL Server Express Edition?
What are the three MySQL programs that are recommended as a useful set of MySQL software products?
What are two purposes of the MySQL Workbench?
How do you create a new database in MySQL?
What is a MySQL default schema? How do you specify the default schema?
What is an SQL script? What types of SQL statements and commands can be run more efficiently as scripts?
What tool(s) can be used to create an SQL script?
Code an SQL statement that displays the data in OwnerPhoneView, sorted alphabetically by LastName.
What file extension should you use with MySQL scripts?
How do you create, save,and run an SQL script in MySQL?
How does MySQL use the AUTO_INCREMENT keyword? What limitations are there on the use of the AUTO_INCREMENT keyword?
How do you create and run an SQL query in MySQL?
Code an SQL statement to create a view named OwnerPhoneView that shows OwnerLastName, OwnerFirstName and OwnerPhone.
How are views handled in Microsoft Access?
How do you obtain online help when using the MySQL Workbench? Where is the help information displayed?
What is the purpose of the MySQL Connector/OBDC? How do you install it, and where does it appear after it is installed?
What SQL statements are used to create SQL views?
Use MySQLand the MySQL Workbench to run one or more of the saved SQL queries you created in question C.24:
The MySQL Workbench creates “database models.” What is a data model? What is a database design? Which does MySQL Workbench create?
How do you create a database model in MySQL Workbench?
How do you create a new E-R diagram in the MySQL Workbench?
How do you create a table in an E-R diagram?
How do you create a 1:N non-identifying relationship in an E-R diagram?
How does the MySQL Workbench handle N:M relationships?
If you haven’t already done so, download and install MySQL 5.6 Community Server Edition and the MySQL Workbench. Use the default settings for each installation. When you are asked for a password for the Root user account,create one.
What is a statement of work (SOW)? What purpose does it serve?
What is a user requirements document (URD)? What purpose does it serve?
What is a use case? How well does Microsoft Visio 2010 support modeling use cases?
Define project scope.
What is business process modeling notation (BPMN)? How well does Microsoft Visio 2010 support BPMN?
Describe the systems development life cycle (SDLC) model.
What is systems analysis and design?
What is business process modeling?
Describe how information systems include processes.
How do information systems support business processes?
Describe Michael Porter’s support activities.
Describe Michael Porter’s primary activities.
What is a decision?
What is data?
What is information?
What is a computer-based information system? Describe the five components of a computer-based information system.
What is a competitive strategy?
Create a copy of the WPC-Data-Model.vsd file, and name it WPC-Data-Model-with-ASSIGNMENT.vsd. Modify the data model to include the ASSIGNMENT as shown in the SQL statements in Figure G-8.
The data model for Heather Sweeney Designs is shown in Figure 4-20(c). In Microsoft Visio 2013, create a new Database Model Diagram drawing named HSD-Data-Model. Recreate the data model shown in Figure 4-20(c)in this drawing. CUSTOMER CustomerID LastName SEMINAR SeminarID SeminarDate FirstName
Why is the material in this appendix important?
What utility is used to manage IIS?
What utility is used to manage ODBC?
How do you add a program icon to the Windows 8 Taskbar?
How is the file system that supports IIS structured?
Briefly describe how to view a Web page that has been created in the IIS Web server.
What are Windows security permissions?
Briefly describe how to manage Windows security permissions.
Briefly describe how to install the JDK.
What is the NetBeansIDE?
What is the Java Software Development Kit (JDK)? Why is it needed for the NetBeans IDE?
Develop a graph database based on the WPC EMPLOYEE and PROJECT tables. Data form the ASSIGNMENT table should appear as edge properties
What is the purpose of PHP dynamic extension *.dll files?
What are the Microsoft Drivers for PHP for SQL Server?
Using the Microsoft Drivers for PHP for SQL Server as an example, briefly describe how to install and enable additional PHP dynamic extension *.dll files to an existing PHP installation.
What are the three sources of data for BI systems?
What is an ETL system, and what functions does it perform?
What problems in operational data create the need to clean data before loading the data into a data warehouse?
What does it mean to transform data? Give an example other than the ones used in this book.
Explain the difference between a data warehouse and a data mart. Give an example other than the ones used in this book.
In RFM analysis, what do the letters RFM stand for?
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}
Name and describe the purpose of the major components of a reporting system.
What are the major functions of a reporting system?
Summarize the types of reports described in this chapter.
Describe the various media used to deliver reports.

Showing 200 - 300 of 697

Database Concepts 7th edition David M. Kroenke, David J. Auer - Solutions

Step by Step Answers