ITEC 3335
Database Development
Fall 2019
Tentative Schedule
by K. Yue
The syllabus is tentative. Actual contents and order of coverage may change. There will be around 9 homework assignments, the actual number is subjected to changes.
Date |
Contents |
Notes, Readings and Comments |
| Week #1: 8/26, 28 | Introduction to the course Persistent Data Introduction to Database Systems Introduction to Microsoft Access |
Read Hoffer Chapter 1 and the companion PPTs Additional material: How to be successful in ITEC 3335 Syllabus in Concept Map Introduction to ITEC 3335 Introduction to MS Access |
| Week #2: 9/2, 9/4 | 9/2: Labor Day Holiday Additional material: Critical thinking in CS and DB Database Basics |
Read Hoffer Chapter 1 Additional material: Critical Thinking in IT and DB DB Basics |
| Week #3: 9/9, 9/11 | An introduction to the relational model and SQL. |
Read Hoffer Chapter 4 pp 155-160. Read Hoffer Chapter 6 Processing Single Table (pp. 261-274) Introduction to the relational model and SQL |
| Week #4: 9/16, 9/18 | Additional material: An introduction to Concept Map The relational model An introduction to data modeling |
Additional material: A brief introduction to Concept Map Syllabus in concept maps The Relational Model Additional material: A RDB Relational Example of Concept Map in the context of critical thinking. |
| Week #5: 9/23, 9/25 | ER modeling |
ER Modeling Drawing ER Diagram using Draw.io Read Hoffer Chapter 2 Additional material: ER in Concept Map |
| Week #6: 9/30, 10/2 |
The Extended ER (EER) model Conversion of EER model to the relational model |
Read chapter 3, only the concept of subtyes and subclasses are necessary. Read Hoffer Chapter 4, pp 155-181. Additional Material: Extended ER Modeling Conversion of ER Model to Relation Schema |
| Week #7: 10/7, 10/9 |
10/9: Mid-term Examination More SQL |
An introduction to SQL and MySQL Read Hoffer Chapter 7 pp 289-313. |
| Week #8: 10/14, 10/16 |
More SQL Physical DB Design |
Read Hoffer Chapter 4 pp.182-205 Physical DB Design Read Hoffer Chapter 8, general 2-tier and 3-tier architecture only. |
| Week #9: 10/21, 10/23 | Logical database design Normalization Theory |
Introduction to Database Design Introduction to Normalization Theory Read Hoffer Chapter 4 and 5 |
| Week #10: 10/28, 10/30 | Normalization Theory |
Read Hoffer Chapter 4 and 5 |
| Week #11: 11/4, 11/6 | Python Review |
Introduction to Python Read Hoffer Chapter 8 |
| Week #12: 11/11, 11/13 | Database Application Development in Python |
MySQL programming in Python |
| Week 13: 11/18, 11/20 |
Database Application Development in Python Transaction Management |
Transaction Management |
| Week #14: 11/25, 11/27 | 11/27-29 Thanksgiving Holiday Simple Database Administration |
Simple DB Administration Read Hoffer Chapter 12 |
| Week #15: 12/2, 12/4 | Simple Database Administration Additional Topics |
|
| Week #16: 12/7, 12/9 |
12/9 Review 12/11 Wednesday 1:00 pm: Final Examination |
You can bring an 'information' sheet: A4, print or write both sides, must be prepared by yourself. |