CSIS3310  Spring/2008 Assignments

 

Assignment 1  -  Introduction   (due January 14) 

 

Assignment 2  -   Lab Interactive queries SQL  (due January 28)   

 

Group Assignment - Project Deliverable # 1 – Executive Summary (due January 30)

 

Assignment 3  -  Lab Interactive queries SQL, Inserts, Updates, Deletes, Alter Table   (due - February 2) 

 

Assignment 4 -  Lab  MS-Access  (due February 11)

 

Assignment # 5 – Lab on MS-Access/Oracle (ODBC)  (due February 11) 

 

Assignment # 6 – Database Design - Normalization Exercises (due February 18) 

 

Assignment # 7 – Database Design - Normalization and Convert Scenarios to E-R  (due February 25) 

 

Group Assignment - Project Deliverable # 2 – E-R Diagram  (due February 25)

 

Assignment #  8 -  Comment on two E-R Diagrams that were posted. This is an individual assignment (due March 3)                                                        

Assignment # 9 – Database Design – Convert E-R Diagrams to Tables (due March 5)

 

Group Assignment - Project Deliverable # 3  - Relational Schema (due March 7)

 

Group Assignment - Project Deliverable # 4 – DD, CRUD matrix, Forms (due March 17)

               

Assignment # 10 – Lab on Triggers  (due March 31)

 

Assignment # 11 – Performance – Post a summary of an article on  (Moodle) Database Performance by April 2nd and comment on At least one article posted by one of your classmates by April 5th.

 

Assignment # 12 – Security - Post a summary of an article  (Moodle) Database Security by April 7th and comment on At least one article posted by one of your classmates by April 9th.

 

Assignment # 13 – Do walkthrough Visual Studios .NET walkthrough  Connecting to Data in a Database in both SQL server and MS-Access. submit a snapshot of your final screen with the data on it. (due April 11)

 

Assingment # 14 – Lab on JDBC. (due April 14)

 

Assignment # 15 – Lab on Transferring Data (optional) (due April 20)

 

Assignment # 16 – Reading XML Data into a Dataset (optional) (due April 20)

 

Test # 3 – due April 23  (note that test 1, 2 and the final are in class, but test # 3 is a take home).

 

Assignment # 17 – Ethics: Describe the most important thing that you learned about  Ethics related to Computer Science/Databases (1 paragraph). Post your summary by April 25th and comment in at least one by April 28th.

 

Group Assignment  - Project deliverable # 5 – FINAL VERSION (due April  28)