CIS 347 - Database Management
Course
Syllabus
Instructors: Dr.
Roman Erenshteyn
Office:
CIS Faculty
Suite,
Phone: (302) 225-6315
E-mail: roman@gbc.edu
Homepage:
http://goldey.gbc.edu/~roman/
Office
Hours:
as posted & by appointment
Course Description
This course
provides the student with in-depth knowledge of database analysis,
design, and
implementation principles. Students who successfully complete this course will
be able to use the entity-relationship model to represent business data
requirements, to
translate that model into a relational schema, and to build and use a
relational database
that implements that schema. Students will learn how modern enterprises use
database
technology in Internet and data warehousing applications.
Prerequisite
CIS 149 or ITG 149 with a C- or
better.
Textbook
Required
Text Jeffrey A. Hoffer, Mary B.
Prescott, Fred R. McFadden
Modern
Database Management. Custom 7th Edition for
Goldey-Beacom College, Prentice Hall, 2006
Materials
Media: Flash
Drive
All homeworks will be posted on BlackBoard's
Assignment Section.
Topics Covered
The
following is a list of tentative subjects for this course in no particular
order, which may be
changed without notice at any time at the instructor's sole discretion.
Students should reference
the lecture outlines on the course web page for weekly lecture outlines, and
reading and other
assignments.
I.
The Database Environment. Modeling
Data in the Organization (Chapters 1 and 2)
A. Basic concepts
B. File processing systems
C. Database approach
D. Database applications
E. Components of the database environment
F. Modeling the business rules
G. Entity-relationship model
H. Notations and diagrams
I. Model constructs
J. Relationships
K. E-R modeling examples
II.
The Enhanced E-R Model and Business
Rules (Chapter 3)
A. Supertypes and subtypes
B. Constraints in relationships
C. ERR modeling example
D. Entity clustering
E. Pointers and Arrays.
III.
Logical Database Design and the Relational
Model (Chapter 4)
A. The relational data model
B. Integrity constraints
C. Transforming EER diagrams
D. Normalization
E. Merging relations
IV.
Introduction to SQL (Chapters 5 and 6)
A. The role of SQL and its environment
B. Database definition in SQL
C. Elements of SQL
D. Processing single tables
E. Processing multiple tables
F. Transaction integrity
G. Enhanced SQL
V.
The Client/Server and Internet
Database Environment
(Chapters 7 and 8)
A. Client/Server architectures
B. Three-tier architecture
C. Parallel computer architectures
D. Client/server security
E. Database access from client applications
F. Query-By-Example
G. Using Visual Basic in client applications
H. The Internet and database connection
I. Internet architecture components
J.Web-To-Database tools – ASP
K. Managing website data
VI.
Data Warehousing (Chapter 9)
A. Basic concepts
B. Data warehouse architectures
C. Data characteristics
D. Data transformations
E. User interface
Total
Sessions:
40.00
Number of Credits: 4.0
Policies
Attendance
Attendance
will be taken during each class. Attendance for the duration of every
class is
essential for having any chance of passing this course. Important
information including,
but not limited to, the course schedule, assignments, tests, and many other
items of
importance will be covered and discussed during class time, as needed.
Students are
responsible for being informed of all relevant course information that
transpires during
class time. Students missing any part of any class need to make arrangements
with a
classmate for "catching up" on any missed material, notes,
assignments, handouts, etc.
Almost all class assignments could be found in the BlackBoard’s
course homepage
(see Assignment section). It is students' responsibility regularly check course
homepage.
Remember, the homepage is developed to avoid time and paper wasting.
Please, don't be late! Class doors are closed 5 min after class
begins!
Turn your cell phones in the classroom
or in the Lab during the class!
Late
Assignments
Assignments
are due when they are due and should be submitted electronically.
A 4% penalty will be applied for each day an assignment is late,
including the first day
and weekends.
Late
assignments will be accepted for not more than 7 days after the due date
unless special arrangements were made.
Homeworks and project should be submitted
using BlackBoard's Assignment section
or Drop Box. When submitting through
Drop Box don't forget to press "Send" button
in your Drop Box, and then to attach a file, browsing it on your computer. To
keep all
your files in your Drop Box you should press “Add” button.
Attachments
should be prepared in MS Word. All diagrams and screen
snapshots should be copied to MS Word document.
Each
assignment should be submitted as one MS Word file!
Hand-written homework
will not be accepted!
No
assignment will be accepted after the start of the last regular class of this
course.
Note: It is better to submit
completed assignments a day or two late rather than an
incomplete assignment on the due date. Students will usually fair much better
by
submitting a completed assignment, even if it is a day or two late. Don't
wait for the
assignment’s due date!
Make-up
Tests
Make-up
tests are rare and will be given only in cases of documented serious illness or
other emergencies.
To be
eligible for a make-up test, the student must provide an acceptable excuse prior to
the scheduled date and time of the test.
In the event a make-up test is granted, the student is responsible for taking
the test before
the start of the next class.
If the instructor is not notified prior to the scheduled test time and still
permit a make-up, unless
a satisfactory reason is given for the lack of notification, a 20% reduction of grade will be
incurred. If the next class is scheduled on a day the college is closed, the
make-up test must be
taken prior to the closing of the college.
Academic
Honesty
Helping
a classmate is very honorable, but sharing solutions is strictly prohibited.
All work is to
be done individually, unless explicitly stated otherwise.
Anyone
caught cheating, copying solutions or electronic files, or performing any
other
activity that may be construed as dishonest will be punished up to dismissal
from class
with a failing grade and report to the College Academic Honesty Committee.
No identical programs will be accepted, with exception of group projects.
Remember,
that the programming style is very individual. Don't forget that when
copying other students
projects and/or assignments you are copying their errors too.
Semester Grade
Homeworks, tests and grades.
Five homeworks (four homeworks for
evening section) will be worth 40% of the final grade.
Four exams (two exams for evening section) will be worth 60% of the final grade.
The percentage will not be rounded to the closest integer.
Up to five points could
be added for active participation and perfect attendance.
There are no extra credits for this course!
Up to nine (six for
evening section) percentage points could be deducted for failed tests
(1 pt each) and/or bad attendance (more than 5 missing classes (for day section)
or 2 missing
classes (for evening section) - 5 pts)!
A
letter grade based on the total percentage achieved will be given in accordance
with the
College's grading system.
No grade negotiation, please! Everybody deserves what she/he
deserves!
Correction
of Grades
If
an error is made in grading any of your work or your final grade, I will be
glad to make a correction.
However, the error must be called to my attention within two weeks of the
return of the material in
question. In the case of final grades, the error must be called to my attention
within two weeks of the
next regular semester.
Getting Help
If
help is needed, students are advised to seek it immediately. The ARC
doesn't provide tutoring on
the course subject. The best way to reach the instructor is by e-mail at roman@gbc.edu Individual
assistance will be nearly available at nearly any time I am in my office.
Office and tutorial hours are
set up to ensure that when you arrive, I'll be there.
Working Together
You
are encouraged to partner with one or more other classmates. Should it be
necessary for you
to miss class, a partner can take notes for you, grab extra copies of the
assignment.
However,
each student must prepare the homework by him/herself. Do not copy another's
homework, test, or project! As it was mentioned above cheating or plagiarism
will not be
tolerated and, as the first warning, the score will be divided by the number of
participants
or zeroed! As well as it will be reported to College Academic Honesty Committee
Computer
Software
The following
software will be in use this semester: Microsoft Office
2003 and 2007, Microsoft
Visio. This and other software is available in the Computer Lab.
Academic
Honor Code
All
courses taught at
Academic Honor Code
. Click on the
link above to learn more.
Note: After reading this syllabus you have to sign the acceptance sheet that
will be passed through
at the end of the first class meeting.