Fall 2013
Syllabus
for CSC 4480: Principles of Database Systems
|
Instructor |
Mirela
Damian, MSC 167A
mirela.damian@villanova.edu
|
|
Office Hours |
T 4:00 pm
– 5:30 pm W 4:00 pm – 5:30 pm |
|
Course Meets |
TR
1:00 pm in Mendel Science Center G87 – 2:15 pm in Mendel Science Center G87 |
|
Prerequisites |
CSC
1051 – Algorithms and Data Structures I CSC
1300 – Discrete Structures |
Course Description
Database
systems are used to store, manipulate and retrieve large amounts of data in
nearly every type of organization (business, health care, government,
education, libraries). This course is an introduction to the design,
implementation and use of database systems and applications.
Catalog
description: Concepts and technology of database management systems and data
modeling, with an emphasis on the relational model; database querying and
normalization; physical data organization.
Student Learning
Outcomes
1. Students will establish
an understanding of database principles and technologies underlying database
management systems.
2. Students will establish
an understanding of data models, physical data organization, data design,
normalization, and querying.
3. Students will
become literate in one or more of the important commercial database systems,
such as Oracle, MySQL and Microsoft Access.
4. Students will be able to
apply the concepts learned in class by developing a working prototype based on a
medium size database.
Learning Resources
|
The
textbook for this class is Jeffrey A. Hoffer, Ramesh Venkataraman
and Heikki Topi Modern Database Management, 11/E Prentice Hall, ISBN 0-13-266225-6 Companion
website for the textbook: http://wps.prenhall.com/bp_hoffer_mdm_11/ Other
course-related materials will be posted online on the class website: http://www.csc.villanova.edu/~mdamian/csc4480/ Please
make sure you check the class website regularly. |
|
Course Requirements
Students
are expected to read ahead sections and watch video tutorials that accompany the
textbook. Pop quizzes may be given
to summarize the assigned readings and video.
1. Homework: weekly written assignments.
2. Project: one term project, to be completed in stages. The project
will involve designing and implementing a database system for an organization.
3. Presentation: one presentation of your final project.
4. Tests: one test in the second half of the
semester. The test will be closed books/notes. However, you are allowed to
bring one sheet of paper (letter size) with any information you think will help
you during the exam. Please note that
notes may not be shared during the exam.
5. Class Attendance. Regular attendance is expected of all students.
Each student is responsible for all material, announcements, and assignments
covered during any class missed.
6. Late Policy. All assignments are due
at the beginning of the class on the due date. Late submissions will receive no
credit.
Tentative Grading Procedure
The
following allocation of points is tentative and may change during the semester:
|
Test: Project: Assignments: Other
(pop quiz, class participation) |
30% 30% 30% 10% |
Academic Integrity
I
encourage you to collaborate on assignments and learn from your fellow
students. However, there is a fine line between collaboration and cheating.
Collaboration means discussing problems and solution approaches with other
students and independently writing your own answers; cheating means copying solutions
from someone else or giving someone else your solutions. If you have questions
about what is acceptable, please bring them to me before submitting your
work.
Cheating, plagiarism and helping others commit
these acts are all forms of academic dishonesty, and will not be tolerated.
Academic misconduct could result in disciplinary action that may include, but
is not limited to, suspension or dismissal. To read the entire Code on Academic
Integrity, consult
http://www.villanova.edu/vpaa/office/facultyservices/policies/integrity/code.htm
Special Arrangements
If
anyone has a disability or other problems that warrant the need for special
accommodation to complete the course work, please contact me at your earliest
convenience.
Tentative Course
Schedule
The
course schedule below is approximate and subject to change as the semester
progresses. It is the responsibility of the student to learn and adjust to
changes. Students are expected to read
chapter material to be covered prior to each session.
|
Date |
Topic |
References |
|
Wk 1: Aug. 27, 29 |
Introduction to Databases. |
Ch. 1, Video |
|
Wk 2: Sep. 3, 5 |
Conceptual Database
Modeling. |
Ch. 2&3, Video |
|
Wk 3: Sep. 10, 12 |
||
|
Wk 4: Sep. 17, 19 |
Logical Database Modeling. |
Ch. 4 |
|
Wk 5: Sep. 24, 26 |
||
|
Wk 6: Oct. 1, 3 |
Normalization |
Ch. 4 |
|
Wk 7: Oct. 8, 10 |
||
|
Oct. 12 – 20 |
Fall Break – ENJOY
!
|
|
|
Wk 8: Oct. 12, 24 |
Basic SQL |
Ch. 6 |
|
Wk 9: Oct. 29, 31 |
Advanced SQL. |
Ch. 7 |
|
Wk 10: Nov. 5, 7 |
||
|
Wk 11: Nov. 12, 14 |
Physical Database Design and Performance |
Ch. 5 |
|
Wk 12: Nov. 19, 21 |
||
|
Nov. 26 |
Test |
|
|
Nov. 27 – 30 |
Thanksgiving Recess
– ENJOY ! |
|
|
Wk 13: Dec.3, 5 |
Database Application Development |
Ch. 8 |
|
Wk 14: Dec. 12 |
||
|
Poster
Presentations and Applications Demonstration on Friday, Dec. 13, 11:30 am -- 1:30 pm |
||