Preview

LIS2780 Assignments Spring15 2

Satisfactory Essays
Open Document
Open Document
2322 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
LIS2780 Assignments Spring15 2
Assignments

NB: BE SURE TO READ Assignment_Guidelines.pdf before submitting your work.
Please post any assignment questions within the Facebook group page. ***BE SURE to review and plan for ALL assignment and exam due dates and deadlines. ***

Assignment 1
1.
a. Ch. 1: Review Questions (RQ) 1 - 11
b. Ch. 2: RQs 1 – 9, 10, 11 and Problems #1 and 2 (include all attributes).

SQL Statements for A1 (premiere)

i. List all the contents (rows or records) of the PART table. ii. Create an alias for an attribute name. iii. List the part number, part description, and part price from the PART table in ascending order by part price. iv. Remove one or all records from the ORDERS table;
v. Update one customer’s first name, and their associated sale’s rep number. vi. Add two records to the customer table.

Assignment 2

2. Ch. 3: RQs 1 – 8, 10 - 13, and Problems 1 – 4, 6 (include all attributes).

SQL Statements for A2 (premiere)

i. List the customer number, last name, first name, and balance of every customer, sort by balance in descending order, and last name in ascending order. ii. List the first and last name of customer number 256? iii. Find the customer number for every customer whose last name is Adams. iv. Remove order number 12491;
v. Update the units on hand to 50, warehouse number to 2, and unit price to $329.00 for part number CB03. vi. Add two records to the orders table.

Select customer_number, last, first, balance
From customers order by balance dec, last asc;

Select, last, first
From customer
Where customer_num 256;

Select Customer_number
From customer
Where Last=’Adams’;

Delete From orders
Where order_number=12491

Update Part
Set units_on_hand=50,warehouse_number=2, unit_price=329
Where part_number=CB03;

Insert into Orders(order_number, order_date,customer_number)
Where()

Assignment 3

3. Ch. 4: RQs 1 – 19 (except 11), (Problem 3 not required; will be done in class.)

SQL Statements for A3 (premiere)
Must include query result sets!

Example of how

You May Also Find These Documents Helpful

  • Satisfactory Essays

    a. Solve parts a and b of problem 103 on page 605 and problem 104 on page 606 of Elementary and Intermediate Algebra .…

    • 548 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    AQA GCSE Mathematics SP12/43603F / Specimen Assessment Material / version1.0 / For First Teaching 2010…

    • 1033 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    MTH 213 Week 5 DQ 1

    • 387 Words
    • 3 Pages

    This document of MTH 213 Week 4 Individual Assignment Text Problems consists of: Ch.6 Ongoing Evaluation 6-2B: Exercise 11…

    • 387 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Unit 4 Exercise 3-4

    • 66 Words
    • 1 Page

    Please find the attached revised Problem 2-38 also I revised the Exercise 3-31 because I already submitted that assignment.…

    • 66 Words
    • 1 Page
    Satisfactory Essays
  • Satisfactory Essays

    This archive file of MTH 213 Week 1 Individual Assignment Text Problems consists of: Evaluation 1-1B Exercises 3, 7, 11, 13, 14…

    • 403 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    ENV 100 Week 3 DQ3

    • 422 Words
    • 3 Pages

    This work of ENV 100 Week 3 Discussion Questions 3 shows the solutions to the following problems:…

    • 422 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    CJA 374 Week 5 DQs

    • 423 Words
    • 3 Pages

    This work of CJA 374 Week 5 Discussion Questions shows the solutions to the following problems:…

    • 423 Words
    • 3 Pages
    Satisfactory 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
  • Powerful Essays

    Answers To Assignment 2 1

    • 2996 Words
    • 21 Pages

    Be Sure to submit these assignments by 09/27/2014 on BlackBoard, under “Assignment-Week 2. Answers must be labeled properly, with all pertinent information. No late submissions will be accepted.…

    • 2996 Words
    • 21 Pages
    Powerful Essays
  • Good Essays

    SQL Assignments

    • 365 Words
    • 2 Pages

    3. For each customer who placed orders in 2011, we would like to see the customer ID and the total…

    • 365 Words
    • 2 Pages
    Good Essays
  • Powerful Essays

    IST223-GHW7FS13

    • 2215 Words
    • 9 Pages

    Do parts A through M as given below. Those that involve SQL should be written…

    • 2215 Words
    • 9 Pages
    Powerful Essays
  • Satisfactory Essays

    Primary Key

    • 438 Words
    • 3 Pages

    2. For each of the entities identified, design tables and identify the possible candidate keys,…

    • 438 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    E.Finance

    • 697 Words
    • 3 Pages

    Exercises: 6 and 7. (note: these exercises are quite straightforward, don’t think too much of them)…

    • 697 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    The project will be about a Gift Shop database system. Because transaction records on papers can be lost or tampered, a simple yet effective and functional shop database system can be of use. This can also reduce the overall cost for managing the records that is paper based. This type of database system can be more secured and easy to manage.…

    • 2344 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    Myob Exercise

    • 275 Words
    • 2 Pages

    Richwin Ltd 18/Floor Block C 25 Ching Wan Road Shatin Sales & Receivables Journal 2/1/2009 To 31/1/2009 21/4/2010 17:32:29 Page 1 ID# Acct# Account Name Debit Credit Job No. SJ 3/1/2009 Discount: Okaya Trading Ltd SJ000001 6-2500 Discounts Allowed HK$401.00 SJ000001 1-2000 Accounts Receivable HK$401.00 SJ 6/1/2009 Sale; Okaya Trading Ltd CN001 1-2000 Accounts Receivable HK$5,000.00 CN001 4-1100 Sales HK$5,000.00 SJ 6/1/2009 Okaya Trading Ltd: Credit from CN001 SJ000002 1-2000 Accounts Receivable HK$5,000.00 SJ000002 1-2000 Accounts Receivable HK$5,000.00 SJ 10/1/2009 Discount: Okaya Trading Ltd SJ000003 6-2500 Discounts Allowed HK$300.00 SJ000003 1-2000 Accounts Receivable HK$300.00 SJ 21/1/2009 Sale; Union Co Ltd 00000002 1-2000 Accounts Receivable HK$2,500.00 00000002 4-1100 Sales HK$2,500.00 SJ 21/1/2009 Union Co Ltd: Credit from 00000002 SJ000004 1-2000 Accounts Receivable HK$2,500.00 SJ000004 1-2000 Accounts Receivable HK$2,500.00 SJ 26/1/2009 Finance Charge: Cash Sales SJ000005 1-1100 Citibank HK$3,400.00 SJ000005 1-2000 Accounts Receivable HK$3,400.00 SJ 29/1/2009 Sale; Cash Sales 00000003 1-2000 Accounts Receivable HK$3,400.00 00000003 4-1100 Sales HK$3,400.00 SJ 29/1/2009 Sale; Good Hope Co 00000004 1-2000 Accounts Receivable HK$18,500.00 00000004 4-1100 Sales HK$18,500.00 Grand Total:…

    • 275 Words
    • 2 Pages
    Satisfactory Essays

Related Topics