| 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
|
| Instructor: |
Rob Capra, r<lastname> at unc dot edu
|
| Office hours: |
Manning 210: Tuesdays, 1:00-2:00pm, and by appointment
|
| Textbook: |
Elmasri & Navathe
Fundamentals of Database Systems, Sixth Edition, Addison-Weley
|
| Policies: |
inls523_f16_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 |
23-Aug |
Introduction |
EN6 Ch1 |
|
|
| 2 |
25-Aug |
Database Concepts |
EN6 Ch2 |
H0 |
|
| 3 |
30-Aug |
Modeling and ER |
EN6 Ch7 |
|
H0 |
| 4 |
1-Sep |
Modeling and ER |
|
H1 ER |
|
| 5 |
6-Sep |
ER Exercises |
|
|
|
| 6 |
8-Sep |
Enhanced ER |
EN6 Ch8 |
|
|
| 7 |
13-Sep |
Enhanced ER |
|
|
|
| 8 |
15-Sep |
Relational Concepts |
EN6 Ch3 |
H2 RelConcepts |
H1 ER |
| 9 |
20-Sep |
Class Exercise |
|
|
|
| 10 |
22-Sep |
Mapping handout |
EN6 Ch9 |
|
|
| 11 |
27-Sep |
ER to Relational Mapping |
|
|
H2 RelConcepts |
| 12 |
29-Sep |
SQL DDL |
|
H3 Mapping |
|
| 13 |
4-Oct |
SQL DDL/ACME Handout |
EN6 Ch4 |
|
|
| 14 |
6-Oct |
Install MySQLWorkbench
Review for midterm |
EN6 Ch4 |
|
|
| 15 |
11-Oct |
NO CLASS – UNIV DAY |
|
|
H3 Mapping |
| 16 |
13-Oct |
SQL |
|
|
|
| 17 |
18-Oct |
MID-TERM EXAM |
|
|
|
| 18 |
20-Oct |
FALL BREAK |
|
|
|
| 19 |
25-Oct |
SQL |
|
|
|
| 20 |
27-Oct |
SQL |
|
|
|
| 21 |
1-Nov |
LibraryDB queries |
|
H4 SQL |
|
| 22 |
3-Nov |
Advanced SQL |
|
|
|
| 23 |
8-Nov |
Advanced SQL |
|
|
|
| 24 |
10-Nov |
SQL Example |
|
|
|
| 25 |
15-Nov |
Relational Algebra |
EN6 Ch6 |
DB Project |
|
| 26 |
17-Nov |
Relational Algebra |
|
|
H4 |
| 27 |
22-Nov |
Functional Dependencies |
EN6 Ch15 |
|
|
| 28 |
24-Nov |
THANKSGIVING BREAK |
|
|
|
| 29 |
29-Nov |
Normalization Handout |
|
H5 FD/Norm/RelAlg |
|
| 30 |
1-Dec |
Normalization |
|
|
|
| 31 |
6-Dec |
LAST CLASS PERIOD: Review |
|
|
DB Project
H5 FD/Norm/RelAlg |
| |
13-Dec |
FINAL EXAM |
|
8:00am, Tues, Dec 13 |
|
|