INLS 523_003

Database Systems I – Fall 2019

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_f19_coursepolicies.pdf


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
1 20-Aug Introduction EN6 Ch1
(EN7 Ch1)
2 22-Aug Database Concepts EN6 Ch2
(EN7 Ch2)
3 27-Aug Modeling and ER EN6 Ch7
(EN7 Ch3)
4 29-Aug Modeling and ER  
5 3-Sep ER Exercises  
6 5-Sep Enhanced ER EN6 Ch8
(EN7 Ch4)
7 10-Sep Enhanced ER  
8 12-Sep Relational Concepts EN6 Ch3
(EN7 Ch5)
9 17-Sep Class Exercise  
10 19-Sep Mapping handout EN6 Ch9
(EN7 Ch9)
11 24-Sep ER to Relational Mapping  
12 26-Sep SQL DDL/ACME Handout EN6 Ch4
(EN Ch6)
13 1-Oct NO CLASS  
14 3-Oct Review homework 1  
15 8-Oct Install MySQLWorkbench
16 10-Oct Midterm review  
17 15-Oct MID-TERM EXAM  
18 17-Oct FALL BREAK  
19 22-Oct SQL  
20 24-Oct SQL  
21 29-Oct Example queries  
22 31-Oct Advanced SQL  
23 5-Nov Advanced SQL  
24 7-Nov SQL Example  
25 12-Nov Relational Algebra EN6 Ch6
26 14-Nov Relational Algebra  
27 19-Nov Functional Dependencies EN6 Ch15
28 21-Nov Normalization Handout  
29 26-Nov Normalization  
31 3-Dec LAST CLASS PERIOD: Review  
  10-Dec FINAL EXAM 8:00am, Tues, Dec. 10 (tentative)