SQL

Need Help in SQL Assignment?
We can help you if you are having difficulty with your SQL Assignment. Just email your SQL Assignment at admin@assignmentcache.com.
We provide help for students all over the world in SQL Assignment.

Items 11 to 20 of 20 total

per page
Page:
  1. 1
  2. 2

Grid  List 

Set Ascending Direction
  1. CS362 Structured Query Language for Data Management Week 2 IP

    CS362 Structured Query Language for Data Management Week 2 IP

    Regular Price: $20.00

    Special Price: $15.00

    CS362 Structured Query Language for Data Management Week 2 IP

    After creating the database schema, use Insert, Update, and Delete commands to populate the tables with the following information.

    1. Insert the following classes' records:
    Code     Name     Description
    ACCT306     Accounting 1     This course introduces accounting concepts and explores the accounting environment. It covers the basic structure of accounting, how to maintain accounts, use account balances to prepare financial statements, and complete the accounting cycle. It also introduces the concept of internal control and how to account for assets.
    CS362     Structured Query Language for Data Management     This course gives complete coverage of SQL, with an emphasis on storage, retrieval, and manipulation of data.
    ENG115     English Composition     In this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techniques.
    FIN322     Investments     This course focuses on investments and investment strategies. Various investment vehicles such as stocks, bonds, and commodities are examined. Students will explore the principles of security analysis and valuation.

    2. Insert the following advisors' records:
    Name     Email
    Fred Stone     fred@college.edu
    Bob Gordon     bob@college.edu
    Jack Simpson     jack@college.edu

    3. Insert the following students' records:
    Name     Birthdate     Gender     StartDate     GPA     IsActive     AdvisorID
    Craig Franklin     1970-03-15     Male     2010-05-30     3.10     Yes     3
    Harriet Smith     1982-04-15     Female     2010-05-30     3.22     Yes     1
    George David     1984-11-05     Male     2010-10-01     0.00     Yes     3
    Ben Jefferson     1976-09-25     Male     2009-02-21     1.80     No, the student has gone on temporary leave to pursue other opportunities but plans on returning in 1 year.     3

    4. Delete the course named Investments from the system.

    5. Change Harriet Smith’s birthdate to April 25, 1982 and her GPA to 3.25.

    Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Provide an introduction explaining the important of these commands in relation to your overall Key Assignment.

    Learn More
  2. CTS2437 Final Exam SQL Server

    CTS2437 Final Exam SQL Server Administration

    Regular Price: $15.00

    Special Price: $12.00

    CTS2437 – Final Exam
    Provide the SQL statements required to accomplish the following tasks.
    #1 (10 points)
    Create a database named FINAL_EXAM that you will then use for all remaining problems.

    #2 (20 points)
    Create the tables and appropriate constraints based on the following ER diagram. Use appropriate data types. Note that the size column should only accept S, M, or L. In addition the price column should have values greater than zero. All columns in both tables are required.

    Catgeory Product



    C




    #3 (5 points)
    Insert 3 rows in the Category table. The db is for a small shoe store, so use appropriate data for the description ( “Men”, “Women”, “Children”)
    #4 (5 points)
    Insert 3 Product records for each category in the product table. Use whatever data you see as appropriate.

    #5 (5 points)
    Use one statement to increase the price of all products in the Men category by 25%.


    #6 (5 points)
    Use one statement to delete all products for the Children category.

    #7 (10 points)
    Create and execute a view named EXAM_VIEW that shows all columns from both tables. Use an inner join.

    #8 (10 points)
    Create a database trigger named EXAM_TRIGGER that prevents a user from deleting a Product record on Tuesdays. Display an appropriate error message. Make sure to show that the trigger is working properly.

    #9 (10 points)
    Create a stored procedure named SP_EXAM that will be used to insert records into the Product table. Make sure to show that the procedure is working properly.

    #10 (5 points)
    Remove the EXAM_VIEW object from the database.

    #11 (5 points)
    Remove the SP_EXAM stored procedure from the database.

    #12 (5 points)
    Remove the EXAM_TRIGER database trigger from the database.

    #13 (5 points)
    Remove the FINAL_EXAM database. Learn More
  3. CTS2437 South Community College ERD

    CTS2437 South Community College ERD and SQL script

    Regular Price: $15.00

    Special Price: $12.00

    South Community College (SCC) is structured like a typical community college. They have 3 semesters and a multitude of courses. Each course may have any number of sections in a given semester. For example, CTS2437 (SQL Server) may have one or more sections being taught in any given semester. SCC has 3 semesters (fall, spring, summer) which they refer to as A, B, and C. They refer to semesters by the year and the semester code. For example, fall 2011 would be referred to as 2011A. They need to keep track of students, courses, schedules, instructors, and grades earned in each course taken. They need a database to maintain these information.
    The student information would include the student name, address, phone#, and email. Students may have taken or are taking any number of courses. The grade earned for each course must also be maintained. The course information would include the course title and number of credits. Keep in mind that a given course may have many sections in any particular semester. SCC needs to maintain the instructor for each section in addition to the students and the grade they earned. The instructor information would include the instructor name, phone#, office#, and email address. South needs to maintain all courses that the instructor has taught or is currently teaching.

    Some of the requirements that SCC has requested in the database system include:
    • Student cannot register for the same section more than once.
    • A roaster of students can be produced for any given section.
    • GPA (Grade Point Average) can be generated for a student for any given semester, year, or entire school career.
    • GPA is calculated by adding up all of the grades earned (A=4, B=3, C=2, D=1, F=0) and dividing by the number of credits associated with the courses taken.
    • A transcript can be produced for a given student showing all courses taken and grades earned.
    Learn More
  4. IS562 SQL database queries

    MIS562 SQL Database Queries Assignment

    Regular Price: $10.00

    Special Price: $8.00

    MIS562 SQL Database assignment


    1. Show a list of all employee names and their department names and the employees for each department. Be sure to show all departments whether there is an employee in the department or not. Use an outer join.


    2. Select all employee names and their department names. Be sure to show all employees whether they are assigned to a department or not. Use an outer join.


    3. Write a query that that performs an inner join of the grade, student, and grade_type tables using ANSI SQL 99 syntax.


    4. Write a query that that performs an inner join of inner join of the grade, student, and grade_type tables using the Oracle inner join convention.


    5. List all the zip codes in the ZIPCODE table that are not used in the STUDENT or INSTRUCTOR tables. Use a set operator.


    6. Write a SQL statement using a set operator to show which students enrolled in a section that are not enrolled in any classes. Exclude students with student id less than 300.

    Learn More
  5. Northwind Database Task 2 Database Diagram

    Northwind Database SQL Queries

    Regular Price: $10.00

    Special Price: $8.00

    Install the Northwind Database into the environment. Click here to install the database.
    Note that this link does link to the SQL Server 2000 Sample Databases, but after downloading it, the ZIP file can be extracted and contained inside the package as a file named "instnwnd.sql." This file can be opened and executed inside of Microsoft SQL Server Management Studio.


    Task #2
    Generate a database diagram.
    Include a screenshot of this diagram in your Word document.


    Task #3
    Write SELECT statements for the following questions:
    For each of these statements, include a screenshot of the SQL. Make sure to include the statement execution, including the resulting data.
    1. Display all columns and all rows from the Employees table.
    9 rows returned
    2. Display the regionid, regiondescription for all rows in the Regions table.
    4 rows returned
    3. Modify query 2 so that the column headings are as follows:
    "ID" and "Description"
    4 rows returned
    4. Display the customer ID, customer name, and region for all customers.
    91 rows returned
    5. Display the customer ID, customer name, and region for all customers.
    Name the columns "ID," "Name," and "Region" (respectively), and sort the data by the company name.
    91 rows returned

    Learn More
  6. POS 410 Week 4 SQL for Business Kudler_FF database

    POS 410 Week 4 SQL for Business Kudler_FF database

    Regular Price: $15.00

    Special Price: $12.00

    POS/410 SQL for Business Week 4


    SQL Reports


    Use tables from the Kudler_FF database to write the SQL statements necessary to perform the following data manipulation:
    o Increase all employees salaries with the selected EEO-1 classification by 10%.
    o Increase all employees salaries by 5%.
    o Choose an employee from the Employee table and delete that employee.
    Deliverable: Copy the SQL statements and data from both tables showing how data was affected to a Word document. Post the document to the assignment tab of the classroom.



    Use tables from the Kudler_FF database to write SQL statements that perform the following computations:
    o Calculate the average salary for all employees.
    o Calculate the maximum salary for all employees.
    o Calculate the maximum salary for exempt employees.
    o Calculate the minimum salary for all employees.
    o Calculate the minimum salary for non-exempt employees.
    Deliverable: Copy the SQL statements and results to a Word document. Post the document to the assignment tab of the classroom.



    Use tables from the Kudler_FF database to write the following queries, using the GROUP BY clause in your SQL statements:
    o Count the number of employees, grouped by EEO classification.
    o Count the number of employees, grouped by exemption status.
    o Compute the average salary, grouped by area code and gender.
    o Compute average age, grouped by exemption status o Compute the earliest hire date, grouped area code, gender, and exemption status. Deliverable: Copy the SQL statements and results to a Word document. Post the document to the assignment tab of the classroom.

    Learn More
  7. CIS515 Assignment 2 Database Systems and Database Models

    CIS515 Assignment 2 Database Systems and Database Models

    Regular Price: $20.00

    Special Price: $15.00

    CIS515 Assignment 2: Database Systems and Database Models


    The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.


    Imagine that you have been hired as a consultant to assist in streamlining the data processing of an international based organization that sells high-end electronics. The organization has various departments such as payroll, human resources, finance, marketing, sales, and operations. The sales department is the only department where employees are paid a commission in addition to their yearly salary and benefits. All other departments compensate their employees with a yearly salary and benefits only. Commission is paid by multiplying the employee’s commission rate by the total amount of product units sold. You have access to the following data sets:


    Employee (EmpNumber, EmpFirstName, EmpLastName, CommissionRate, YrlySalary, DepartmentID, JobID)
    Invoice (InvNumber, InvDate, EmpNumber, InvAmount)
    InvoiceLine (InvLineNumber, InvNumber, ProductNumber, Quantity)
    Product (ProductNumber, ProductDescription, ProductCost)
    Department (DepartmentID, DepartmentDescription)
    Job (JobID, JobDescription)


    Write a two to three (2-3) page paper in which you:


    Design a query that will allow the finance department to determine the commissions paid to specific employees of the sales department for the month of December. Note: You will need to generate the tables described above (Employee, Invoice, InvoiceLine, Product, Department, and Job) in order to compare and validate your code. Validated query code must be part of your paper.
    Compare the code of the query you designed in Question one (1) to one that would show how much total compensation is paid to each employee for the same month.
    Determine and explain the factors necessary to ensure referential integrity.
    Create an object-oriented model to show how the tables are interrelated through the use of graphical tools such as Microsoft Visio, or an open source alternative such as Dia. Make sure that you are able to show the relationship types such as 1:M, 1:1, or M:1. Additionally, remember to include the determined factors from the previous assignment requirement. Note: The graphically depicted solution is not included in the required page length.
    Identify which data components are the entities and attributes, and the relationship between each using an object representation diagram through the use of graphical tools such as Microsoft Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
    Describe how Big Data could be used to assist in the productivity and forecasting of the organization’s products and resources.

    Learn More
  8. Murachs SQL Chapter 10 Membership Database

    Murachs SQL for SQL Server Chapter 10 How to create and maintain databases and tables with SQL statements

    Regular Price: $12.00

    Special Price: $10.00

    Murach’s SQL for SQL Server Chapter 10 How to create and maintain databases and tables with SQL statements
    Exercises
    1. Create a new database named Membership.
    2. Write the CREATE TABLE statements needed to implement the following design in the Membership database. Include reference constraints. Define IndividualID and GroupID with the IDENTITY keyword. Decide which columns should allow null values, if any, and explain your decisions. Define the Dues column with a default of zero and a check constraint to allow only positive values.
    3. Write the CREATE INDEX statements to create a clustered index on the GroupID column and a nonclustered index on the IndividualID column of the GroupMembership table.
    4. Write an ALTER TABLE statement that adds a new column, DuesPaid, to the Individuals table. Use the bit data type, disallow null values, and assign a default Boolean value of False.
    5. Write an ALTER TABLE statement that adds two new check constraints to the Invoices table of the AP database. The first should allow (1) PaymentDate to be null only if PaymentTotal is zero and (2) PaymentDate to be not null only if PaymentTotal is greater than zero. The second constraint should prevent the sum of PaymentTotal and CreditTotal from being greater than InvoiceTotal.
    6. Delete the GroupMembership table from the Membership database. Then write a CREATE TABLE statement that recreates the table, this time with a unique constraint that prevents an individual from being a member in the same group twice.

    Learn More
  9. DBM 405 Lab 1 SQL Review

    DBM 405 Lab 1 SQL Review Advanced Database Oracle

    Regular Price: $20.00

    Special Price: $15.00

    DBM 405 Lab 1 SQL Review Advanced Database Oracle

    Scenario/Summary
    The purpose of the first week's lab is to review the SQL language, and familiarize you with the database example that we will use in labs through this course. If you have not done it yet, please download the MovieRentals.SQL file to your computer from Doc Sharing. This script file will need to be run once logged into your Oracle user account to create the tables and data that will be used for this lab and subsequent labs in the course.
    Setting up your environment:
    Before attempting Lab 1, you need to be sure you have read through the SQL*Plus tutorial which can be found in Doc Sharing as well as under the SQL*Plus Tutorial tab in Week 1. This tutorial describes the functionality of the editor and will step you through the process of setting up and using the SQL*Plus in the iLab environment so that it will best serve your needs for the remainder of the labs required for this course. Once you have logged into Oracle through iLab then execute the MovieRental.SQL script and create the tables and data for the lab.
    For the lab, you will need to create a script file containing the eight queries that will address the lab steps below. Run the script file in your SQL*Plus session using the SET ECHO ON session command at the beginning to capture both the query and result set. Spool your output to a file named with your last name plus lab 1 and give the file a text (.txt) extension. For example, if your last name was Johnson then the file would be named johnson_lab1.txt. Submit both the spooled output AND the script file for grading of the lab.

    LAB STEP
    Step 1:
    Within SQL*Plus, list names of the tables that you have created whose name starts with MM (Hint: use data dictionary view USER_TABLES).

    Step 2:
    Use DESCRIBE (in short: DESC) command in SQL*Plus for each of these tables to show columns and their datatypes.

    Step 3:
    Use SELECT * command to display all data from each of the tables in the MoreMovies schema. Make sure that the LINESIZE and PAGESIZE have large enough values, and that you format columns so that the report looks good. You should end up with five queries and result sets.

    Step 4:
    Using the mm_movie and mm_movie_type tables, write a query that will list all movie categories together with the count of movies in each category. Give the column with the count in it a meaningful name such as IN STOCK.

    Step 5:
    Using the mm_movie and mm_rental tables, write a query that will list titles and checkout dates for all movies that were signed out by Wild Coyote (MEMBER_ID=13).

    Step 6:
    Using the same two tables used in Step 5, write an SQL sub-query that will list all movies (movie ids and titles) of all movies that have never been rented.

    Step 7:
    Using the mm_member and mm_rental tables, write a query that will list all members (member ID, first name, and last name) and the number of movies they have rented, for all members who have rented at least one movie. Order the result set so that it shows the largest number of movies rented as the first row.

    Step 8:
    Write a query that will display the largest number of movies rented by one member and that member's name. Give the output column a meaningful name such as MAXIMUM NUMBER.

    Step 9:
    Using the mm_member and mm_rental tables, write a query that will display member ID, last name, first name, and the number of movies rented for each member. Give the column with the number of movies rented a meaningful name such as NUMBER RENTED.

    Step 10:
    Using the mm_member, mm_movie and mm_rental tables, write the query that will prepare a report that shows who rented which movie. Use member names (first and last) and movie title rather than the corresponding IDs. Order the report by member names, and for a single member by the movie titles.

    This concludes the Lab for Week 1.

    Learn More
  10. DBM449 LAB1 SqlFile

    DBM 449 LAB 1 Oracle Joins

    Regular Price: $20.00

    Special Price: $5.00

    GENERAL OVERVIEW
    Scenario/Summary
    My colleague, Ann Henry, operates a regional training center for a commercial software organization. She created a database to track client progress so she can analyze effectiveness of the certification program. CLIENT, COURSE, and COURSE_ACTIVITY are three of the tables in her database. The CLIENT table contains client name, company, client number, pre-test score, certification program and email address. The COURSE_ACTIVITY table contains client number, course code, grade, and instructor notes. The COURSE table contains the course code, course name, instructor, course date, and location. Although she and her instructors enter much of the data themselves, some of the data are extracted from the corporate database and loaded into her tables.

    Loading the initial data was easy. For grade entry at the end of each course, a former employee created a data entry form for the instructors. Updating most client information and generating statistics on client progress is not easy because Ann does not know much SQL. For now, she exports the three tables into three spreadsheets. To look up a grade in the COURSE_ACTIVITY spreadsheet, she first has to look up client number in the CLIENT spreadsheet. While this is doable, it is certainly not practical. For statistics, she sorts the data in the COURSE_ACTIVITY spreadsheet using multiple methods to get the numbers she needs.

    Every month, Ann's database tables need to be refreshed to reflect changes in the corporate database. Ann describes this unpleasant task. She manually compares the contents of newly extracted data from corporate to the data in her spreadsheets, copies in the new values, and then replaces the database contents with the new values.

    Ann needs our help. Let’s analyze her situation and determine what advanced SQL she could use to make her tasks easier.
         
    L A B O V E R V I E W


    Scenario/Summary


    The purpose of this lab is to explore join operators to determine which, if any, are appropriate for solving Ann's business problems, as described in this week's lecture.


    Since Ann prefers to work from Excel spreadsheets, she wants her CLIENT and COURSE_ACTIVITY tables exported into one spreadsheet rather than two, as she is currently using. We need to determine which, if any, of the join operators will provide the data she wants for the single spreadsheet. (Note: we will not perform the export, just determine how to retrieve the necessary data.) Using the spreadsheet, she will be able to determine:



    1. Which course(s) a specific client has taken

    2. What grade(s) a specific client has earned in a specific course

    3. Which clients did not take any courses

    4. Which courses were not taken by any client


    Here are results from DESCRIBE commands that show structure (columns and their data types) of tables CLIENT and COURSE_ACTIVITY. You may refer to it while constructing your queries.


    SQL*Plus: Release 10.2.0.1.0 — Production on Thu Jun 14 22:38:52 2007

    Copyright (c) 1982, 2005, Oracle.  All rights reserved.

    Connected to:
    Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 — 64bit Production
    With the Partitioning, OLAP and Data Mining Options

    SQL> desc course_activity



    SQL>


    For this lab you will be creating several documents. First, write your queries in Notepad to create a script file that will contain all of the queries asked for in lab steps 4 through 13. You can (and should) test each query as you write it to make sure that it works and is returning the correct data. Once you have all of your queries written then create a SPOOL session and run your entire script file. Be sure that you execute a SET ECHO ON session command before running the file so that both the query and the output will be captured in the SPOOL file. IMPORTANT: If you are using Windows Vista you will need to create a directory on your C: drive to SPOOL your file into. Vista will not allow you to write a file directly to the C: drive. This will give you two files for the lab. The third file will the be the Lab1 Report document found in Doc Sharing. You will need to put your responses to the questions asked in the various lab steps.


    Now let's begin.


    L A B S T E P S

    STEP 1: Start Oracle SQL*Plus via Citrix


    Log into the Citrix iLab environment. Open your Oracle folder, select SQL Plus and log in to your database instance. Use "sys" as User Name, and "oracle" as the Password. Enter the Host String as "DB9999.world as sysdba" where 9999 is the database number you have been assigned.


    STEP 2: Initialize tables


    Download the pupbld.sql and Lab1_init.sql files associated with the links to your C: drive or to the F: drive in your Citrix environment. You will need to open each of the files and edit the connection string to reflect your instance name. The pupbld.sql file has two connections strings; one at the top of the script and another at the bottom. Be sure to change both of these to reflect your instance name.


    Once you have done this then run the pupbld.sql script first (DO NOT copy and paste it) in your SQL*Plus session. The script will create the product_user_profile synonym in the SYSTEM account which will be used each time you log in as a normal user.


    Next run the lab1_init.sql script in your session. The script will create a new user (DBM449_USER) that will be used in various labs in this course. You can find the password for this new user by looking at the CREATE USER statement in the script file. Disregard the DROP TABLE error messages. They occur because the script is designed to work regardless of whether you have already created the tables or not. This way, you may run it if you ever decide to resent the contents of your tables to the original values. When you run the script for the first time, the error messages appear as you attempt to drop tables that do not exist.


    Once the script has finished you will be logged into the new user and ready to start your lab.


    STEP 3: Verify your tables


    You want to verify that everything completed successfully. To do this execute a SELECT * FROM TAB statement to make sure all 5 tables were created and then you can execute a SELECT COUNT(*) FROM statement using each of the table names. You should find the following numbers of records for each table.



    • CLIENT table - 5 rows

    • COURSE table - 5 rows

    • COURSE_ACTIVITY table - 6 rows

    • CORP_EXTRACT1 table - 3 rows

    • CORP_EXTRACT2 table - 0 rows


    NOTE: In the following steps when writing your queries be sure to list the tables in the FROM clause in the same order they are listed in the instructions. Reversing the order of the tables in the FROM clause will produce an incorrect results set


    STEP 4: Using the FULL OUTER JOIN operator


    Join the CLIENT and COURSE_ACTIVITY tables using a FULL OUTER JOIN.



    • Write and execute the SQL statement that produces the client number and name, course code and grade that the client got in this course.


    Will the FULL OUTER JOIN be helpful to Ann? Place your response in the lab report document for this step.


    STEP 5: Using the RIGHT OUTER JOIN operator


    Join the CLIENT and COURSE_ACTIVITY tables using a RIGHT OUTER JOIN.



    • Write and execute the SQL statement that produces the client number and name, course code and grade that the client got in this course.


    Will the RIGHT OUTER JOIN be helpful to Ann? Place your response in the lab report document for this step.


    STEP 6: Using the LEFT OUTER JOIN operator


    Join the CLIENT and COURSE_ACTIVITY tables using a LEFT OUTER JOIN.



    • Write and execute the SQL statement that produces the client number and name, course code and grade that the client got in this course.


    Will the LEFT OUTER JOIN be helpful to Ann? Place your response in the lab report document for this step.


    STEP 7: Using the NATURAL JOIN operator


    Join the CLIENT and COURSE_ACTIVITY tables using a NATURAL JOIN.



    • Write and execute the SQL statement that produces the client number and name, course code and grade that the client got in this course.

    • Will the NATURAL JOIN be helpful to Ann? Place your response in the lab report document for this step.


    STEP 8: Using the INNER JOIN operator


    Join the CLIENT and COURSE_ACTIVITY tables using a INNER JOIN.
    Write and execute the SQL statement that produces the client number and name, course code and grade that the client got in this course.


    Will the INNER JOIN be helpful to Ann? Place your response in the lab report document for this step.


    Write a conclusion based on the five steps above, which join - if any - should Ann use to populate the spreadsheet that can answer her questions.


    STEP 9: Using the UNION operator 


    Examine the clients and courses in Ann’s tables and the CORP_EXTRACT1 table using the UNION operator.



    • Write and execute the SQL statement that examines client numbers in CLIENT and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines client numbers in COURSE_ACTIVITY and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines course names in COURSE and CORP_EXTRACT1.


    Which of these statements, if any, will be helpful to Ann? Place your response in the lab report document for this step.


    STEP 10: Using the UNION ALL operator


    Examine the clients and courses in Ann’s tables and the CORP_EXTRACT1 table using the UNION ALL operator.



    • Write and execute the SQL statement that examines client numbers in CLIENT and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines client numbers in COURSE_ACTIVITY and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines course names in COURSE and CORP_EXTRACT1.


    Which of these statements, if any, will be helpful to Ann? Place your response in the lab report document for this step.


    STEP 11: Using the INTERSECT operator


    Examine the clients and courses in Ann’s tables and the CORP_EXTRACT1 table using the INTERSECT operator.



    • Write and execute the SQL statement that examines client numbers in CLIENT and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines client numbers in COURSE_ACTIVITY and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines course names in COURSE and CORP_EXTRACT1.


    Which of these statements, if any, will be helpful to Ann? Place your response in the lab report document for this step.


    STEP 12: Using the MINUS operator


    Examine the clients and courses in Ann’s tables and the CORP_EXTRACT1 table using the MINUS operator.



    • Write and execute the SQL statement that examines client numbers in CLIENT and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines client numbers in COURSE_ACTIVITY and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines course names in COURSE and CORP_EXTRACT1.


    Which of these statements, if any, will be helpful to Ann? Place your response in the lab report document for this step.


    STEP 13: Using subqueries


    Examine the clients and courses in Ann’s tables and the CORP_EXTRACT1 table using a subquery with NOT IN operator.



    • Write and execute the SQL statement that examines client numbers in CLIENT and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines client numbers in COURSE_ACTIVITY and CORP_EXTRACT1.

    • Write and execute the SQL statement that examines course names in COURSE and CORP_EXTRACT1.


    Which of these statements, if any, will be helpful to Ann? Place your response in the lab report document for this step.


    Deliverables
        
    What is Due


    Submit your spooled lab file with the queries and results sets along with the completed Lab 1 Report to the Dropbox. Your report should contain copies of each query and result set outlined in the lab along with the requested explanation of whether or not it satisfied the business requirement outlined for that particular section of the lab.

    Learn More

Items 11 to 20 of 20 total

per page
Page:
  1. 1
  2. 2

Grid  List 

Set Ascending Direction