INLS 523_003

Database Systems I – Fall 2018

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
Office hours:	Click here to view or schedule an office hours meeting
Textbook:	Elmasri & Navathe, Fundamentals of Database Systems, Seventh Edition, Addison-Wesley    (the Sixth edition is okay and used copies are okay)
Policies:	inls523_f18_coursepolicies.pdf

---

Schedule

The following schedule is subject to change. In the Readings below, EN6 denotes a reading in Elmasri & Navathe, 6th edition. Chapters mappings for the 7th edition will be posted at a later date. All readings should be done prior to class on the date indicated.

Lecture	Date	Topic(s)	Readings	Assigned	Due
1	21-Aug	Introduction	EN6 Ch1
2	23-Aug	Database Concepts	EN6 Ch2
3	28-Aug	Modeling and ER	EN6 Ch7 (EN7 Ch3)
4	30-Aug	Modeling and ER
5	4-Sep	ER Exercises		H1
6	6-Sep	Enhanced ER	EN6 Ch8 (EN7 Ch4)
7	11-Sep	Enhanced ER
8	13-Sep	Relational Concepts	EN6 Ch3 (EN7 Ch5)
9	18-Sep	Class Exercise			H1
10	20-Sep	Mapping handout	EN6 Ch9 (EN7 Ch9)
11	25-Sep	ER to Relational Mapping
12	27-Sep	SQL DDL
13	2-Oct	SQL DDL/ACME Handout	EN6 Ch4 (EN Ch6)
14	4-Oct	Install MySQLWorkbench SQL	EN6 Ch4
15	9-Oct	SQL
16	11-Oct	Midterm review
17	16-Oct	MID-TERM EXAM
18	18-Oct	FALL BREAK
19	23-Oct	SQL
20	25-Oct	SQL
21	30-Oct	TBA
22	1-Nov	LibraryDB queries
23	6-Nov	Advanced SQL
24	8-Nov	SQL Example
25	13-Nov	Relational Algebra	EN6 Ch6
26	15-Nov	Relational Algebra
27	20-Nov	Functional Dependencies	EN6 Ch15
28	22-Nov	THANKSGIVING BREAK
29	27-Nov	Normalization Handout
30	29-Nov	Normalization
31	4-Dec	LAST CLASS PERIOD: Review
	11-Dec	FINAL EXAM		Tue, Dec 11, 8:00am-10:00am Manning 01