Computer Science Department
IT360: Applied Database Systems (2-2-3) –
Spring 2008
http://www.usna.edu/Users/cs/adina/teaching/it360/spring2008
Instructors:
Dr. Adina Crainiceanu, Phone 3-6822, MI362, adina@usna.edu (Coordinator)
Dr. Lori DeLooze, Phone 3-6820, MI 355,
delooze@usna.edu
Course Description:
This
course will introduce the principles underlying Database Management Systems
(DBMS) with a special emphasis on database management system structure and
function when integrated with web-based database applications.
Learning Objectives:
Upon
completing this course, students should be able to
1.
Explain the main advantages
of modern database management systems over file systems.
2.
Design, create,
and query relational databases to satisfy user requirements.
3.
Design, build and
deploy database-backed applications with dynamic website front-end.
4.
Implement data
access control mechanisms for database and application security.
5.
Analyze the
ethical issues and responsibilities related to records management and its
impact on privacy, discrimination, etc. and its local and global impact on
society.
ABET Program Outcomes:
e.
An understanding of ethical issues and responsibilities; (Supported by Learning
Objective 5)
g.
An ability to analyze the local and global impact of computing on society;
(Supported by Learning Objective 5)
IT-a. An ability to use and apply current technical
concepts and practices in the core information technologies (Supported by
Learning Objective 3)
IT-b. An ability to identify and analyze user needs and
take them into account in the selection, creation, evaluation and
administration of computer-based systems (Supported by Learning Objective 2)
IT-c. An
ability to effectively integrate IT-based solutions into the user environment
(Supported by Learning Objective 2 and 4)
Textbooks:
Required:
PHP and MySQL Web Development, Third
Edition, L Welling and L Thomson, Sams Publishing, 2005
Recommended:
Database Processing: Fundamentals, Design, and Implementation, 10th Edition, David
Kroenke, Prentice Hall, 2005.
Recommended:
Database Management Systems, 3rd Edition, R Ramakrishnan and J
Gehrke, McGraw Hill, 2003
Prerequisites:
IC312 Data Structures
IT350 Web and Internet Programming
Extra Instruction (EI):
EI
is available and encouraged. Since this course continually builds upon material
previously presented, it is crucial that you seek EI as soon as you have
problems understanding the material. However, you must come prepared with specific
questions or areas to be discussed (i.e. have read the assigned readings). If
you have missed class, get the notes from a classmate. Do not ask or expect to
receive EI on material that you have slept through.
Grading:
|
|
6-Week |
12-Week |
Final |
|
Exam 1 |
60% |
20% |
15% |
|
Exam 2 |
|
40% |
15% |
|
Homework, Labs, Quizzes |
40% |
25% |
20% |
|
Projects |
|
15% |
25% |
|
Final Exam |
|
|
25% |
Projects:
There will be one group project, with two major
parts, assigned throughout the semester.
Project must be completed entirely by the students making the
submission.
Exams:
The 6 and 12-week exams will
primarily focus on the recent material. The final exam will be comprehensive.
If for some reason a make-up exam will be required, inform the instructor at
least 1 week in advance.
All exams will be closed
books. You can use your own written notes
during the exams.
Use of any electronic
devices is not permitted during the exam.
Quizzes:
Expect frequent quizzes. Quizzes may be open or closed book/notes, as announced. No makeup
quizzes will be given.
Late Assignments:
Unless
otherwise specified, all assignments are due before the beginning of class on
the due date. If there is no class on the due day, the assignments are due at
0800, under the instructor’s office door.
Late penalty: 10 % - if up to one day late, 25% - if up
to two days late; assignments not accepted if more than two days late.
Re-grade
requests have to be submitted to the instructor at most 7 days after the
assignment was graded.
Honor:
You
are expected to follow the guidance given in:
These references can be
found at http://www.usna.edu/CS/academics/honor.htm.
In
particular:
1.
You may collaborate on laboratory assignments to the following extent: collaborative conversations with regard to syntax,
strategies and methods for accomplishing the goal of the labs are encouraged, however design and implementation must be
the work of the individual student handing in the final product. Sharing or
copying of any submitted work is never permitted. We reserve the right to
divide the grade between any students who violate this policy. In addition, you must identify all those that
you collaborate with on your assignment cover sheet. Consult your instructor if you need further
clarification.
2. All work on exams/quizzes
must be your own.
3.
All work on the projects must be the work of the students in the team making
the submission.
Classroom Decorum:
1. No food is permitted in the classroom or in the labs.
Drinks with closeable caps are permitted.
2. Sleeping is not allowed in class. If you feel you may
fall asleep at your desk, stand in the back of the room.
3. No use of computer equipment for any purpose other
than as outlined in the class activity will be tolerated, i.e. reading e-mail,
playing games, or IMing classmates.
These actions will subject the abuser to immediate dismissal from class
to report to their Company Officer.
Miscellaneous:
1.
2. Please inform the instructor in advance if you will
miss class (for instance, due to a movement order).
Submitted
by: Approved by:
__________________ __________________
Dr.
Adina Crainiceanu CAPT
Thomas Logue, USN
Assistant
Professor, Chairman,
Computer
Science Department Computer
Science Department