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