New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
computer sciences
databases
Database Systems Design Implementation And Management 11th Edition Carlos Coronel, Steven Morris - Solutions
What are some general guidelines for creating and using indexes?
Most query optimization techniques are designed to make the optimizer’s work easier. What factors should you keep in mind if you intend to write conditional expressions in SQL code?
What recommendations would you make for managing the data files in a DBMS with many tables and indexes?
What does RAID stand for, and what are some commonly used RAID levels?
What indexes should you create? Write the required SQL commands.
Should you create an index on EMP_DOB? Why or why not?
Should you create an index on P_CODE? If so, write the SQL command to create that index. If not, explain your reasoning.
Should you create an index? If so, what would the index column(s) be, and why should you create that index?
What type of I/O database operations would be most likely to be used to execute that query?
How should you rewrite the query to ensure that it uses the index you created in your solution to Problem 25?
What indexes you would recommend? Write the commands to create those indexes.
Using Table 11.4 as an example, create two alternative access plans. Use the following assumptions: a. There are 8,000 employees.b. There are 4,150 female employees.c. There are 370 employees in area code 615.d. There are 190 female employees in area code 615.
What type of database I/O operations will likely be used by the query?
What type of database I/O operations will likely be used by the query? Discuss.
What indexes should you create and why? Write the SQL command to create the indexes.
Using Table as an example, create two alternative access plans.
What index would you recommend, and what command would you use?
Use the recommendations given in Section 11.5.2 to rewrite the query to produce the required results more efficiently.
Assuming that you generate 15,000 invoices per month, what recommendation would you give the designer about the use of derived attributes?
What indexes would you recommend for the query you wrote in Problem 30, and what SQL commands would you use?
Discuss the possible data request scenarios in a distributed database environment, single request accessing a single remote database.Figure D12.1 Single Request to Single RemoteDBMS
Multiple requests accessing multiple remote databases, Figure D12.3 Multiple requests, Multiple RemoteDBMSes
Multiple requests accessing any combination of multiple remote DBMSes, Figure Multiple Requests and any Combination of RemoteDatabases
Describe the different types of database requests and transactions.
What is the objective of the query optimization functions?
What trade-offs are involved in building highly distributed data environments?
How does a BASE system differ from a traditional distributed database system?
Briefly describe the process of writing a file in a Hadoop Distributed File System (HDFS).
Define the term heartbeat in an HDFS and explain its purpose.
Multiple requests accessing a single remote database, figure Multiple Requests to a Single RemoteDBMS
To which transparency feature are the query optimization functions related?
What are the two basic styles of data replication?
What issues should be considered when resolving data requests in a distributed environment?
Given the scenario and the requirements in Problem 2, answer the following questions:a. What recommendations will you make regarding the type and characteristics of the required database system?b. What type of data fragmentation is needed for each table?c. What must be the criteria used to
What is business intelligence? Give some recent examples of BI usage, using the Internet for assistance. What BI benefits have companies found?
Describe the BI framework. Illustrate the evolution of BI.
Explain how the main components of the BI architecture interact to form a system. Describe the evolution of BI information dissemination formats.
What are the most relevant differences between operational and decision support data?
What is a data warehouse, and what are its main characteristics? How does it differ from a data mart?
Give three examples of likely problems when operational data are integrated into the data warehouse.
Prepare a high-level summary of the main requirements for evaluating DBMS products for data warehousing.
Your data warehousing project group is debating whether to create a prototype of a data warehouse before its implementation. The project group members are especially concerned about the need to acquire some data warehousing skills before implementing the enterprise-wide data warehouse. What would
Suppose you are selling the data warehouse idea to your users. How would you define multidimensional data analysis for them? How would you explain its advantages to them?
The data warehousing project group has invited you to provide an OLAP overview. The group’s members are particularly concerned about the OLAP client/server architecture requirements and how OLAP will fit the existing environment. Your job is to explain to them the main OLAP client/server
The project group is ready to make a final decision between ROLAP and MOLAP. What should be the basis for this decision? Why?
The data warehouse project is in the design phase. Explain to your fellow designers how you would use a star schema in the design.
Briefly discuss OLAP architectural styles with and without data marts.
Explain the use of facts, dimensions, and attributes in the star schema.
Explain multidimensional cubes, and describe how the slice and dice technique fits into this model.
In the star schema context, what are attribute hierarchies and aggregation levels and what is their purpose?
Discuss the most common performance improvement techniques used in star schemas.
What is data analytics? Briefly explain explanatory and predictive analytics.
Describe and contrast the focus of data mining and predictive analytics. Give some examples.
How does data mining work? Discuss the different phases in the data mining process.
Describe the characteristics of predictive analytics. What is the impact of Big Data (social media) in predictive analytics?
What are decision support systems, and what role do they play in the business environment?
One of your vendors recommends using an MDBMS. How would you explain this recommendation to your project leader?
What is OLAP, and what are its main characteristics?
Explain ROLAP, and list the reasons you would recommend its use in the relational database environment.
The university computer lab's director keeps track of the lab usage, as measured by the number of students using the lab. This particular function is very important for budgeting purposes. The computer lab director assigns you the task of developing a data warehouse in which to keep track of the
Victoria Ephanor manages a small product distribution company. Because the business is growing fast, Ephanor recognizes that it is time to manage the vast information pool to help guide the accelerating growth. Ephanor, who is familiar with spreadsheet software, currently employs a sales force of
David Suker, the inventory manager for a marketing research company, wants to study the use of supplies within the different company departments. Suker has heard that his friend, Ephanor, has developed a spreadsheet-based data warehouse model that she uses in her analysis of sales data. Suker is
ROBCOR, Inc., whose sample data are contained in the database named Ch13_P4.mdb, provides "on demand" aviation charters using a mix of different aircraft and aircraft types. Because ROBCOR has grown rapidly, its owner has hired you to be its first database manager. The company's database, developed
What is the SQL command to list the total sales by customer and by product, with subtotals by customer and a grand total for all product sales?
What is the SQL command to list the total sales by customer, month and product, with subtotals by customer and by month and a grand total for all product sales?
What is the SQL command to list the total sales by region and customer, with subtotals by region and a grand total for all sales?
What is the SQL command to list the total sales by month and product category, with subtotals by month and a grand total for all sales?
What is the SQL command to list the number of product sales (number of rows) and total sales by month, with subtotals by month and a grand total for all sales?
What is the SQL command to list the number of product sales (number of rows) and total sales by month and product category with subtotals by month and product category and a grand total for all sales?
What is the SQL command to list the number of product sales (number of rows) and total sales by month, product category and product, with subtotals by month and product category and a grand total for all sales?
Using the answer to Problem 10 as your base, what command would you need to generate the same output but with subtotals in all columns?
Describe the following: TCP/IP, Router, HTML, HTTP, and URL.
Describe the client/server model for application processing.
Give some example of database connectivity options and what they are used for.
What are ODBC, DAO, and RDO? How are they related?
What steps are required to create an ODBC data source name?
Explain the OLE-DB model based on its two types of objects
What is OLE-DB used for, and how does it differ from ODBC?
How does ADO complement OLE-DB?
What is ADO.NET, and what two new features make it important for application development?
What is a DataSet, and why is it considered to be disconnected?
What are Web server interfaces used for? Give some examples.
Search the Internet for Web application servers. Choose one and prepare a short presentation for your class.
What does this statement mean: The Web is a stateless system? What implications does a stateless system have for database applications developers?
What is a Web application server, and how does it work from a database perspective?
What is XML, and why is it important?
What are XML schema definition (XSD) documents and what do they do?
What is a JDBC, and what is it used for?
What are document type definition (DTD) documents and what do they do?
What is cloud computing, and why is it a “game changer”?
Name and contrast the types of cloud computing implementation.
Define SQL data services and list their advantages.
What is the difference between DAO and RDO?
What are the three basic components of the ODBC architecture?
What are scripts, and what is their function? (Think in terms of database applications development!)
Name and describe the most prevalent characteristics of cloud computing services.
Using the Internet, search for providers of cloud services. Then, classify the types of services they provide (SaaS, PaaS, and IaaS).
Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the AGENTs.
Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve all of the CUSTOMERs.
Use MS Excel to connect to the Ch02_InsureCo MS Access database using ODBC, and retrieve the customers whose AGENT_CODE is equal to 503.
Showing 800 - 900
of 3228
First
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
Last
Step by Step Answers
Get 50% OFF
Claim Now
.png)
.png)
.png)
.png)
