Compare the given select queries in terms of the number of hard drive reads.

Here's a query: SELECT orders.order_date, orders.customer_numb FROM orders INNER JOIN order_lines ON orders.order_numb = order_lines.order_numb WHERE order_lines.isbn = '0-131-4966-9'; and here it is rewritten using a subquery: SELECT order_date, customer_numb FROM orders WHE ...continues

Importance of RAM

What is the importance of having enough RAM? How does it relate to how fast a computer can process data from a large database residing on ones hard drive? What is the importance of virtual memory if you don't have too much RAM & how does it relate to query speeds?

Author and tittles

Using the week 2 lecture/homework database, show the author and titles of books that have never sold. Here is the SQL for my question, but what are the author and titles of the books that did not sell? select books.title ,books.author_name from books where books.isbn not in ( select isbn from order_lines where shipped='Y' ...continues

Compare the access speeds of RAM and hard drive.

How much faster it is to access a piece of information out of RAM than it is from hard drive?

Queries

1. It is time again for the company picnic. There is concern that there may be some employees who aren't age 21 yet, so COUNT how many employees we have who aren't yet age 21 as of today, and we'll decide if alcohol will be served or not. * To determine an employee's current age, you'll want to know how many years old t ...continues

What is the difference between ROLAP and MOLAP?

What is the difference between ROLAP and MOLAP? This web site should help: http://www.dmreview.com/article_sub.cfm?articleId=1330

Create at least one stored procedure and a script to use it.

Create at least one stored procedure and a script to use it. Create at least three useful queries. At least one of these queries should use an aggregate function. All scripts should be well documented. Description of the views, stored procedures, and queries Step-by-step instructions on how to run the queries that will d ...continues

DBMS

How many types of DBMS in computer industry since IBM started its first commercial computer equipment?

Systems Analyst

1. As a System Analyst, after you gathered systems requirement, how are you going to analyze these data? Are you starting with business process first or start with data directly? Explain each approach and why or why not? 2. Once the data analysis is complete, how are you going to start with design portion? What kind of tools ...continues

SQL/MS Access Problem

Using Microsoft Sql*server 2000/2005 or MS Access, create and link the tables for the inventory model from the attached inventory systems file.