CSC 150 Database Applications and Design Using SQL

Spring 2010

Assignments


I hear and I forget, I see and I remember, I do and I understand

Ancient Chinese Proverb

Connecticut Community Colleges Gateway Community College Student Info System Contact Instructor

Home

Syllabus

Term Project

Please bookmark this page and check it weekly for course updates!

Be aware - the schedule below is tentative and may be changed at the instructor's discretion

All assignments are due at the beginning of class on the date noted.

Use a text editor such as Notepad for SQL statements. Results should be printed out using Access or Oracle

Chief Homework Supervisor
She's tough, she's loud, and she likes to chew!!




Week One - January 28, 2010

Reading: Chapter 1 (skim) & 2
Introduction to Relational Databases - http://www.databasejournal.com/sqletc/article.php/1469521/Introduction-to-Relational-Databases.htm

Written: If you were designing a database for your instructor to use, what would be the data items you would include? What is the datatype of each data item?
Use a word processing program to answer the above questions. Please be sure to include a header with your name, "Assignment #1", and the date.

Due date: February 4, 2010.

Lecture One - Updated


Week Two - February 4, 2010

Reading: Chapter 3
Database Normalization - http://www.databasejournal.com/sqletc/article.php/26861_1474411_1/Database-Normalization.htm or in your handout from last class

Written: Check Your Understanding pgs. 41, 44, 48, 50, 56, 58, 60, 63, 65, 68, 71, 74, 76, 78

Using the data items from last week's assignment, create the tables needed to hold your data items.

Due date: February 11, 2010

SQL Class Examples - Chapter2SQLExamples.txt


Week Three - February 11, 2010

Reading: Chapter 4
Written: Check Your Understanding pgs. 87, 90, 95, 101, 105, 124

Using the tables you created from last week's assignment, see what changes you can make to normalize your data.

Due date: February 18, 2010

SQL Class Examples - Chapter3SQLExamples.txt


Week Four - February 18, 2010

Reading: None - Study for test covering Chapters 1-4
Written: Check Your Understanding pgs.139, 141, 142, 144, 145, 154, 159, 160, 166, 169

**** Term Project Topic Due ****

Due date: February 25, 2010

SQL Class Examples - Chapter4SQLExamples.txt


Week Five - February 25, 2010

Test #1

Reading: Chapter 5 - pgs, 201-206, Chapter 6
Written: Any missing Assignments from Chapters 1 - 4

Due date: March 4, 2010


Week Six- March 4, 2010

Reading: Chapter 7
Written: Check Your Understanding pgs. 224, 228, 231, 232, 233, 240, 242

Due date: March 11, 2010

SQL Class Examples - Chapter6SQLExamples.txt


Week Seven - March 11, 2010

Reading: Chapter 8
Foreign Keys - http://www.visualcase.com/kbase/database_basics_-_foreign_keys.htm
Primary and Foreign Key Constraints - http://www.databasedev.co.uk/primary_foreign_key_constraints.html
Written: Check Your Understanding pgs. 251, 254, 262, 264, 269, 274

Extra Credit : Task pgs. 278-279

Due date: March 18, 2010

SQL Class Examples - Chapter7SQLExamples.txt


Week Eight - March 18, 2010

Reading: Chapter 9
Written: Check Your Understanding pgs. 285, 286, 287, 289, 292, 295, 296, 297, 299, 302, 308

**** Term Project Table Designs Due ****

Looking at the Database Design Process

Due date: April 1, 2010

SQL Class Examples - Chapter8SQLExamples.txt


March 25, 2010 - No Class - Spring Break


Week Nine - April 1, 2010

Reading: None, study for test #2 covering chapters 5 - 9
Test # 2 Review
Written: Check Your Understanding pgs. 327, 329, 331, 334, 345

Due date: April 8, 2010

SQL Class Examples - Chapter9SQLExamples.txt


Week Ten - April 8, 2010

Test #2

Reading: Chapter 10
Written: Any missing assignments from Chapters 5 - 9

Due date: April 15, 2010


Week Eleven - April 15, 2010

Reading: Chapter 11
Written: Check Your Understanding pgs. 372, 374, 376, 379, 383, 389, 390

Due date: April 22, 2010

SQL Class Examples - Chapter10SQLExamples.txt

1 - Optional Extra Credit (10 points): Using the example on pgs. 393 - 396, find the solution to the following algebraic equation: 2x4 - 54x3 + 23x2 + 564x - 675 = 0 Note: this equation is solvable Due by: May 6

2 - Optional Extra Credit:(10 points) Using the example on pgs. 384 - 387 Create your own calendar that contains the following:

Due by: May 6


Week Twelve - April 22, 2010

Reading: Chapter 12
Written: Check Your Understanding pgs. 406, 408, 411, 413, 421, 427

SQL Class Examples - Chapter11SQLExamples.txt

Due date: April 29, 2010


Week Thirteen - April 29, 2010

Reading: Chapter 13
Written: Check Your Understanding pgs. 441, 447, 454, 462

SQL Class Examples - Chapter12SQLExamples.txt

Due date: May 6, 2010


Week Fourteen - May 6, 2010

Reading: None - Study for Final covering Chapters 1 - 13
Written: Optional Assignment Check Your Understanding pgs. 484, 486, 489, 492, 495, 497, 499, 500, 501, 504, 510, 515

Any missing assignments from Chapters 10 - 13 Due

Take home portion of final distributed

Due date: May 13, 2010


Week Fifteen - May 13, 2010

Final Exam

Written: Term Project Due


Last Updated: 5/1/10