CmpE 226 – Weekly Schedule – Fall 2007CmpE 226 – Weekly Schedule – Fall 2007- Four major areas:Database Design Relational DB Current & Hot TrendsMerging TrendsFact Finding Techniques (1 ½ )Relational Algebra (½) Infinite Relational DB ½Web Technology & DB (½)ERM (1) SQL: Manipulation (1)Constraints DB ½XML (½)Traditional Class Diagram (1 ½)SQL: Data Definition (1)Spatiotemporal 1½Data Warehousing Concepts and Design (1)Stable Class Diagram (2 ½) – Reading onlySQL: Query Example (½)Visualization & Animation (1 ½) Data Mining (1)Normalization ( ½) Special topics (TBD): Transaction Management ½ (5 requests) , Distributed DBMS 1 (15 requests), Query Optimization ½ , Spatiotemporal DB Applications 1, DB Security ½ - Please note, this file will be updated periodically and must be checked weekly. W#Topic & Reading Materials Turn-in1 - Greensheet- Introduction Game- Submission Guidelines- General Information- Lecture 1: Infinite Relational Database (.ppt)- Article: Paragon Corporation. What is a database and why do we have them? 2003. (.doc)http://www.paragoncorporation.com/ArticleDetail.aspx?ArticleID=20 2- Lecture 2: Data Modeling Using Entity-Relationship Model (.ppt)- Weekly Schedule – This File- Due Dates- Tutorial: Entity-Relationship Modeling Technique Notes (.doc)- Article: Lansdale System. Entity Relationship Models (.pdf)- Article: Understanding Entity Relationship Diagrams (.htm)- Tutorial: Developing Entity Relationship Diagrams (.htm)- Practice ProblemsSeptember 05, 2007 is the last dayof drop courses3 - Class Diagrams (.ppt)- Notes: J.W. Schmidt. Class Diagrams in Analysis (.pdf)- Talk about team project problem stmt- Class Diagrams – Relationships (.ppt)September 12, 2007 is the last dayto add courses- Examples (.ppt)- Talk About: Practice Problems- Submit your contact info- Submit your team informationSept 15th, 2007 by midnightSept 15th, 2007 by midnight4 - Sample of Class Diagrams (.ppt)- Compare ERDs and Class Diagrams- Tips and Heuristics- Practice Problems- Constraint Databases (.ppt)- Team Problem StatementIteration- Finalizing the Course Website5 - Normalization (.ppt)- Steps in Normalizing Databases (.doc)- Rules for Normalization (.doc)- Modeling for Normalizing (.doc)- Normalization: Example 0 (.doc)- Normalization: Example 1 (.doc)- Normalization: Example 2 (.doc)- Normalization: Example 3 (.doc)- Normalization: Example 4 (.doc)- Normalization: Example 5 (.doc)- Solution: practical problems (PP1)- Team Problem Statement Submission- Signup for an Essay6 - Relational Algebra & SQL (.ppt)- Structured Query Language (SQL) (.ppt)- Notes on RA (.doc)- Notes on SQL (.doc)- Solution: practical problems (PP2 & PP3)7 - Continue previous lecture- RA and SQL Examples (.doc)- Solution: practical problems(PP4, PP5, & PP6)8 - Constraints Database - Solution: practical problems(PP7 & PP8)- First Project Submission- First Exam Overview9 - Spatiotemporal Database- First Exam- Solution: practical problems(PP7 & PP8)- First Exam10 - Spring Recess – No Class - NO CLASS11 - Continue previous lecture - Data Visualization - Data Animation- Solution: practical problems(PP9 & PP10)12 - Web Technology- XML (.ppt)- On Spatial Database Integration (.doc)- XML and Database (.doc)- XML Structure for Existing Databases (.doc)- XML: Map DTD to Databases (.doc)- Exploration of XML in Databases (.doc)- Solution: practical problems (PP11 & PP12)- Project #2 Submission13 - Data Warehousing14 - Data Mining - Solution: practical problems(PP13 & PP14)- Second Exam Overview15 - Visualization & Animation- Security- Project #3 Submission- Essay Submission- Second Exam16 - Second Exam
View Full Document