INLS 523_003 – Database Systems I
Fall 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 001: Tuesdays and Thursdays, 12:30pm - 1:45pm
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_f15_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 18-Aug Introduction EN6 Ch1    
2 20-Aug Database Concepts EN6 Ch2 H0  
3 25-Aug Modeling and ER EN6 Ch7   H0
4 27-Aug Modeling and ER   H1 ER  
5 1-Sep Modeling and ER
ER Exercises
     
6 3-Sep Enhanced ER EN6 Ch8    
7 8-Sep Enhanced ER      
8 10-Sep Relational Concepts EN6 Ch3 H2 RelConcepts H1 ER
9 15-Sep Relational Concepts
Constraints Handout
Class Exercise
     
10 17-Sep ER to Relational Mapping
Mapping handout
EN6 Ch9    
11 22-Sep ER to Relational Mapping     H2 RelConcepts
12 24-Sep SQL DDL   H3 Mapping  
13 29-Sept SQL DDL
MySQL Workbench
ACME Handout
EN6 Ch4    
14 1-Oct SQL DDL
SQL w/answers
EN6 Ch4    
15 6-Oct SQL
ACME SQL Schema
ACME SQL Insert data
    H3 Mapping
16 8-Oct Review      
17 13-Oct MID-TERM EXAM      
18 15-Oct FALL BREAK      
19 20-Oct SQL      
20 22-Oct SQL      
21 27-Oct Advanced SQL
LibraryDB schema/data
LibraryDB queries
  H4 SQL  
22 29-Oct Advanced SQL      
23 3-Nov Advanced SQL      
24 5-Nov SQL Example      
25 10-Nov Relational Algebra EN6 Ch6 DB Project  
26 12-Nov Relational Algebra     H4
27 17-Nov Functional Dependencies EN6 Ch15    
28 19-Nov Normalization
Normalization Handout
  H5 FD/Norm/RelAlg  
29 24-Nov Normalization      
30 26-Nov THANKSGIVING BREAK      
31 1-Dec LAST CLASS PERIOD: Review     DB Project
H5 FD/Norm/RelAlg
  8-Dec FINAL EXAM   Dec 8, 12:00pm