Preview

Cis/336 Ilab 5 of 7 - Sql Course

Good Essays
Open Document
Open Document
1559 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Cis/336 Ilab 5 of 7 - Sql Course
CIS/336 iLab 5 of 7 - SQL Course

Lab 5 of 7: Retreiving data from Multiple Tables (28 points) L A B O V E R V I E W
Scenario/Summary

Lab 5 deals with writing queries using multiple tables as covered in the reading and lecture material this week. In some cases, you will be given the option to write a query using either the TRADITIONAL method of joining tables or using the JOIN key word. In some cases, you will be asked to use a specific approach. Using the incorrect process when the process is specified will result in points being taken off for that problem. The SELECT statement is the primary means of extracting data from database tables, and allows you to determine exactly which data you want to extract by means of different comparison operators used in the WHERE clause. This includes the use of specific "wild card" characters which allow you to search for character or number patterns within the data. You can also perform mathematical expressions within the SELECT statement to create derived output. The ORDER BY clause allows you to sort the output data in either ascending (the default) or descending order. Lab #5 will explore all of these applications of the SELECT statement.
General Lab Information and Considerations
This lab will utilize a set of tables found in the script file (LeeBooks.sql) found in the Doc Sharing area of the website. If you have not yet downloaded this file from Doc Sharing then do so now. Once you have downloaded the script file, import and run the script in SQL*Plus.
Each query in the script file you will create must be numbered (use --1 comments for numbering) and in order. The SQL for the following exercises should be written using notepad and run in SQL*Plus.

A Clean Script File:
A script file is meant to be like a program. The file can be run every time the code needs to be executed without having to retype the code again each time. For this reason, it is important that there are no errors in the

You May Also Find These Documents Helpful

  • Powerful Essays

    unit 203

    • 1554 Words
    • 7 Pages

    This assignment is intended to provide evidence of a candidate’s knowledge and understanding of communication and professional relationships with children, young people and adults. By completing all tasks within the assignment, the candidate will provide evidence that meets the Learning Outcomes and assessment criteria of Unit 203, Communication and professional relationships with children, young people and adults.…

    • 1554 Words
    • 7 Pages
    Powerful Essays
  • Powerful Essays

    PT2520

    • 1263 Words
    • 7 Pages

    The course project is based on the Westlake Research Hospital scenario that you have been studying throughout the course and uses the Westlake database you used for the Group A labs. To complete the project, you will need to use your copy of the SQL2008ExpVM virtual machine, as it existed at the end of the last unit (Unit 9). Your instructor will provide you with a script file named ProjectLoadData.sql, which you will use to populate the database. You will receive instructions on how to use this file in Step 10 of the Technical Steps section of this lab.…

    • 1263 Words
    • 7 Pages
    Powerful Essays
  • Satisfactory Essays

    In this project, you will create a new table and share data with Excel in a database for the Burchard Museum of Science and Discovery. Additionally, you will establish relationships between tables, and then create queries within the database.…

    • 402 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Insert data tables for each part of the lab (Part I, Part II, and Part III).…

    • 782 Words
    • 4 Pages
    Satisfactory Essays
  • Good Essays

    "SQL Sql Database Language Data Standard Query Programming Set." Business, Economy, Market Research, Finance, Income Tax Informations. N.p., n.d. Web. 26 Sept. 2012. <http://www.economicexpert.com/a/SQL:programming:language.htm>.…

    • 701 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Math Probabilities

    • 602 Words
    • 3 Pages

    I have granted you all access to query the tables in my account. You can access them by typing suebrown., so to access the publishers table, type suebrown.publishers. As a second alternative, you can use the scripts in blackboard to create the tables in your own oracle space. It is your choice how you want to do this – just make sure that if you create the tables in your own directory that you do not change the data.…

    • 602 Words
    • 3 Pages
    Good Essays
  • Good Essays

    Week 1 Submission

    • 1120 Words
    • 5 Pages

    Copy the demo.sql file from the Doc Share to the C:\temp directory. At the sql prompt enter the command @V:\temp\demo.sql. This will create some tables and insert data into them. View the script in notepad to determine the table names that were created. Use the describe command to view the structure of the tables. Please use the template below to provide your solutions.…

    • 1120 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Accounting

    • 288 Words
    • 2 Pages

    Retrieve the S&S In-Chapter Database (in Microsoft Access format) from Doc Sharing or the text’s Web site (or create the tables in <link linkend="ch04table05" preference="0">Table 4-5<xref linkend="ch04table05" label="4-5"/></link> in a relational DBMS product). Write queries to answer the following questions. <emphasis>Note</emphasis>: For some questions, you may have to create two queries—one to calculate an invoice total and the second to answer the question asked.…

    • 288 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 365 Assignment 3

    • 788 Words
    • 4 Pages

    2. It is STRONGLY suggested that you do your scratch work on Notepad or Textpad.…

    • 788 Words
    • 4 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Sfasasas

    • 414 Words
    • 2 Pages

    The SQL WHERE clause is used to select data conditionally, by adding it to already existing SQL SELECT query. We are going to use the Customers table from the previous chapter, to illustrate the use of the SQL WHERE command.…

    • 414 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    Scripts

    • 1613 Words
    • 7 Pages

    the script path and the file name. Scripts can be as simple as a single…

    • 1613 Words
    • 7 Pages
    Good Essays
  • Satisfactory Essays

    In addition to the computers, you also require the software listed in Table 1-2 to complete Lab 1.…

    • 1996 Words
    • 8 Pages
    Satisfactory Essays
  • Satisfactory Essays

    1. Create and complete a data table for Part One of the lab. It should include the name of…

    • 328 Words
    • 2 Pages
    Satisfactory Essays
  • Powerful Essays

    study report idbi

    • 10254 Words
    • 40 Pages

    Insurance is a social device whereby a large group of individuals, through a system of equitable contributions, may reduce or eliminate measureable risk…

    • 10254 Words
    • 40 Pages
    Powerful Essays
  • Satisfactory Essays

    sql server notes

    • 36521 Words
    • 147 Pages

    SQL is a database computer language designed for the retrieval and management of data in relational…

    • 36521 Words
    • 147 Pages
    Satisfactory Essays