INLS 523_001 – Database Systems I
Fall 2013

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: Peabody Hall, room 8: Tuesdays and Thursdays, 9:30am - 10:45am
Instructor: Rob Capra, r<lastname> at unc dot edu
Office hours: Manning 210: Wednesdays, 1:30pm-2:30pm, Thursdays, 11:00am-12noon, and by appointment
Prerequisites: INLS 261 or INLS 461
Textbook: Elmasri & Navathe
Fundamentals of Database Systems, Sixth Edition, Addison-Weley
Policies: inls523_fall2013_coursepolicies.pdf
Schedule: The following schedule is subject to change:
(in the Readings below, EN6 denotes a reading in Elmasri Nathave, 6th edition)

Lecture Date Topic(s) Readings Assigned Due
1 20-Aug Introduction EN6 Ch1    
2 22-Aug Database Concepts EN6 Ch2 H0  
3 27-Aug Modeling and ER EN6 Ch7   H0
4 29-Aug Modeling and ER
ER exercises
  H1 ER  
5 03-Sept Modeling and ER      
6 05-Sept Enhanced ER EN6 Ch8    
7 10-Sept Enhanced ER     H1 ER
8 12-Sept Relational Concepts EN6 Ch3 H2 RelConcepts  
9 17-Sept Relational Concepts
Ex: Constraints
10 19-Sept ER to Relational Mapping
Mapping handout
EN6 Ch9    
11 24-Sept ER to Relational Mapping   H3 Mapping H2 RelConcepts
12 26-Sept SQL DDL
ACME Handout
13 01-Oct SQL EN6 Ch4    
14 03-Oct No Class     H3 Mapping
15 08-Oct SQL EN6 Ch4    
16 10-Oct SQL - Library DB   H4 SQL  
17 15-Oct SQL      
18 17-Oct FALL BREAK -- no class      
19 22-Oct SQL     H4 SQL
20 24-Oct SQL
Review for mid-term exam
21 29-Oct Mid-Term Exam      
22 31-Oct NO CLASS   H5 AdvSQL  
23 05-Nov Advanced SQL      
24 07-Nov Advanced SQL      
25 12-Nov Advanced SQL EN6 Ch6    
26 14-Nov More SQL Practice   DB Project  
27 19-Nov Functional Dependencies EN6 Ch15 H6 FD/Norm H5 AdvSQL
28 21-Nov Normalization
Normalization Handout
EN6 Ch15    
29 26-Nov Normalization      
30 28-Nov Thanksgiving break -- no class      
31 03-Dec LAST CLASS PERIOD: Review     H6 FD/Norm
  05-Dec No class     DB Project
  10-Dec, 8:00am FINAL EXAM