INLS 523_001

Database Systems I – Fall 2017

Description: This course will introduce the basic concepts and applications of relational database management systems, including semantic modeling and relational database theory. Topics include: user requirements and specifications, semantic data modeling relational model, SQL, normalization and data quality, relation topics and emerging technologies.
Room/Time: Manning 001: Tuesdays and Thursdays, 9:30am - 10:45am
Office hours: Tuesdays 11:00-11:45am; Thursdays 1-2pm
Textbook: Elmasri & Navathe, Fundamentals of Database Systems, Seventh Edition, Addison-Wesley
   (the Sixth edition is okay and used copies are okay)
Policies: inls523_f17_coursepolicies.pdf

Schedule

The following schedule is subject to change. In the Readings below, EN6 denotes a reading in Elmasri & Navathe, 6th edition. Chapters mappings for the 7th edition will be posted at a later date. All readings should be done prior to class on the date indicated.

Lecture Date Topic(s) Readings Assigned Due
1 22-Aug Introduction EN6 Ch1    
2 24-Aug Database Concepts EN6 Ch2 H0  
3 29-Aug Modeling and ER EN6 Ch7
(EN7 Ch3)
  H0
4 31-Aug Modeling and ER   H1 ER  
5 5-Sep ER Exercises      
6 7-Sep Enhanced ER EN6 Ch8
(EN7 Ch4)
   
7 12-Sep Enhanced ER      
8 14-Sep Relational Concepts EN6 Ch3
(EN7 Ch5)
H2 RelConcepts H1 ER
9 19-Sep Class Exercise      
10 21-Sep Mapping handout EN6 Ch9
(EN7 Ch9)
   
11 26-Sep ER to Relational Mapping     H2 RelConcepts
12 28-Sep SQL DDL   H3 Mapping  
13 3-Oct Install MySQLWorkbench
SQL DDL/ACME Handout
EN6 Ch4
(EN Ch6)
   
14 5-Oct SQL EN6 Ch4    
15 10-Oct SQL
Review for midterm
    H3 Mapping
16 12-Oct NO CLASS – UNIV DAY      
17 17-Oct MID-TERM EXAM      
18 19-Oct FALL BREAK      
19 24-Oct SQL      
20 26-Oct SQL      
21 31-Oct TBA   H4 SQL  
22 2-Nov LibraryDB queries      
23 7-Nov Advanced SQL      
24 9-Nov SQL Example      
25 14-Nov Relational Algebra EN6 Ch6 DB Project  
26 16-Nov Relational Algebra     H4
27 21-Nov Functional Dependencies EN6 Ch15    
28 23-Nov THANKSGIVING BREAK      
29 28-Nov Normalization Handout   H5 FD/Norm/RelAlg  
30 30-Nov Normalization      
31 5-Dec LAST CLASS PERIOD: Review     DB Project
H5 FD/Norm/RelAlg
  TBA FINAL EXAM   TBA