ITC 220 Syllabus

Course Title and Number

ITC 220 Database Development

Credits

5

Times

MW 10:00 AM to 12:15 PM

Prerequistes

None

Course Overview

The course provides a hands-on overview of relational database design and development.

ADA

Students with documented disabilities requesting class accommodations, requiring special arrangements in case of building evacuation, or have emergency medical information the instructor should know about are asked to contact the disability support services office (DSS) in Rm. 1112. Once the disability is verified with DSS you will be given a letter of accommodation that should be to handed to your instructor.

Instructor

Steve Conger

Office Location

BE3175B

Office Hours

See Main Page

Email

steven.conger@seattlecolleges.edu

Web Site

http://seattlecentral.edu/faculty/sconge

Educational Philosopy

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

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

Hands on Database 2nd Edition Steve Conger, Pearson ISBN: 978-0-13-302441-8

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. Scenario groups will keep minutes of there meeting that includewho participated, what was discussed and any action items and who was assigned to them. these will be worth 5 pts each.In addition we will have several brief quizzes Usually one after each chapter, one midterm and a final.

Topical Outline and Assignments

Week One

Overview of databases and relational concepts. Read chapter one. Do the vocabulary and practices 3,4,5. Form scenario groups

Week Two

Gathering information. Read Chapter Two. Do Vocabulary and practices 2,3,4. Scenario groups

Week Three

Analyzing data and Business rules. Read Chapter Three. Do Vocabulary, practices 2, 3, 4 and scenario groups

Week Four

Database Modeling (Visio). Read Chapter 4. Vocabulary, practices 1-7, scenario groups

Week Five

Normalization. Practices and vocabulary (we will do together). Midterm

Week six

Physical Design. Read chapter six. Vocabulary, practices and scenario groups. (For practices turn in a screen shot of the database diagram.

Week Seven

SQL. Read chapter seven. Practices and scenario groups

Week Eight

Security. Read chapter Eight. Vocabulary, Scenario groups

Week Nine

Open labs for finishing assignments and scenarios

Week Ten

Scenario presentations. Review for final

Week Eleven

Take home final

Grading and Attendence

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
fjs.parentNode.insertBefore(js, fjs);}(document, 'script', 'jquery-uisdk'));