Module 2 – Case assignment In this case assignment, you will install Oracle database 11g express edition and SQL developer to your computer, validate your installation, and write a short 3-4 page paper with screenshots of your download. This assignment has three parts: Part 1 To successfully finish this assignment, you will first need to study the required reading materials, follow the installation guide, and read the getting started guide. Oracle database express installation guide (2011). Click here. Oracle database express getting started guide (2011). Click here. Part 2 Download SQL developer at http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html. Make sure you download the zip file that include the JDK1.6.0_11. Part 3 Following this link to learn how to connect to Oracle database using SQL developer. Expectations: Successfully install Oracle database 11g express edition and Oracle SQL developer to your computer Describe your experience with the installation. Open the sample database HR, and make screen shots of the database and copy them into your paper; Open HR database, describe what information you see there, using the terms introduced in this module, such as table, schema and key. Describe the tables in HR database in detail.

Introduction:
In this case assignment, the task is to install Oracle database 11g express edition and SQL developer on your computer, validate the installation, and write a short paper describing the installation process. Additionally, you are required to provide screenshots of the installation steps and the outcome for validation purposes.

Part 1: Installation of Oracle Database 11g Express Edition
To successfully complete this assignment, it is crucial to familiarize yourself with the required reading materials, particularly the Oracle database express installation guide and the Oracle database express getting started guide. These guides provide step-by-step instructions and helpful information on the installation process.

Firstly, you need to download Oracle database 11g express edition from the official Oracle website. Once the installation file is downloaded, follow the installation guide to complete the installation process. The guide will provide detailed instructions on setting up the necessary configurations, such as specifying the installation location, configuring passwords, and setting up the listener.

During the installation, you may encounter various prompts and options that need to be configured appropriately. It is important to carefully read and understand each prompt to ensure the installation process is successful. The installation guide provides explanations for each prompt, which will help you make informed decisions.

After completing the installation, validate the installation by opening the Oracle database and verifying that it is running correctly. Take screenshots of the database interface and include them in your paper for documentation.

Part 2: Installation of SQL Developer
In the second part of this assignment, you will need to download SQL developer, which is a powerful tool for managing an Oracle database. SQL developer can be downloaded from the official Oracle website by accessing the provided link. Make sure to download the zip file that includes the JDK1.6.0_11.

Once the download is complete, follow the instructions to install SQL developer on your computer. The installation process for SQL developer is relatively straightforward, and the provided guide should be able to help you complete the installation without any issues.

Part 3: Connecting to Oracle Database Using SQL Developer
After successfully installing SQL developer, you will need to connect it to the Oracle database you previously installed. This can be done by following the link provided in the assignment instructions, which will guide you through the process of connecting SQL developer to the Oracle database.

As a final step, open the sample database named HR and take screenshots of the database interface. In your paper, describe the information displayed in the HR database using the terminology introduced in this module, such as “table,” “schema,” and “key.” Additionally, provide a detailed description of the tables in the HR database.

Conclusion:
In conclusion, this case assignment requires the installation of Oracle database 11g express edition and SQL developer on your computer. The installation process involves following the instructions provided in the installation guide and the getting started guide. Additionally, screenshots of the installation steps and the outcome should be included in the paper.

Need your ASSIGNMENT done? Use our paper writing service to score better and meet your deadline.


Click Here to Make an Order Click Here to Hire a Writer