website paiken:classes

INFO 610 - Analysis and Design of Database Systems

Documents Collection Acknowledgement

Much of this material was developed and compiled by the Summer 2007 INFO691 class who spent that semester determining a balance between theory and practice - many thanks for your hard work!

Week Organizational Theme
Elmasri & Navathe
Adelman
Other
01
Organizational Data Management Concepts

Measuring Data Management Practice Maturity | EDM Framework
02
Data Governance - Data Program Coordination
Ch01 - Databases and Database Users
Ch01 - Introduction
Data Governance Maturity Model | EDM Data Pgm Coord
03
Data Governance - Organizational Data Integration

Ch13 - Disk Storage, Basic File Structures, and Hashing

Appendix C - Network Data Model

Appendix D - Hierarchical Data Model

Ch05 - Relational Data Model and Relational Database Constraints

Ch02 - Data Integration

Ch06 - Organizational Roles and Responsibilities

Data Governance - Why it matters to the business | EDM Ent Data Int

Supplemental - Data Governance Institute Website http://www.datagovernance.com | Six Steps to Data Governance Success

Special Topic - counts as one assignment

04
Data Governance - Data Stewardship

Ch03 - Data Modeling Using the Entity-Relationship Model

Ch04 - Enhanced Entity-Relationship and UML Modeling

Ch08 - SQL-99: Schema Definition, Constraints, Queries, and Views

Ch04 - Metadata

Ch05 - Data Modeling

Data Stewardship:  Finally Process for Achieving Data Integrity | The Case for Data Stewardship | EDM Stewardship

Assignment #2 reading FBI's Upgrade that Wasn't - place in digitial drop box by begining of class 5

Supplemental - Improving Data Quality in Practice: A Case Study in the Italian Public Administration | Cornell University Policy Library -- Policy 4.12 - Data Stewardship And Custodianship

05
Data Security Management
Ch23 - Database Security
Ch08 - Security and Privacy of Data

Security in Computing: CH06 Database and Data Mining Security

CMU's Data and Computer Security Policy

06
Data Support Operations
Ch19 - Database Recover Techniques
Data Support Operations
07
Data Architecture, Analysis, Design
Ch02 - Database System Concepts and Architecture
Ch11 - Business Value of Data and ROI
Zachman Framework | Core Exam (take home)
08
Data Quality Engineering
n/a
Ch03 - Data Quality
Supplemental - Data Definition Quality
09
Data Development (Part 1)
Ch07 - Relational Database Design

Ch09 - SQL Programming

Ch09 - DBMS Selection

Metadata Reqquired - What Every CIO Needs to Know About Metadata | What Every Technical Communicator Should Know About Metadata | Understanding Metadata | EDM Funct Data Dev

10
Data Development (Part 2)

Ch10 - Functional Dependencies and Normalization for Relational Databases

Ch11 - Relational Database Design Algorithms and Further Dependencies

Ch12 - Practical Database Design Methodology and Use of UML Diagrams

Ch16 - Physiclal Database Design and Tuning

Ch07 - Performance
Metadata Optional - Meta Meta Data Data | Questions Meta Data Can Answer | Selecting the “Right” Meta Data to Manage

Assignment #? - Metacrap: Putting the Torch to Seven Straw-men of the Meta-Utopia

11
Metadata Requirements
Ch26 - Internet Databases and XML
12
Document, Record & Content Management Requirements
n/a
Ch11 - Strategies for Managing Unstructured Data
13
Warehousing Requirements
Ch29 - Overview of Data Warehousing and OLAP
Ch10 - Business Intelligence
14
Reference & Master Data Management Requirements
n/a

15
Special Topics

This page and all web site contents were last updated and are copyright
8/9/07 and previous years by Peter Aiken - all rights reserved.