Brief description of the server environment

Assignment Help Database Management System
Reference no: EM13843928

You are the Senior Database Administrator of one of the following organizations (Choose one):

Private Prep School

Upper management has decided they want to upgrade their old database software to the latest and greatest Oracle 12c Database! You are delighted, until you find out; it's all on your shoulders. Your task for this course project is to develop an upgrade document that will

provide the following information to your team:

A brief description of the organization.
A brief description of the server environment (how many servers, disk sizes, networks, OS types)
A description of the current database software being utilized by the organization
A brief (very high-level) Entity Relationship Diagram of the database being used.

New Server requirements if any. (memory, disks, numbers of, etc.)

Describe the Oracle Software file structure you wish to use. You may use OFA, or not. But identify where all the files (dbf, ctl, ora, etc.) will go on the servers. If you don't use OFA, then support your decisions.

Define the tablespaces and provide create tablespace statements for the new system.

Ensure you provide backup and recovery schedules for the upgrade

Provide general steps to perform the upgrade. Include a high level flowchart. Do not get too detailed or you will be writing a 100 page document!

Reference no: EM13843928

Questions Cloud

What should she charge per train to maximize her profit : Mary Ann makes and sells toy trains. When she sells them for $7 each she just covers her expenses and have no profit. She knows that if she sells them for $25 each she would sell so few she would also have no profit. What should she charge per train ..
List and explain two data pump options : What are some advantages to using Data Pump instead of import/export? List and explain two Data Pump options that might be used by a non-dba user
Next great creative breakthrough in business : What do you think the next great creative breakthrough in business will be that will rival e-commerce and mobile phones in importance? ( Loads of product planners and business leaders are waiting for your answer).
Compute corresponding objective values of corner point : The Electrocomp Corporation manufactures two electrical products: air conditioner and large fans. The assembly process for each is similar in that both require a certain amount of wiring and drilling. Each air conditioner takes 3 hours of wiring and ..
Brief description of the server environment : A brief description of the organization. A brief description of the server environment (how many servers, disk sizes, networks, OS types). A description of the current database software being utilized by the organization
Discuss the different dynamic storage allocation algorithms : Prepare a presentation where you discuss the different dynamic storage allocation algorithms, First-fit, Best-fit, and Worst-fit. Include the pros and cons of each algorithm?
Analysis of amazons process and assembly procedures : For this assignment each student will conducted an analysis of Amazon's process and assembly procedures. Amazon's initial process and assembly procedures? Based on this what are some of Amazon's sustainable products and/or services? Technological adv..
Find the tension in the string : find the tension in the string
Case study- debriefing report for voip2 biz : Case Study: Debriefing Report for VoIP2.biz, Inc. Read Case Study I-3 entitled "VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier" on pages 128-143 in your textbook, Managing Information Technology

Reviews

Write a Review

Database Management System Questions & Answers

  Develop a database that shall allow eci

Your goal is to develop a database that shall allow ECI to keep track of its business and provide the management with the following information regarding the performance of the business: Complete information about ECI employees, especially salesmen..

  Consider a relation stored as a randomly ordered

Consider a relation stored as a randomly ordered ?le for which the only index is an unclustered index on a ?eld called sal. If you want to retrieve all records with sal > 20, is using the index always the best alternative? Explain.

  Create a database to support the information management

Create a database to support the information management needs of an organization or individual. Explain why a database is a good tool to solve it. Describe what database features will be used and why. d. Provide background on the calculations, form..

  Write about the history of databases

Write a 1-paragraph summary of what you plan to discuss in your paper. Your instructor will read your proposal and either approve it or suggest that you select another topic. If your topic is not approved, you will have 2 calendar days to resubmit..

  Design a flowchart for a program

Design a flowchart for a program that declares an array of 10 characters. Program should count and print number of times a special character, (your choice, let say ‘a') has been found in the array.

  Create a new database and name it orders

Purpose of this hands-on computer exercise is to have you learn how to use Microsoft Access to: create a database table, enter data into the table, create a report based on the data, and print the table and the report.

  Create an er diagram using the set of requirements

Create an ER diagram using the set of requirements provided for Oxford City Council's bicycle sharing scheme and identify the minimal set of functional dependencies and all candidate keys for the relation R

  Calculate canonical cover for set of functional dependencies

Calculate a canonical cover for above set of functional dependencies (show each step of your derivation with an explanation).

  Explain normal form is denormalized table

Which field or fields cause a table to no longer be in third normal form? In which normal form is denormalized table?

  Find the entities from the functional requirements

Find the entities from the functional requirements. Entities can come from Nouns in the text, they may also come from forms, reports and legacy code.

  What kind of a design would you try in this case

Suppose that your database system has very ine?cient implementations of index structures. What kind of a design would you try in this case?

  Oracle datatypes for attributes from a normalized relation

Choose Oracle datatypes for the following attributes from a normalized relation including: Vendor(VendorID, Address, ContactName) Item (ItemID, Description) PriceQuote(VendorID, ItemID, Price) Describe why you selected the datatypes for each attri..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd