Journal

=What I Learned in CS 197=

I've already known database management and SQL since my 165 class. But taking this Oracle Development class has still served me a lot of things, mostly practical stuff. You know, sometimes we could not decide or pick the persons we are gonna work with. Sometimes we have to deal with conditions out of our control and just adapt. Also, for the first time, I learned a bit of web design and html. Contributing to all the aspects of the project, I got to learn a lot new things about web development. But honestly, the best thing I got from this course is a sense of fulfillment. It was hard to finish the whole project, but the thought that you're done with it pays for all the your efforts and busy nights.
 * Lyle Stephen Prospero**

=Discussion Notes=

See the notes here.

=Requirement Artifacts Deliverable=

We have managed to interview the client for this project, **Joshua Balagapo**, a CS student and the acting chairman of **UP Underground Music Community**, and produce the transcript of the short conversation. As for the forms and reports, we have no source of actual files that will suffice the requirements since the project only requires basic user or group information and does not include the use of pre-existing formal and legal documents for records and reports. Hence, we shall come up with our own original versions of forms that will be used when the application is implemented.

Here is the breakdown of tasks:

Interview, Interview Transcript, Entity-Relationship Diagram: Lyle Stephen Prospero Copies of forms and reports: Ryan Kristofer Arana and Junnel Villena = = =Installing Oracle Database=

As part of Workshop II, we were tasked to install **Oracle** on a machine, either on a Linux or Windows computer.


 * A. Creating an Oracle Account**

The installation file is available [|here]. But first, you must log in using your Oracle account.



Aside from the Oracle Database downloads, this account will grant you access to some of Oracle's software such as the Solaris OS, JAVA downloads, Netbeans IDE and other useful programming tools.


 * B. Installing the database**

Run the file using the administrator account (Windows) or use the //sudo// command (Linux).




 * Note:** Set a password for the first user account of the database. This shall be used later when accessing the contents of the database, uploading database commands and modifying the database options to meet your needs.


 * C. Accessing the database**

After finishing the installation, you may now access the database through a browser. Enter the default log-in name and the password you set earlier.



An interface similar to the image below will appear after entering the required information.



Through this, you can create entries, make and edit the database tables, edit accessibility options of the system and a lot more.

//To check the official installation guide of Oracle, click this link: [|Installing Oracle on a Machine]//