INLS 523_001 – Database Systems I
Spring 2015

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 307: Tuesdays and Thursdays, 11:00am - 12:15pm
Instructor: Rob Capra, r<lastname> at unc dot edu
Office hours: Manning 210: Tuesdays, 2:00-3:00pm, and by appointment
Prerequisites: INLS 261 or INLS 461
Textbook: Elmasri & Navathe
Fundamentals of Database Systems, Sixth Edition, Addison-Weley
Policies: inls523_sp15_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 8-Jan Introduction EN6 Ch1    
2 13-Jan Database Concepts EN6 Ch2 H0  
3 15-Jan Modeling and ER EN6 Ch7   H0
4 20-Jan Modeling and ER
ER Exercises
  H1 ER  
5 22-Jan Modeling and ER      
6 27-Jan Enhanced ER EN6 Ch8    
7 29-Jan Enhanced ER      
8 03-Feb Relational Concepts EN6 Ch3 H2 RelConcepts H1 ER
9 05-Feb Relational Concepts
Constraints Handout
10 10-Feb ER to Relational Mapping
Mapping handout
EN6 Ch9    
11 12-Feb ER to Relational Mapping      
12 17-Feb SNOW DAY      
13 19-Feb SQL DDL
MySQL Workbench
ACME Handout
EN6 Ch4    
14 24-Feb SQL DDL EN6 Ch4 H3 Mapping  
15 26-Feb SNOW DAY      
16 03-Mar SQL DML     H3 Mapping
17 05-Mar MID-TERM EXAM      
18 10-Mar SPRING BREAK      
19 12-Mar SPRING BREAK      
20 17-Mar SQL DML EN6 Ch6    
21 19-Mar SQL DML      
22 24-Mar LibraryDB schema/data
LibraryDB queries
  H4 SQL  
23 26-Mar Advanced SQL      
24 31-Mar Advanced SQL      
25 02-Apr Relational Algebra   DB Project  
26 07-Apr Functional Dependencies EN6 Ch15   H4
27 09-Apr Normalization
Normalization Handout
EN6 Ch15 H5 FD/Norm/RelAlg  
28 14-Apr Normalization      
29 16-Apr More SQL exercises      
30 21-Apr Advanced queries/More joins     DB Project
31 23-Apr LAST CLASS PERIOD: Review     H5 FD/Norm/RelAlg
  28-Apr FINAL EXAM April 28, 12noon