Course Syllabus
Database Programming – INFT224
Spring 2009 (updated
5/6/2008)
Course
Syllabus in Microsoft Word is available at:
www.fineberg.com/INFT224/syllabus-inft224.doc
Instructor: Jeff Fineberg
Email: st.fineberg.jeff@mail.bryantstratton.edu
Course URL: www.fineberg.com/inft224
Course Time: Wednesday 6:25pm-9:45pm
Course Location: Room B01 –
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)
Textbooks:
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)
Class
Materials - requires logon
Interesting
Websites (picked by students and instructor)
Time
Management and Study Skills Resources
|
Class Date |
Topic(s) Discussed / Activities |
Assignments / |
|
May 6 |
Introductions
and Course Overview. Discuss Available
Resources / Course web site |
-
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) |
-
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.
The following
parameters are *generally* being used for grading assignments and projects are:
|
Grading
Aspect |
Level 1:
5-10 points |
Level |
Level |
|
Organization |
Difficult
to follow and understand. |
Some
aspects could use further clarification. |
Easy to
understand points that were made. |
|
Accuracy |
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. |
|
Completeness |
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:
|
Quizzes |
20% (4 @ 5%
each) |
|
Assignments |
40% (4 @
10% each) |
|
Final
Project |
25% |
|
Class
participation (labs, quizzes, contributions) |
15% |
|
A |
90-100 |
|
B |
80-89 |
|
C |
70-79 |
|
F |
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
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: st.fineberg.jeff@mail.bryantstratton.edu
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.