Explore BrainMass


Oracle9i Database

The newspaper had added a special deal for the classified ads online. For a small fee, the words "BEST BUY" are added to the text of the ad, and these ads are listed on a special "Best Buy" page online. The online classified section has a query to bring up all the ads that qualify, but it runs very slowly. Here is the query.

Assessing the Oracle9i Database

Recall that you created this table for Global Globe's employees: CREATE TABLE EMPLOYEE (EMPLOYEE_ID NUMBER(10), JOB_TITLE VARCHAR2(45), first_name varchar2(40), Last_name varchar2(40), phone_number Varchar2(20)); Start with this CREATE TABLE command, and modify it to create a new range_partitioned table named CH07EMPLOY

Oracle9i Database

4. Study Figure 5-11, and list all the initialization parameters with the values you can determine from the figure. Write the CREATE DATABASE command for this database. Assume the name of the database is CHAP5. Save the initialization parameters and the CREATE DATABASE command in a file named ho0504.sql.


1. What might cause the loss of one control file? What might cause the loss of all control files? 2. Compare and contrast multiplexing of control files and redo log files. 3. Why should a business have its database in ARCHIVELOG mode?

Create an Access Database

This database file must be saved as a zip file Professional Litigation User Services (PLUS) is a company that creates all types of visual aids for judicial proceedings. Clients are usually private law firms, although the District Attorney's office has occasionally contracted for its services. PLUS creates graphs, maps, timeta

Windows Applications

Your assignment is to organize a charity event. You can be as creative as you want here. Here are conditions of your assignment: 1. You must use at least two programs, one of which must be a Windows program such as Word, WordPad, or Paint. 2. Describe the specifics of the event including date, time, location, charity event, a

Naptster and its legal battles

Do a Web search for stories about Napster and its legal battles at Why has the Recording Industry Association of America (RIAA) filed its lawsuit? How is this different from making a VHS copy of a movie or TV show with your VCR? What legitimate uses of Napster's file sharing abilities can you come up wi

1024-byte packet a 128-byte header and a 4-byte checksum

Suppose a network transmits 1024-byte packets containing a 128-byte header and a 4-byte checksum. If a workstation on the network is guaranteed to be able to transmit at least one packet every x time units, (1) what maximum amount of time, as a function of x, should be required (based on these factors) to transfer a 3MB file

Create a sample spreadsheet that depicts a household budget.

You do not need to put in personal information or actual values if you do not wish, but you must include some data for each of the various categories and income and expense line items. Content and Format Requirements 1. This spreadsheet should be divided into categories such as Income and Expenses. Within each of these cate

Create E-R diagram

(See attached file for full problem description) --- Using the script file below to create an E-R diagram of the entities, attributes and relationship. # use the "my_database" database USE my_database; # create a table called "items" with 3 records CREATE TABLE IF NOT EXISTS items ( id INT PRIMARY KEY, ve

Explain: DTD's in XML

Please discuss the following question: Describe how you would create and declare DTD's in XML.

Using Unix alias to emulate DoS commands

Assume you are an experienced DOS programmer and you want to write UNIX shell scripts using DOS commands. Use the alias command so you can type the follow DOS commands and perform UNIX functions: a. Clear screen (cls) b. Directory (dir) c. print out the contents of a file (type) d. Make a directory (md) e. Change director

Microsoft Excel

13. A new workbook will initially contain only three worksheets; more can be added later if needed. 14. If you inadvertently delete a worksheet, you can restore it by clicking the Undo button 15. You can move and copy worksheets to another workbook only if that workbook is open? 16. If a range of sheets is referenced in a for

Microsoft Excel

True or false questions 1. All functions use a range of cells for the argument. There are no single cell referenced formulas? 2. When Excel calculates averages, blank cells or cells containing text are ignored? 3. The NOW function can be used to display the current date, time, or a combination of the two in several differen

ASP Page

Create an ASP page. Please add comments and attach the documentation for the code.

ASP.NET application

Create an ASP.NET application using Visual Studio .NET 2003. Your application should includfe at least one web form and five different types of controls. Feel free to create more than one instance of the same type. Also, you must change at least two properties of each instance on your form. Make sure to comment your application

Using VBA in Exel Open and Close an .XLS file (and Process)

Attached Word document (Word2000) appears to successfully open and close an Excel file. BUT the Excel process is still there. [The Excel process goes away after I close the Word document] I may not be 'fully closing' Excel...I would not think I would have to execute any 'special code' to close the process, and assume my VBA


1. Since Napster is going out of business, you have decided to start your own on-line music sharing site. You will provide individual music files at your site. Each music file is obtained from a recording company and includes an artist, title, recording date, and length of recording. Customers to your site can obtain recordings

Database & Sequential File Processing

I need to know the best way to answer these questions. I've read the chapters and am clueless to computers. Please provide examples. The book looks like jargon. Thanks. 1. Sequential File Processing: Give a brief definition of sequential file processing. Develop an example to illustrate your definition. (The ex

Enhance the Payments Database

Professional Litigation User Services (PLUS) creates all types of visual aids for judicial proceedings. Raj Jawahir is working with the Payments database to track and analyze the payment history of PLUS clients. He again needs your help. He would like you to enhance the Payments database by completing the following: Make a co

Flowchart help

I have to put this progam Hangman into a form of a flowchart. Any ideas will be greatly helpful. I have MS visio but can figure it out. See attach file for the program.

User Defined Functions: Example Problem

You receive a file that contains female and male student GPA's for certain courses. Due to confidentiality, the letter code f is used for female students and m for male students. Every file entry consists of a letter code followed by a GPA. Each line has one entry. The number of entries in the file is unknown. Write a progra

Files and Streams

People from three different income levels, A, B, and C, rated each of two different products with a number 0 through 10. Construct a file in which each line contains the income level and product rankings for one respondent. Then write a program tht reads this information and calculates the following: a. for each income bracke

JAVA I/O, Write program from scratch

Write a Java program to practice the use of Java file I/O. Class methods are needed to break up solution in smaller parts. Program will read several series of heart rates from a file, compute min, max, & fitness quotient for each series, and output the input data and computed info in an HTML document. The following 3 files are

Access is given.

Database file to keep track of employee information. Please see attachment for questions.