 |
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
|
|
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:
- Covers at least a 60 day period if doing a 5-6 day per week calendar; one year if you are doing a calendar for weekends only
- An additional column large enough to hold what ever you decide the calendar needs to hold
- At least 10 entries in this extra column marking things just as meetings, birthdays, pay days, what every you want to keep track of
- At least one entry being a weekly entry that you use one SQL statement to enter (Hint: use the format to inspect the day of the week)
- All events must be entered using the SQL UPDATE statement
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