Explore BrainMass


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

Differences between ROLAP and MOLAP

Please help with the following problem. What is the difference between ROLAP and MOLAP? This web site should help:

Questions 1-7 answers provided need SQL's for each.

With the file attached please answer in SQL form the following. Thanks... 1. Which employees (by name) have degrees? (the "answer" is Smith, Johnson and Williams) SELECT at least the employee first and last names - SELECT other columns you think would be meaningful. HINT: do a JOIN between the employees and degrees t

SQL Database Columns

If you have TABLE A with these columns (I put the data type in parenthesis, they are not actually part of the table name): LAST_NAME(TEXT), FIRST_NAME(TEXT), MIDDLE_NAME(TEXT), DATE_OF_BIRTH(DATE), and TABLE B with these columns: LAST_NAME(TEXT), FIRST_NAME(TEXT), MIDDLE_NAME(TEXT), DATE_O

Database Coding

1. Using the order_lines table from the database from lecture 2, write the SQL that will give the Min and Max values of the column "cost_each" 2. Using the week 2 homework database, show each customer number and count the instances of each customer_numb in the table orders. Hint: follow this pattern (where the words TAB

SQL Server Database for Kudler Fine Foods/Service

Create the following two tables using the following fields: Note: Supply the appropriate SQL Server data types when creating the tables. In the Employee table, create an Employee ID field that will generate a unique number for each employee and designate the field as the Primary Key. In the Job Title table, you will need to

Running a Query

Why wont this query run and how would you write it correctly? Major hint: try and run the query (use the database attached to Week 2's lecture) ... you'll get an error message that should explain: SELECT isbn FROM books INNER JOIN order_lines ON books.isbn = order_lines.isbn;


(Note: cut and paste the SQL answers for questions 1 and 2 into a word document. 1. Write the SELECT FROM WHERE code that will select the row from the authors table in the attached WEEK1_Q1_Q2_ACCESS2000 database that has "twain, mark" NOTE: You can use: SELECT *

Queries in Access

I notice when writing queries that Access will add in a semicolon at the end of my query. Its just one of those Access things right? We don't have to remember to write the semicolon, as Access adds it in for us correct. The only time this is significant to know is in a situation like this - in a UNION query We may end up cu

SQL 2005 stored procedures, sub query and join general question.

1. Stored procedures in SQL 2005 can be written in a variety of languages. Why is this important in the development of database systems? Provide an example of a stored procedure that a database designer might write to demonstrate why this capability is important. Please include references. 2. Which is better to use, a sub

Oracle Deletion of Fields

Question: Does this statement still hold true? Does Oracle not allow the deletion of fields and if so, how do you handle this? If so why? Seems like not having this ability would make modifications of a database more challenging. Also... the same question, "For example, some systems, including Oracle, do not allow you to red

Cyber security for the typical Windows XP system

This question is for a job interview. A paper must be written that addresses cyber security for the typical Windows XP system to include the most significant current vulnerabilities in windows systems and measures that can be taken by the desktop support people.

data manipulation capabilities

What are the data manipulation capabilities found in SQL Server 2005? Examine the broad range of data manipulation features and provide a summary.

SQL Statements To Run In SQl Server

Write SQL queries using Between, Like and Union: ? Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (Use salary to restrict the data.) ? Write a SQL query that joins two tables in the example database and uses BETWEEN to restrict record selection. (U

SQL Replication

This project will challenge you to set up replication on your SQL Server installation. Every step to complete this process is not laid out for you here. Complete the steps and document your choices throughout the process with screen shots and explanations. 1.Begin by enabling your SQL Server 2000 installation for replication

Database security and setup

Describe steps necessary to setup SQL Server security. Define what the database roles are and set them up for a database with import and export permissions. Please provide atleast two screen shots of important steps.


The objective of this assignment to is create multiple backups of databases and then to restore the databases from the backups you've created. It is essential that you take screen shots and give explanations of the steps performed for each the steps, so that your instructor can see the process and choices you've made along th

SQL- Row Function

Some data are calculated as functions. When would you store data in database and when would you use functions? What is the advantage of storing data in database?

SQL Server 2000 Database Administration

Discuss your thoughts on the effects of indexes, data types, filegroups, and transaction logs on space considerations. Which of those database constructs do you feel are most important to manage when it comes to database size considerations? Why? What factors would you focus on when determining the actual size of these database

SQL Server 2000 DBA for an e-commerce project

Please discuss what you believe to be a good backup and crisis management strategy considering the following scenario. Provide a detailed explanation of your choices. You work for a small consulting firm with a sterling reputation for high-quality work and outstanding technical aptitude. You've been assigned as the SQL Serv

corrections to code.

The other objective is to create a table called balance that includes the customer ID, last name, first name, and the customer's total balance (the sum of price for all orders). Study the tables below: customer and order CUSTOMER CUSTOMER_ID LAST FIRST STREET CITY STATE ZIP ----------- ------- ------- --------- ------- ---

Database comparison

I want to research about Oracle and answer the following questions in elaborated way. Also I want to compare Oracle to MS SQL and MS Access and answer the questions elaborated way that are in part (II) bellow. The document should be written in research paper format. I Oracle Corporation A. Major products 1. Product 1


I am seeking help with solving several SQL statements. I am specifically looking for the code that goes with these problems. **First Problem** Employee table contains the following information: state, lastname, firstname, hiredate, department, salary. Get all employees that satisfy the following conditions: - fr

SQL statement Codes

I am seeking help with solving several SQL statements. I am specifically looking for the code that goes with these problems. **First Problem** Table: Employee (for problems #1 and #2) EmpID Dept Salary HireDate SupervisorID 1001 Finance 10,000 11/1/98 1020 1002 Finance 15,000 12/12/96 1020 1020 Finance 30,000 2/9/96


Using the database and tables from attached document, write queries using the SQL SELECT statement. (Note: Select all of the data from both of your tables before you perform the following) 1. Choose a job_title_code: Increase all employees' salaries that have: job_title_code by 10%. SELECT * from Job_title,Employees;