Revision as of 21:12, 21 January 2007

30-0000 Data Design

Contact

Teacher: Jeff Meyers

Office: 624 S. Michigan rm 609

Phone: 312-344-7754

Email: jeff@iam.colum.edu

Web Site http://imamp.colum.edu/mediawiki/index.php?Data Design

Description

Programming as problem solving is emphasized, and students are required to code creatively to solve a series of interface related programming challenges they might encounter in HTML and Flash environments. Object-oriented, event-driven emphasis is maintained, including requiring documentation and algorithm planning prior to coding. Students are also required to further their understanding of programming best practices, including coding practices for creating more stable code, error handling and minimizing the risk and effects of malicious user behavior.

Prerequisites

Authoring Interactive Media

Object Oriented Programming

or

C++

Objectives

1. Design and Build normalized relational databases.
2. Understand trade offs between normalization and performance in relational databases
3. Understand SQL language
4. Be able to use various Data Sources and Data Consumers
5. Build well designed user interfaces to Data Sources

Applications and Platforms Covered

ADO.Net

C#

SQL

MSSQL 2005

XML

Visual Studio 2005 Professional and Microsoft SQL Sever 2005 will be provided (software also available via MSDNAA)

Materials

An IAM Account with a website on siam2 will be required. Students will also receive a student database on an IAM SQL server. Access to Microsoft SQL Server Management Studio and VS 2005 is required. This software will be distributed in class and be available in the IAM labs.

Books

Required Books

Beginning Database Design (Wrox Beginning Guides) by Gavin Powell ISBN 0764574906

Beginning ASP.NET 2.0 and Databases by John Kauffman, Bradley Millington ISBN 0471781347

Recommended Books

Programming Microsoft ADO.NET 2.0 Core Reference, by Dino Esposito ISBN 073562206X

SQL Pocket Guide, Second Edition By Jonathan Gennick ISBN 0596526881

Learning C# 2005: Get Started with C# 2.0 and .NET Programming (2nd Edition) by Jesse Liberty and Brian MacDonald ISBN 0596102097

==ATTENDANCE== Attendance and participation in class are required and expected. Three unexcused absences will result in a failing grade for the class.

Two late arrivals equal one absence. You are expected to be in class on time, attendance is taken at the beginning of class. Two absences (even excused absences) may result in a failing grade. Three absences and you FAIL- NO EXCEPTIONS. If an absence cannot be avoided, it must be discussed with your instructor ahead of time. Medical and other emergency leave of absences follow a different policy. Please contact your instructor if such a situation arises.

Departmental Archival Policy

On the final day of class you must submit all work and documentation (including proposals) on two CD-ROMs. You will not pass the course without fulfilling this requirement. The CD will not be returned – create a backup copy for your files.

Class Website Policy

As part of this class you will be expected to create an maintain a class portfolio website. This website should showcase all of your in class and homework assignments. It is your responsibility to maintain links to all of these projects. These links will be used for grading the projects and a missing link will be considered the same and a missing assignment.

Grading

Projects and Assignments These project are just a sampling of the projects and homework assignments required and may change at any time.

Grades will be posted on oasis. YOU ARE RESPONSIBLE FOR CHECKING YOUR OASIS EMAIL PERIODICALLY THROUGHOUT THE WEEK!

GRADING AND EVALUATION

A MINIMUM grade of ‘C’ is required in order for this course to count toward your major in Interactive Arts and Media. If you do not complete the course with a ‘C’ or better, you will be required to re-enroll in the course until you reach this benchmark. Be advised that if this course is a prerequisite for other courses, that the failure to achieve a grade of ‘C’ or better WILL impede the progress of your studies.

Grading Guideline

Grading is incremental all students start with nothing and work up to a final grade.

 94-100A
 90-93 A-
       above average and outstanding work, no more than one absence, 
       active participation in class and excellent scores
       on exams and projects 
 87-89 B+
 84-86 B
 80-83 B-
       above average work, no more than two absences, and active 
       participation in class and above average scores on exams and projects
 77-79 C+
 74-76 C
 70-73 C-
       average work, no more than two absences, and/or average scores
       on exams and projects
 69-60 D
       below average work, no more than two absences, and/or below
       average scores on exams and projects
 59 and below F
       anything below and including 59% - failure to turn in assignments, three
       or more absences, and/or failing grades on exams and projects
       can lead to an F

Final Projects must be turned in on Final CD see Final CD

Extras

Links

Play-By-Play

This syllabus is subject to change.