University of Cincinnati – Fall 2014 IS7032 – Data Modeling and Database Design II Section 001; Meeting times: Tu 6:00pm-9:50pm Instructor: Andrew Harrison Office Hours: Tuesday/Thursday 11am-3pm Room: Lindner 107 Course Objectives: An in-depth examination of the principles of data modeling and database design. Students will need to demonstrate a deep understanding of relational database features and competency in transferring business rules to conceptual and logical schemas, and ultimately a physical database design. Prerequisites: Graduate student in the Lindner College of Business or permission from the instructor. Text Book: Data Modeling & Database Design – 2nd Edition by N. S. Umanath & R. W. Scamell, Cengage Learning, 2015. (ISBN 978-1-285-08525-8) Course Details:     Students are expected to come prepared for every class period by reading the assigned reading material ahead of time. Class lectures will focus on highlighting the textbook topics with additional insight using supplemental material. The course involves hands-on development activities using MS/Visio & Oracle database Class participation (and attendance) is critical to learning - absence for a class does not relieve a student from responsibility for the learning the subject matter or completing the assignments. Due dates will remain as listed for all assignments unless otherwise noted by the instructor. Grading Details:      Students are expected to take the tests as scheduled. Make-up tests will not be given unless requests are made early in the quarter and under only extraordinary circumstances. Assignments will be due on the date/time specified. Late submissions will not be accepted. All assignments are due at the start of the class session on the due date and should be turned in directly to the instructor. All submissions must be on standard (8.5 x 11) paper, stapled on top left corner; the name(s) of the student(s) should appear on the first page. Please don’t use folders, binders, etc. Assignment Percent of Grade Quiz 1 15% Quiz 2 15% Assignments (6 total) 30% Exam 40% *Quiz and Test dates may be subject to change Due Date 10/28/14 11/18/14 1 per week (Tentative) 12/2/14 Course Schedule: Date Tu 10/21 Session 1 Topic Relational algebra and functional dependencies Normalization and dependency preservation Normalization summary Multi-value dependencies and 4NF Join dependency and 5NF Information preserving mapping Veterans’ Day (No Class) Modeling Complex Relationships Reading Chapter 6-8 Assignment Due Tu 10/28 2 Chapters 8 & 9 A1: Deriving a set of functional dependencies A2: Conceptual data modeling exercise Tu 11/4 3 Tu 11/11 Tu 11/18 4 5 Tu 11/25 6 DQL/SQL Syntax Chapters 10 & 12 Tu 12/2 7 IS7032 Exam Ch. 5-10, 12 Chapters 9 & 4 Chapter 5 *Assignment dates may be subject to change A3: Informationpreserving mapping A4: Modeling complex relationships A5: SQL - Creating Tables A6: SQL - Queries with Joins