INLS 523_003

Database Systems I – Fall 2018

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: Click here to view or schedule an office hours meeting
Textbook: Elmasri & Navathe, Fundamentals of Database Systems, Seventh Edition, Addison-Wesley
   (the Sixth edition is okay and used copies are okay)
Policies: inls523_f18_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 21-Aug Introduction EN6 Ch1    
2 23-Aug Database Concepts EN6 Ch2    
3 28-Aug Modeling and ER EN6 Ch7
(EN7 Ch3)
   
4 30-Aug Modeling and ER      
5 4-Sep ER Exercises   H1  
6 6-Sep Enhanced ER EN6 Ch8
(EN7 Ch4)
   
7 11-Sep Enhanced ER      
8 13-Sep Relational Concepts EN6 Ch3
(EN7 Ch5)
   
9 18-Sep Class Exercise     H1
10 20-Sep Mapping handout EN6 Ch9
(EN7 Ch9)
   
11 25-Sep ER to Relational Mapping      
12 27-Sep SQL DDL      
13 2-Oct Install MySQLWorkbench
SQL DDL/ACME Handout
EN6 Ch4
(EN Ch6)
   
14 4-Oct SQL EN6 Ch4    
15 9-Oct SQL      
16 11-Oct Midterm review      
17 16-Oct MID-TERM EXAM      
18 18-Oct FALL BREAK      
19 23-Oct SQL      
20 25-Oct SQL      
21 30-Oct TBA      
22 1-Nov LibraryDB queries      
23 6-Nov Advanced SQL      
24 8-Nov SQL Example      
25 13-Nov Relational Algebra EN6 Ch6    
26 15-Nov Relational Algebra      
27 20-Nov Functional Dependencies EN6 Ch15    
28 22-Nov THANKSGIVING BREAK      
29 27-Nov Normalization Handout      
30 29-Nov Normalization      
31 4-Dec LAST CLASS PERIOD: Review      
  11-Dec FINAL EXAM   Tue, Dec 11, 8:00am-10:00am
Manning 01