hw1_05spring_435 - Page 1-IOM 435 FIRST HANDS-ON...

Info icon This preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
4/3/05 ------------------------------------------------------------------------------------------------------------------------ IOM 435 - FIRST HANDS-ON OPPORTUNITY 4/03/05 ------------------------------------------------------------------------------------------------------------------------ - DUE SUNDAY @MIDNIGHT 4/18/05 - Hi Team, This first hands-on opportunity is intended to initiate you to the world of Structured Query Language (SQL), acquaint you with Oracle's SQL*Plus interface and introduce you to a few basic DDL (Data Definition Language) and data manipulation (DML) commands. All of these assignments will be provided to you via email and you may submit your responses via email at anytime prior to the due date/time. In order to handle the number of assignments I will receive , I ask that you put the text "435SQL1" in the message header (please type in the string exactly as shown with no spaces -- this will allow me to use mail filters to send the text to the appropriate folders on my system). Send your output to the following account: ********************************IMPORTANT****************************** SEND EMAL TO THIS ACCOUNT TO RECEIVE CREDIT [email protected] marshall.usc.edu ******************************************************************************* HINTS & SUGGESTIONS : If you wish to print off this message, you should use a non-proportional font like courier so that columns in the data will be preserved (proportional fonts will make it very difficult to determine columns in the sample data). USING ORACLE If you are using personal Oracle at home, you will need to install and initialize it. Once you have the database started, you may login. The default "guest" login account for any Oracle system is "scott" and the password is "tiger". When the login menu comes up, you would type: User Name: scott Password: tiger Host String: (leave Host String blank for a local login) Oracle at school Because I have connected and started the database on the server at school, you only need to login: User Name: ISD account Password: 999999999 Host String: iomclass.usc.edu IOM 435 - Business Database Systems Shook Spring 2005 Page 1
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
4/3/05 (your ISD account is your UNIX and/or your USC email account; you need to replace the '99999999' with the password your created during the lab) WRITING YOUR SQL PROGRAM Please use the sample program in your SQL Handout as a model for how to write your SQL program for this assignment. I strongly recommend that you us a plain ascii editor (e.g., notepad, edit, e, pico, emacs, vi, kedit, etc.) to create your program. If you want to use word, or some other word processor, you must be certain that you save your program as an ascii text file, not as a word document (i.e., a *.doc file). If you start your program with drop table xxx commands (like the sample program) you will be able to run the program, fix bugs, and rerun again very easily. Once you have written the program, start Oracle, select the "File" option from the menu, select "open", type the name of the file you created and then run it. You also can simply run the SQL command file from the SQL*Plus command prompt by typing "@ filename". @c:\temp\hw1 would run a sql file named hw1.sql that is located in the c:\temp directory. Here it is assumed that you called the file "hw1.sql" and it is in the c:\temp. If not, type in the correct pathname, filename and extension: @ c:\TEMP\hw1.txt This approach is particularly well suited to the multiple insert commands you will need to populate the tables.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern