Bryant & Stratton College

Course Syllabus

Database Programming – INFT224

Spring 2009 (updated 5/6/2008)


Course Syllabus in Microsoft Word is available at:


Instructor: Jeff Fineberg


Course URL:


Course Time: Wednesday 6:25pm-9:45pm

Course Location: Room B01 – Amherst Campus

Office hours: Room B01 – Wednesday 5:55-6:25 (or by appointment)


Biographical Information: I have 19 years of professional IT experience.  I have held various positions including Software Development, Systems Administration, Database Administration, Project Management and Teaching.  I have worked on platforms including Mainframe MVS, Unix, Linux, and various versions of Windows.  Regarding formal education, I received a Diploma in Data Processing from Bryant and Stratton in 1983, a Bachelors Degree in “Music and Media Studies” from the University at Buffalo in 1992, and a Masters Degree in Computer Science in 2004.


Course Description:   This course will provide a broad overview of database technology.  Areas include the fundamental operations and reasons for using a database, database and table construction, populating data into the database and obtaining information from it using a query language called SQL.  Also stressed is the importance of design that helps to assure that a database’s data correctly represents a particular domain (business or otherwise).


Course Outcomes: An understanding of databases and their characteristics, the design of data structures, security aspects and learning the query language SQL for interacting with the database.


Prerequisites: INFT111 (or equivalent experience) 



A Guide to SQL, 7th edition, Pratt, Thomson Learning/Course Technology 2001

ISBN: 0-619-21674-3   (Note the code for reading assignments: SQL)


Optional textbook:

Concepts of Database Management, 5th edition, Pratt and Adamski, Thomson Learning/Course Technology

ISBN: 0-619-21529-1 (Note the code for reading assignments: CDM)



Examples and Lecture notes


Class Materials - requires logon


Useful resources


Interesting Websites (picked by students and instructor)


Time Management and Study Skills Resources



                              Spring Schedule (subject to change)

Class Date

Topic(s) Discussed / Activities

Assignments / Reading - see details under "assignments"

May 6

Introductions and Course Overview.  Discuss Available Resources / Course web site

Course Survey

-          Read Chapter 1

May 13


Chapter 1 – Introduction to Databases

-          Read Chapter 2

May 20

Chapter 2 – Introduction SQL

-          Assignment 1

-          Read Chapter 2 (continued)

May 27

Chapter 2 – Introduction SQL (continued)

Quiz 1

-          Read Chapter 3

June 3

Chapter 3 – Single table queries

-          Read Chapter 3 (continued)


Jun 10

Chapter 3 – Single table queries (continued)

-          Read Chapter 4

-          Study for Quiz 2 – Chapters 3, 4

-          Assignment 2

Jun 17

Chapter 4 – Multiple table queries

Quiz 2

-          Read Chapter 4

Jun 24

Chapter 4 – Multiple table queries (cont)

Midterm Grades Available

-          Read Chapter 5

Jul 1

Chapter 5 – Updating data


-          Read Chapter 6

-          Assignment 3

Jul 8

Chapter 6 – Database Administration


-          Study for quiz 3

-          Read Chapter 7

Jul 14

*Portfolio Development Day


Jul 15


Chapter 7 – Reports

Quiz 3

-          Read Handouts

-          Assignment 4

Jul 22

Final Project Assigned

Database design – normalization, functional dependencies


-          Read Handouts

-          Study for Quiz 4

-          Initial Work on final project

-          Work on final project

Jul 29

Database Management Systems – Oracle, MySQL, Access, ISPs.

Quiz 4

-          Complete work on final project


Aug 5

Final Project Presentations


-          final project due Aug 5!

Aug 12

Misc. Advanced Topics – functions, procecedures, PL/SQL

-          Have a nice break!!!


                                    (Bold items in schedule are of high importance)


* Important note regarding Portfolio Development Day:


On Tuesday July 14, we will have another Portfolio Development Day.  This seminar will focus on the creation and continued development of your portfolio and include sessions on enhancing your ability to speak to the evidence of your knowledge, skills and behaviors/abilities.  You will be enrolled in a session for that day and are expected to attend.  Please mark your calendars and come prepared to have a unique and special day. 


















Diagnostic assessment (Grading Criteria) - a general Rubric to be utilized for assignments / projects


The following parameters are *generally* being used for grading assignments and projects are:


Grading Aspect

Level 1: 5-10 points

Level 2: 11-20 points

Level 3: 21-25 points


Difficult to follow and understand.

Some aspects could use further clarification.

Easy to understand points that were made.


Several inaccuracies were found in the work.

The work was generally good, but at least one inaccuracy was found.

All work was found to be correct from the standpoint of accuracy.


The work was not complete, therefore the usefulness of it was low.

There was at least one aspect to the work that wasn’t completed.

The work covered all the required aspects and could be used in a ‘real world’ setting.

Citing of sources

Unpublished Source used for the work.  No Published sources used.

Published sources used mainly, however there were some unpublished sources.

All sources for the work were from well-noted published sources.

What is meant by the use of the term *generally*?  If there is a deviance from this Rubric, it will be provided on the assignment.


Authentic assessment: Comprehension of the material will be assessed through homework assignments, quizzes and a final project, using the following grading policy:


                          Grading Policy



20% (4 @ 5% each)


40% (4 @ 10% each)

Final Project


Class participation (labs, quizzes, contributions)










Below 70


Comments regarding grading criteria and material:

-          Quizzes are given to help you gauge your understanding of the material.  They consist of material covered within the period since the previous quiz.  Since some material builds on previous topics, quizzes may be somewhat comprehensive.  Advanced arrangements must be made if a quiz is to be missed (unless a documented emergency exists).

-          Projects consist of elements from the material covered in class and from reading assignments.  Note that the final project is worth 25%.


Portfolio Inclusion – the written assignments and final project are both good candidates for your portfolio.  It is important that your work be well formatted for this purpose.


Critical Workplace Skills – this course will have an emphasis on persistence, a sense of quality,  problem solving, processing information (utilizing past experience to enhance your knowledge – the ability to learn new information) and systems thinking (realization of how a current task fits into a larger picture).


Lifelong Learning Competency Development – this course will help with the development of lifelong learning through knowledge discovery, research and problem solving activities.


Make-up Policy / Late Work

-          Assignments/Projects not submitted in by the due date will be penalized by 20% per day.  If a test is missed with no advanced warning, it is the instructor’s discretion as to whether or not a make-up test will be allowed.


Incompletes: under normal circumstances these are not given.  Where appropriate, any special cases need to be approved by the Dean’s office.


Student Support Services (SSS): Specific blocks of time are set aside in the morning, afternoon and evening when both students and instructors are available.  Please take advantage of this valuable resource.  I am available Monday and Wednesday from 7:15-7:45 for any additional help you may need.


Class List by email: Periodically messages may be sent via email to everyone regarding assignments, etc.  Also, please feel free to email me directly with any questions or suggestions at:


Attendance: attending class is critical in order to gain an understanding of the material.  In addition, there is material that you will be responsible for that is covered only in class (in addition to the text). 


Class participation: This portion of your grade is composed of attendance, class activity work, answering questions in class, suggesting useful / interesting resources, URLs, etc.


Classroom Etiquette: please exercise good judgment during the class.  Make sure that your cell phones aren’t set up to ring.  During class lecture, conversations should involve the topics being discussed and should be shared with the class.  Also, it is the school policy that food and drink should not be brought into the classroom.


Academic Integrity / Plagiarism: It is expected that each student perform his or her own work.  Any acts of plagiarism will be dealt with according to the policy of Bryant and Stratton.