IT 120 Syllabus

IT 120 Syllabus

Course Title and Number

IT 120 Database Development

IBEST: 

This course is also eligible for IBEST help and participation. More information will be made available at the beginning of the quarter.

Credits

5

Times

On-line

Prerequisites

IT 100 or Instructor permission

Course Overview

This course is designed to provide students with an overview of database design and development. PREREQ: BTM 111 with a 2.0 or higher, or permission

 

Instructor

Steve Conger

Office Location

BE3175B

Office Hours

I will answer emails with questions as promptly as possible. I will also hold weekly zoom sessions for questions. I will post the time for these session each week.

Email

steven.conger@seattlecolleges.edu

Web Site

http://www.spconger.com/school.html

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

I am offering this course on-line for the first time because of covid-19. There are some advantages to on-line in that you can do the work when it fits into your schedule and you don't have to travel to campus or log into a zoom session at a set time. There are disadvantages too. Relational  database are complex and can take some effort to understand and master. I will provide all the assistance I can. There will be you tube videos for each topic. I will use canvas pages and discussions to provide materials. I will also make google slide shows for each topic. I also have a blog that will be tied to the class.  Each week I will do a check in video in which I review how the class has been doing and I will offer weekly zoom sessions for additional questions. There is a group component to the work. The first several assignments will be individual and guided in which we will design, build and test a database. The group assignment will be to go through the same process with a different database but with fellow students. On-line group work can be a challenge, but I will share several resources and tools to help.  Finally we will return to individual assignments again, when we take a brief look at NoSQL databases. There is a midterm and a final. They are multiple choice with three tries each. The goal is simply to reinforce some of the concepts. We will also have a textbook for additional reference. 

Textbook and Software

Database Design for Mere Mortals, Michael J. Hernandez, Addison, Wesley, 2013 ISBN-13: 978-0-321-88449-

For this course we will use PostgreSQL with pgAdmin and MongoDB with Compass. We will also use Lucid Charts or Draw.io for some of the diagramming. All are free and will work on Windows, MacOS and Linux.

Assignments and Schedule

We will do all the materials and exercises in the first module together in the first two weeks of class time. If you cannot be in class I will create You tube videos of the class for viewing.

The dates on the assignments are approximate. The midterm and final can be taken at any time, but you should wait until the material has been covered. The date on the exams suggests when they are relevant. 

Topical Outline

Creating the scope of the database

Gathering requirements and determining business rules

Database logical design and modeling

Normalization

Physical design and implementation

SQL

Security and disaster management

Grading

Each assignment will be worth a certain number of points. The group exercises will account for 60% of your grade, The individual project will account for 20% of your grade and the Module quizzes will account for the remaining for 20% of your total grade. 

 

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