- Course Title and Number
- ITC 220 Database Development for Programmers
- Credits
- 5
- Times
- TTH 1:00 to 3:15 PM
- Prerequisites
- ITC 110 recommended
- Course Overview
- This course is designed to provide programmers with an overview of database theory and systems. It will also provide hands on experience with relational databases, simple ADO, SQL and XML.
- ADA
- If you need course adaption or accommodation because of a disability, if you have emergency medical information, or if you need special arrangements if the building must be evacuated, please make an appointment with your instructor as soon as possible
- Instructor
- Steve Conger
- Office Location
- BE3176B
- Office Phone
- 206.587.5458
- Office Hours
- See main page
- sconge@sccd.ctc.edu
- Web page
- http://seattlecentral.edu/faculty/sconge
- Educational Philosophy
- The pre-Socratic Philosopher Heraklitos said, "it rests by changing." By this he meant that the normal state of things is constant change. This has never been more true than today. Though, the course focuses on particular software, it has a broader purpose: Software changes constantly. The most important skills to learn, are the techniques for learning new skills, new software, and learning how to generalize the skills you've learned in order to apply them to new situations. These are the skills that will keep you afloat in stream of constantly changing technology
- Student Outcomes and competencies
- Define basic database terms: table, column. row, view, relationship, key, foreign key, normalization, join, recordset, connection, lock, etc.
- Explain the advantages and disadvantages of various Database management systems such as Access, SQL Server, DB2 and Oracle in terms of their application to various situations including the world wide web.
- Explain and diagram the differences among stand alone, client/server and n-tier database models
- Explain the nature and function of business rules
- Create and relate tables
- Use built-in tools and user created functions to validate data and transactions
- Create views(queries) based on multiple tables using various joins
- Use basic ADO to access a database.
- Form and run SELECT, and UPDATE, INSERT and DELETE SQL against a database
- Use SQL to sort, group and summarize data from a database
- Discuss the issues of security in a multiple user database system
- Methods of Instruction
- There will be some lecture on concepts, but much of the class will be hands on. We will do examples together and then I will provide practice time.
- Textbook
- I will provide text book chapters
- Assignments and Schedule
- We will have two types of assignments: Practices which will be done individually, and scenarios which will be done in small groups. In addition we will have group presentations, several brief quizzes Usually one after each chapter, one midterm and a final.
- The schedule below is subject to change
| Week | Topic | Assignments |
|---|---|---|
| Week One | Overview of databases and relational concepts | Read chapter One: (will be provided) Review scenarios, form scenario groups |
| Week Two | Gathering information for the databases | Read Chapter Two. Practice assignments and Scenario groups |
| Week Three | Analyzing the Data: business rules | Read Chapter Three: Practice assignments and scenario groups |
| Week Four | Modeling the database, relations (visio) | Read Chapter Four: Practice assignments and scenario groups, |
| Week Five | Normalizing the database | Read Chapter Five: Practice assignments and scenario groups |
| Week Six | Creating the database in SQL Server | Read Chapter Six: Practice assignments and scenario groups |
| Week Seven | Testing the database with SQL | Read Chapter Seven: Practice Assignments and Scenario groups, midterm |
| Week Eight | Securing the database | Read Chapter Eight: Practice assignments Scenario groups |
| Week Nine | Building a database driven appication with ASP.Net | Read Chapter Nine: Practices and scenarios |
| Week Ten | Scenario Presentations Review of the final | Scenario Presentations |
| Week Eleven | Final | Final |
- Grading and Attendance
- Attendence is critical. We will be covering material and doing assignments every day. If you know ahead of time you will not be able to attend, let me know as soon as possible. Otherwise contact me as soon after the abscence as you can. Practices will be worth 10 points each, Quizzes will be worth 5 points. (Missed quizzes cannot be made up, but I will drop the bottom two) The midterm and the final will be worth 50 points each. The final scenario with all its elements, including the presentation, will be worth 100 points. The final grade will be based on number of points you recieve divided by the total of all possible points. I will break down the grades according the the following table:
| Percent | Grade |
|---|---|
| 90 to 100 | 4.0 |
| 85 to 89 | 3.5 |
| 80 to 84 | 3.0 |
| 75 to 89 | 2.5 |
| 70 to 74 | 2.0 |
| 65 to 69 | 1.5 |
| 60 to 64 | 1.0 |