OLAP & Relational Databases

Explain what one can do with an OLAP application that cannot be done with the same data in a spreadsheet or a relational database. Give two examples.

CSCI Excel 2003 Multiple Choice

1. Which of the following enables you to calculate the input value required to yield a desired outcome result? a. Tools, Goal seek b. Insert, Goal seek c. Format, Goal seek d. Tools, Options, Goal seek e. Data, Goal seek Save Answer 2. Which of the following belong in the Goal Seek dialog box? a. By changing cell ...continues

QUERY in MS ACCESS

Please see attached file for three tables in excel format. I need to query three tables by using LAST_NAME and FIRST_NAME in table_1 to find matching ORDER_NUMBER and PP_NUMBER in table_2 and table_3. When you finish. Please send me mdb file. Therefore I can see how you query.

Query in MS Access

Please see attached file and using LAST_NAME and FIRST NAME in Table_1 to find the matching order_number and pp_number in Table_2 and Table_3. The query shoud write in such as (sql) SELECT what columns FROM WHAT tables WHERE somthing or INNER JOIN. The query should run to get the result. When you finish. please attached the mdb ...continues

Excel 2003 Multiple Choice

1. The primary object in a MS Access database for collecting and storing data is a: a. record b. field c. file d. table e. database 2. Each individual entry in a database is stored as a: a. field b. table c. record d. file e. page 3. Records are stored in a database file as a: a. row b. column c. s ...continues

Database Normalization

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to reduce this table to third normal form. Prepare a Word document showing the original and final tables. Include a ...continues

SQL 2005 Scripts

SQL 2005 Using the sample database, write the scripts in a file to create the following views. Include a USES clause at the top of the script file to use the ITD640_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated. 1. Create a view named v_worker showing the ...continues

Excel 2003 Multiple Choice Questions

1. Cell E23 has a date value and you wish to place that date on an invoice prefaced with the text located in B15. What is the command to do that? (This question is from Chapter 6.) a. =B15&E23 b. =proper(B15)&” “&text(E23,”mmmm dd, yyyy”) c. B15&” “&E23 d. =join(B15&E23) e. =proper(B15)&” “&proper(E23) 2. To ...continues

ER Diagram

Develop an ER diagram for the following: A database used in an order-entry system is to contain information about customers, items, and orders. The following information is to be included: • For each customer: Customer number (unique) “Ship-to” addresses (several per customer) Balance Credit Limit Discount • For ea ...continues

SQL 2005

Use SQL Management Studio to create a database called ITD640_P1.MDF. Add the tables and data shown below to the database. Use the appropriate field types and lengths for the tables. See attached file for full problem description.