ISQS3348-002

Lab Exercises & Homework Assignments

Week

Lab Exercises

Take Home Assignments

11

 

 

10

Lab Exercise 7, due 4/20, Wednesday, before class

1)     Install VirtualBox onto McBook SQL Server

2)     Install Windows. Check http://www.intowindows.com/how-to-install-windows-7-on-virtualbox/

3)     Install SQL Server 2014

An assignment of database implementation will be counted 20% of Exam 3 .

Continue working on Lab Exercise 7

9

Lab Exercise 6, due 4/11, Monday, before 11:59p

Set up Microsoft Azure account. Screenshot in a Word file and email the file (filename: “3348-Ex6-lastname.docx”) to isqs3358@gmail.com with a subject title “3348-Ex6–lastname”.

Continue working on Lab Exercise 6

8

Review Chapter 5 & 6

Assignment 8 due 4/4, Monday before class meeting

P384-385 (7e) Review Questions 6.22, 6.24, 6.26, 6.28, 6.36, 6.40, 6.42

Submission is Not required.

7

Lab Exercise 5, due 3/25, Friday, before 11:59p

Email the results in a Word file (filename: “3348-Ex5-lastname.docx”) to isqs3358@gmail.com with a subject title “3348-Ex5–lastname”.

1.     SQL Scripting based on Heather Sweeney Design database. Provide the SQL code and screenshot the results.

1)     Write an SQL statement to list the names of customers who have used visa card to purchase any product. Use a subquery.

2)     Write an SQL statement to list the names of customers who have used visa card to purchase a book.

3)     Write an SQL statement to show the name and sum of expenses so far for each customers who purchased some products.

4)     Write an SQL statement to find the seminar with the number of customers and seminar date, the customers of which have the highest total purchases regardless when they purchased. 

2.     Study textbook pp344-349 and relevant slides for Chapter 6 and answer the following questions in pp384 (7e): 6.29-6.35

 

Review Assignment 6 (go through the file of the keys in the network drive)

Assignment 7 due 3/30, Wednesday before class meeting

P383-384 (7e) Review Questions 6.4, 6.7, 6.11, 6.17, 6.21

P351 (6e) / p385 (7e) Exercise 6.50.

Email the answers to (isqs3358@gmail.com) with a subject title “3348-Assgn7–lastname”.

6

Lab Exercise 4, due 3/10, Thursday, before 11:59p

Review Assignment 5: pp222-232 (7e), Heather Sweeney Design case, Question K to R

No submission is needed.

Assignment 6 due 3/21, Monday before class meeting

pp296 (6e) / pp326-327 (7e), Exercise 5.36 to 5.42

Email the answers to (isqs3358@gmail.com) with a subject title “3348-Assgn6–lastname”.

5

Lab Exercise 3, due 3/4, Friday, before 11:59p

Review of Assignment 4 & Lab Exercise 2

Deliverable:

1)     Heather Sweeney Design case scripts and the screenshot of Question G & J outcomes only

2)     Screenshot the question 3 result of Lab Exercise 2

Email the results in a Word file (filename: “3348-Ex3-lastname.docx”) to isqs3358@gmail.com with a subject title “3348-Ex3–lastname”.

Assignment 5 due 3/10, Thursday before 11:59p

pp222-232 (7e), Heather Sweeney Design case, Question K to R

Email the SQL the screenshots of the SQL scripts for (1) and the answers of (2) to (isqs3358@gmail.com) with a subject title “3348-Assgn5–lastname”.

4

Lab Exercise 2, due 2/26, Friday, before 11:59p

SQL Scripting

1.     Write SQL code to create two tables

PLAYER(PlayerID, Name, Age, Occupation)

TEAM(TeamNum, PlayerID, TeamName)

2.     Write SQL code to populate the tables

PLAYER table

(‘P001’, ‘John’, 20, ‘Student’)

(‘P002’, ‘Tom, 25, ‘Staff’)

(‘P003’, ‘Peter, 22, ‘Student’)

TEAM table

(1, ‘P001’, ‘Blue’)

(1, ‘P002’, ‘Blue’)

(2, ‘P001’, ‘Red)

(2, ‘P003’, ‘Red)

3.     Set constraint of foreign key for TEAM-PLAYER relationship

Email the results in a Word file (filename: “3348-Ex2-lastname.docx”) to isqs3358@gmail.com with a subject title “3348-Ex2–lastname”.

Assignment 4, due 2/29, Monday before noon

(1) pp222-232 (7e), Heather Sweeney Design case

Question A to J

(2) pp253-254 (6e) Exercise 4.28 to 4.32, or pp281 (7e), Exercise 4.29 to 4.33.

 

Email the SQL codes and the screenshots of the database (isqs3358@gmail.com) with a subject title “3348-Assgn4–lastname”.

3

Lab Exercise 1, due 2/19, Friday, before 11:59p

1.     Create WPC database using the codes in network drive’s folder

~\ISQS3348\Exercises\DBC-e07-WPC Scripts using statements: CREATE, INSERT

2.     Test the scripts in the slides

3.     Using SELECT statement

4.     Assignment 3 questions: pp198-199 (6e) / pp216-218 (7e), Exercise 3.52 to 3.55

Submissions:

1)     Screenshot database table list with one populated table in question 1

2)     Screenshot database table list in Assignment 3’s questions

3)     Present the query results from 3.55 and 3.56

Email the results in a Word file (filename: “3348-Ex1-lastname.docx”) to isqs3358@gmail.com with a subject title “3348-Ex1–lastname”.

 

Assignment 3, due 2/19, Friday before 11:59p

pp198-199 (6e) / pp216-217 (7e), Exercise 3.57 to 3.61;

Email the SQL codes and the screenshots of the database (isqs3358@gmail.com) with a subject title “3348-Assgn3–lastname”.

 

2

Lab Exercise 0, due 2/13

Create a database with three tables: (Adviser, Student, Course), screenshot one page sent by email to isqs3358@gmail.com with a subject title “3348-Ex0–lastname”

Assignment 2, due 2/10, Wednesday, before 11:59p

(1) pp99-100 (6e) / pp108-109 (7e), Exercise 2.38 to 2.42;

(2) pp105-106 (6e) / pp114-115 (7e), Garden Glory Project Questions (you may use the tables in Assn1 keys).

Either hardcopy or e-copy by email (isqs3358@gmail.com) with a subject title “3348-Assgn2–lastname”.

 

1

 

Assignment 1, due 2/3, Wednesday, before class meeting (Downloadable here)

(1) pp53-54 (6e) / pp56-57 (7e), Exercise 1.30 to 1.32 (7e), or 1.31 to 1.33 (6e); 

(2) pp56-57 (6e) / p60 (7e), Garden Glory Project Questions.

Either hardcopy or e-copy by email (sent to isqs3358@gmail.com).

 

 

 

------------+-----------+-----------

Exercise 2, due 2/22

TBD

------------+-----------+-----------

Take Home Assignment 2

------------+-----------+-----------