Docstoc

CmpE 226 – Weekly Schedule – Spring 2006  Three major areas DB Issues DB Topics Current Merging Trends Normalization ½

Document Sample
CmpE 226 – Weekly Schedule – Spring 2006  Three major areas DB Issues DB Topics Current Merging Trends Normalization ½ Powered By Docstoc
					                    CmpE 226 – Weekly Schedule – Spring 2006
        Three major areas:

DB Issues                            DB Topics        Current & Merging Trends
Normalization ½                      Introduction 1   Constraints DB 1
Security ½                           ERD 1            Spatio temporal DB 1
Query Processing ½                   Class Diagram 1 ½XML ½
Programmatic SQL ½                   RA 1             Web Technology 1
                                     SQL 2 ½          Data Warehouse
                                                      Concepts/Design 1
Special topics (TBD): Transaction Management ½ (5 requests) , Distributed DBMS 1
(15 requests), Query Optimization ½


        Please note, this file will be updated periodically and must be checked
         weekly.

W#                  Topic & Reading Materials                               Turn-in
1           Greensheet
            Introduction Game
            Lecture 1: Infinite Relational Database (.ppt)
            Article: Paragon Corporation. What is a
             database and why do we have them?
             2003. (.doc)
2           Lecture 2: Data Modeling Using Entity-
             Relationship Model (.ppt)
            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 Problems
3           Class Diagrams (.ppt)
            Notes: J.W. Schmidt. Class Diagrams in
             Analysis (.pdf)
            Class Diagrams – Relationships (.ppt)
            Examples (.ppt)
            Practice Problems
4           Sample of Class Diagrams (.ppt)                       Solution: practical problems
            Compare ERDs and Class Diagrams                        (PP1)
            Tips and Heuristics                                   Project #1
            Practice Problems                                     Finalizing the Course Website
            Constraint Databases (.ppt)
5       Relational Algebra & SQL (.ppt)
        Structured Query Language (SQL) (.ppt)
        Notes on RA (.doc)
        Notes on SQL (.doc)
6       Continue previous lecture                        Solution: practical problems
        RA and SQL Examples (.doc)                        (PP2, PP3)
                                                          First Exam Overview
7       Normalization (.ppt)                             Solution: practical problems
        Steps in Normalizing Databases (.doc)             (PP4, PP5, PP6)
        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)
        Security
8       Query Processing                                 Solution: practical problems
        Programmatic SQL                                  (PP7)
9       First Exam                                       Project #1
        Continue previous lecture                        First Exam
        Constraint Databases                             Solution: practical problems
                                                           (PP7)
10      Spatiotemporal Databases (.ppt)                  Solution: practical problems
        MLPQ System (.ppt)/MySQL (.ppt)                   (PP9)
11      Object-Oriented Databases (.ppt)                 Solution: practical problems
        Distributed Database                              (PP10)
12      XML (.ppt)                                       Solution: practical problems
        On Spatial Database Integration (.doc)            (PP11)
        XML and Database (.doc)
        XML Structure for Existing Databases (.doc)
        XML: Map DTD to Databases (.doc)
        Exploration of XML in Databases (.doc)
13      Web Technology                                   Project #2
                                                          Solution: practical problems
                                                           (PP12)
                                                          Exam Overview
14      Second Exam                                      Second Exam
        Data Warehouse                                   Solution: practical problems
        Data Mining                                       (PP13 & PP14)
15      Transaction Management or                        Final lecture and tips
        Query Optimization
16      Projects’ Submissions and Demos                  Project #2 -- Demo
                                                          Project #3 -- Demo

				
DOCUMENT INFO
Description: Ppt on Database Tutorial document sample