# CSC3032&CSC3031 Database Management 2013

### Labs

1. Lab 1 - Due Sept 18 - Moodle Link
2. Lab 2 - Due Sept 20 - Moodle Link
3. Lab 3 - Due Sept 23 - Moodle Link
4. Lab 4 - Due Oct 2 - Moodle Link
5. Lab 5 - Due Oct 14 - Moodle Link
6. Lab 6 - Due Oct 23 - Moodle Link
7. Lab 7 - Due Oct 30 - Moodle Link
8. Lab 8 - Due Nov 7 - Moodle Link
9. Lab 9 - Due Nov 14 - Moodle Link
10. Lab 10 - Due Nov 21 - Moodle Link
11. Lab 11 - Due Dec 2 - Moodle Link
12. Lab 12 - Due Dec 9 - Moodle Link

### Homework

1. HW 1 - Ch 1 RQ* 1, 2, 3, 4, 7, 15 - Due Sept 9- Moodle Link
2. HW 2 -Ch 1 Henry Books Case: Odd problems. Due Sept 11- Moodle Link
3. HW 3 -Ch 2 Page 69, Premiere Products Exercises: Relational Algebra. 1-7, Due Sept 20 - Moodle Link
4. HW 4 -Ch 3 Page 115, Review Questions 1,3,5,7,9,11,13. Due Sept 23 - Moodle Link
5. HW 5 -Normalization HW 1. Due Oct 30, Moodle Link
6. HW 6 -Normalization HW 2. Due Nov 1 Moodle Link
7. HW 7 -Database Design 1. Due Nov 10 Moodle Link
8. HW 8 -Database Design 2. Due Dec 4 Moodle Link

### Exams

• Exam 1. Chapters 1-4, October 23. Study Guide
• Exam 2. Chapters 5-6, November 18. Study Guide
• Final Exam - Tuesday December 10, 10:00-11:50
• Final Exam covers chapters 1-6 in text, plus materials covered in class.
• Study the previous exam study guides as well.
• FinalSample2013.docx: Sample Final Questions
• FinalSample2013Sol.docx: Final Exam - With Solutions

### Calendar

Sunday Monday Tuesday Wednesday Thursday Friday Saturday September 2013 01 02 03 04 Intro to DBMS, Ch 1 05 06 Ch 2 The Relational Database Model, 07 08 09 Ch 2 The Relational Database Model, HW Ch 1 RQ* 1, 2, 3, 4, 7, 15 10 11 Ch 2 The Relational Database Model, HW Ch 1 Henry Books Case: Odd problems. 12 13 Lab 1- MySQL and Phpmyaddmin, 14 15 16 Ch 3 17 18 Ch 3 19 20 Lab 21 22 23 24 25 26 27 28 29 30

Sunday Monday Tuesday Wednesday Thursday Friday Saturday October 2013 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

Sunday Monday Tuesday Wednesday Thursday Friday Saturday November 2013 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

Sunday Monday Tuesday Wednesday Thursday Friday Saturday December 2013 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

• 4 Sep 2013 - Intro to DBMS, Ch 1
• 6 Sep 2013 - Ch 2 The Relational Database Model,
• 9 Sep 2013 - Ch 2 The Relational Database Model, HW Ch 1 RQ* 1, 2, 3, 4, 7, 15
• 11 Sep 2013 - Ch 2 The Relational Database Model, HW Ch 1 Henry Books Case: Odd problems.
• 13 Sep 2013 - Lab 1- MySQL and Phpmyaddmin,
• 16 Sep 2013 - Ch 3
• 18 Sep 2013 - Ch 3
• 20 Sep 2013 - Lab
• 23 Sep 2013 -
`aleshirejm@mail.mvnu.edu;ayerskd@mail.mvnu.edu;cooperb@mail.mvnu.edu;tfitzge1@mail.mvnu.edu;kadrichjp@mail.mvnu.edu;mcpeakdm@mail.mvnu.edu;motleyar@mail.mvnu.edu;lmullet1@mail.mvnu.edu;norckauer@mail.mvnu.edu;tporter1@mail.mvnu.edu;jradcli2@mail.mvnu.edu;jselle@mail.mvnu.edu;lskon@mail.mvnu.edu`
SelectHWSolutions

*

Topic attachments
I Attachment Action Size Date Who Comment
doc DBMSSyllabus2013.doc manage 55.0 K 2013-09-04 - 15:21 JimSkon Syllabus
docx FinalSample2013.docx manage 228.7 K 2013-12-09 - 13:59 JimSkon Sample Final Questions
docx FinalSample2013Sol.docx manage 228.7 K 2013-12-09 - 14:00 JimSkon Final Exam - With Solutions
pdf Kevs-php-mysql.pdf manage 1008.9 K 2013-11-20 - 04:43 JimSkon Build Database with PHP and MySQL
pdf PHP-MySQLDoc.pdf manage 1560.5 K 2013-11-20 - 04:26 JimSkon PHP Mysql Documentation
pptx ch02_CE.pptx manage 2052.6 K 2013-09-06 - 02:48 JimSkon Chapter 2 Slides
ppt ch03_CE.ppt manage 674.0 K 2013-10-25 - 16:14 JimSkon Chapter 3 Slides
ppt ch04_CE.ppt manage 738.0 K 2013-10-25 - 16:15 JimSkon Chapter 4 Slides
ppt ch05_CE.ppt manage 620.5 K 2013-10-25 - 16:15 JimSkon Chapter 5 Slides
ppt ch06_CE.ppt manage 681.5 K 2013-11-12 - 20:48 JimSkon Chapter 6
ppt chap01Corrected.ppt manage 345.5 K 2013-09-06 - 02:48 JimSkon Chapter 1 Slides
ppt php-intro.ppt manage 3286.5 K 2013-11-20 - 23:49 JimSkon Introduction to PHP
ppt php-mysqli.ppt manage 427.5 K 2013-11-20 - 23:49 JimSkon PHP with Mysql
Topic revision: r49 - 2013-12-09 - JimSkon

TWiki

* Webs

Copyright &© by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback