INLS 523_001 – Database Systems I
Spring 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: Manning 307: Tuesdays and Thursdays, 12:30pm - 1:45pm
Instructor: Rob Capra, r<lastname> at unc dot edu
Office hours: Manning 210: Tuesdays, 4:00-5:30pm, Thursdays, 2:00-3:30pm, and by appointment
Prerequisites: INLS 261 or INLS 461
TeachAsst: Emily Vardell
Textbook: Elmasri & Navathe
Fundamentals of Database Systems, Sixth Edition, Addison-Weley
Policies: inls523_sp2013_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 10-Jan Introduction EN6 Ch1    
2 15-Jan Database Concepts EN6 Ch2 H0  
3 17-Jan Modeling and ER EN6 Ch7   H0
4 22-Jan Modeling and ER   H1 ER  
5 24-Jan Modeling and ER EN6 Ch8 P1 Requirements  
6 29-Jan Enhanced ER      
7 31-Jan Enhanced ER     H1 ER
8 05-Feb Relational Concepts EN6 Ch3 H2 RelConcepts P1 Requirements
9 07-Feb Relational Concepts - Integrity Constraints      
10 12-Feb Relational Concepts - Integrity Constraints      
11 14-Feb ER to Relational Mapping EN6 Ch9 H3 Mapping H2 RelConcepts
12 19-Feb ER to Relational Mapping      
13 21-Feb SQL DDL
EN6 Ch4    
14 26-Feb No Class     H3 Mapping
15 28-Feb SQL EN6 Ch4    
16 05-Mar SQL      
17 07-Mar MID-TERM EXAM      
18 12-Mar SPRING BREAK      
19 14-Mar SPRING BREAK      
20 19-Mar SQL
ACME handout
  H4 SQL
P2 ER & Schema
21 21-Mar SQL      
22 26-Mar SQL      
23 28-Mar SQL Examples (LibraryDB on Sakai) EN6 Ch5 H5 AdvSQL H4 SQL
24 02-Apr SQL Examples (LibraryDB on Sakai)      
25 04-Apr SQL Examples (LibraryDB on Sakai)     P2 ER & Schema
26 09-Apr Relational Algebra EN6 Ch6    
27 11-Apr Functional Dependencies EN6 Ch15 H6 FD/Norm/RelAlg H5 AdvSQL
28 16-Apr Normalization
Normalization Handout
  P3 Implementation  
29 18-Apr Normalization      
30 23-Apr Normalization / Looking Ahead      
31 25-Apr LAST CLASS PERIOD: Review     H6 FD/Norm/RelAlg
  30-Apr NO CLASS     P3 Implementation
12:00pm (noon), Manning 307