Creating the Oracle Database

Although Oracle provides a very nice graphical interface tool called Enterprise Manager to aid the DBA in working with the database, it is not always the tool of choice. Many DBAs find it preferable to use command-line execution of scripts and procedures to do administrative work. One such case is in the creation of a new database within the management system. Although the creation of a new database requires the editing of several support files for the database (the listener.ora and tnsnames.ora files in particular), the CREATE DATABASE script is the essential file that would need to be run to accomplish this process. In this lab, you will be responsible for writing a CREATE DATABASE script that would create a new database named LABII, based on a specific set of requirements that will be listed later. The basic configuration for the server the database instance will use is:

Disk Drives: There are three disk drives you will be using: – C:\ - E:\ - F:\

OFA directory paths: The OFA path for each drive that you will use to place the described files in is:

\ORACLE\ORADATA\ORACLE

VERY IMPORTANT – DO NOT ATTEMPT TO RUN YOUR SCRIPT FILE OR TEST IT! Doing so could cause unforeseen problems and that is not the objective of the lab. You will be furnished with a solution later that you can compare your example against.

You are being asked to create the CREATE DATABASE script for a new database instance. The name of the new database should be LABII. Create a script file using Notepad that would create this database:

· The following parameters need to be defined and settings assigned: 

· Maxlogfiles to allow up to 5 groups

· Maxlogmembers to allow up to 4

· Maxdatafiles to allow up to 100

· Maxinstances to allow only 2

· A system datafile should be based on the following guidelines:

· Named SYSTEM01.DBF located on the C: with the directory path noted above.  Have a storage clause set to AUTOEXTEND ON NEXT 10240K and should have a MAXSIZE of UNLIMITED. 

· Have a file size of 100M.

· A system auxiliary datafile should be based on the following guidelines:

· Named SYSAUX01.DBF located on the C: with the directory path noted above.  Have a storage clause set to AUTOEXTEND ON NEXT 10240K and should have a MAXSIZE of UNLIMITED. 

· Have a file size of 100M.

· Two logfile groups should be created based on the following guidelines:

· Each group should have two 4M log files. Log group one will have file REDO01A.LOG located on the C: drive and REDO01B.LOG located on the E: drive. Each drive should use the directory path noted above in the opening scenario/summary section.

· Log group two will have file REDO02A.LOG located on the E: drive and REDO02B.LOG located on the F: drive. Each drive should use the directory path noted above in the opening scenario/summary section.

You can include settings for character sets if you wish; however, since this database resides in an already defined DBMS, the default character sets defined with Oracle was installed would be used. Be sure to include a semicolon at the end of the script to indicate the end of the script. REMEMBER-–you are not required, nor should you try, to execute this script.

University of Phoenix Material

Capital Budgeting Case

Your company is thinking about acquiring another corporation. You have two choices—the cost of each choice is $250,000. You cannot spend more than that, so acquiring both corporations is not an option. The following are your critical data:

Corporation A

Revenues = $100,000 in year one, increasing by 10% each year

Expenses = $20,000 in year one, increasing by 15% each year

Depreciation expense = $5,000 each year

Tax rate = 25%

Discount rate = 10%

Corporation B

Revenues = $150,000 in year one, increasing by 8% each year

Expenses = $60,000 in year one, increasing by 10% each year

Depreciation expense = $10,000 each year

Tax rate = 25%

Discount rate = 11%

Compute and analyze items (a) through (d) using a Microsoft® Excel® spreadsheet. Make sure all calculations can be seen in the background of the applicable spreadsheet cells. In other words, leave an audit trail so others can see how you arrived at your calculations and analysis. Items (a) through (d) should be submitted in Microsoft® Excel®; indicate your recommendation (e) in the Microsoft® Excel® spreadsheet; the paper stated in item (f) should be submitted consistent with APA guidelines.

a. A 5-year projected income statement

b. A 5-year projected cash flow

c. Net present value (NPV)

d. Internal rate of return (IRR)

e. Based on items (a) through (d), which company would you recommend acquiring?

f. Write a paper of no more 1,050 words that defines, analyzes, and interprets the answers to items (c) and (d). Present the rationale behind each item and why it supports your decision stated in item (e). Also, attempt to describe the relationship between NPV and IRR. (Hint. The key factor is the discount rate used.) In addition to the paper, a Micosoft® Excel® spreadsheet showing your projections and calculations must be shown and attached.