ITIS 5160: Applied Databases

Identification of business database needs; requirements specification; relational database model; SQL; E-R modeling; database design, implementation, and verification; distributed databases; databases replication; object-oriented databases; data warehouses; OLAP; data mining; security of databases; vendor selection; DBMS product comparison; database project management; tools for database development, integration, and transaction control.


Syllabus

Team members Demo time
Nikhita Kunapareddy, Pragathi Velivarthi, and Rohit Purumandla Monday, Dec. 10th, 1:30pm
Chuck Lane, Janice Challis, Tyler Thomas, and Jennifer Anderson Tuesday, Dec. 11th, 11:00am
Arvindraj Nagarajan and Rohit Mahamuni Tuesday, Dec. 11th, 11:30am
Domonique Bynum, Kranti Gayam, and Nate Rooth Wednesday, Dec. 12th, 11:00am
Michael Rosa, David Schoenheit, and Gloria Szilasi Wednesday, Dec. 12th, 11:30am
Rosser, Kimberly; Kennedy, Ryon; and Harwell, Megan Thursday, Dec. 13th, 1:30pm


Week 1: course introduction,     Chapter 1: intro to DBMS,     Big Data Challenges     Bookstore project

Week 2: Chapter 2: ER model,     Chapter 3: relational model    

Week 3: Chapter 3: relational model    

Week 4: Chapter 3: relational model,     Chapter 5: SQL    

Week 5: Chapter 3: relational model,     Chapter 5: SQL    

Week 6: Chapter 5: SQL     More about the project     Example tables for Department     Handbook for SQL     Handbook for PL SQL    

Week 7: Chapter 19: Normalization     review of the contents    

Midterm review: Sample midterm exam     solution  

Midterm exam will be held on Oct 12th, in class.

Week 9: Chapter 19: Normalization    

Week 10: Chapter 19: Normalization     more on project    step by step instruction    
                ojdbc.jar file     servlet-api.jar file     HelloWorld.java file     SampleJDBC.java file     DBServlet.java file     DBServlet.html file    

An example of user-login servlet and then be redirected to different pages based on their user types:
                Login Servlet html   Login Servlet java file   setup instruction  

Week 11: B+ Tree     B+ Tree example    

Week 12: Examples of BCNF     B+ Tree     B+ Tree example    
                Examples of B+ tree: part 1   part 3   part 4   part 6  

Week 13: Examples of BCNF     B+ Tree     B+ Tree example    
                Examples of B+ tree: part 1   part 3   part 4   part 6  

Exampel test cases for the project: Test case series    

Week 15: Data Warehouse     Project Demonstration and Report     Knowledge Points after Midterm