CS 482- Database Management System
The course
Web site is hosted by WebCT. If you are not familiar
with it, please see ICT for an NMSU userid and
password and learn how to access WebCT. Please visit
the web-site to get the latest announcements.
I also maintain a
website for the files and notes at
http://www.cs.nmsu.edu/~tson/classes/fall07-482 but it will not have
information about homework and grade.
|
|
§
Time and place: MWF 1:30 pm - 2:20 pm, SH 113 |
|
|
§
Final Exam: 1:00 pm - 3:00 pm, Monday, December 10 |
|
|
§
Office hour: Tu, 10am -
12pm, or by appointment. Send email to ask questions. |
|
|
§
Instructor: Dr. Son Cao
Tran, SH 161, 646-1930. |
|
|
§
TA: Khoi Nguyen (Office hour:
Tuesdays or Thursdayss, 4pm - 5pm). |
Silberschatz, A.; Korth,
H.; and Sudarshan, S. Database System Concepts, Fifth
Edition. McGraw Hill. ISBN 0-07-295886-3.
The website of the book: http://www.db-book.com
The website has slides for all chapters of the book.
Please access this website to download slides.
The goal of this class is to
provide the students with a comprehensive introduction to the design of
databases and the use of database management systems for applications. Topics
cover:
|
|
§
the
entity-relationship model |
|
|
§
relational
database design |
|
|
§
abstract
query languages (relational algebra) |
|
|
§
SQL |
|
|
§
issues
in database design and use (views, integrity constraints, triggers,
transactions, and security) |
|
|
§
advanced
topics (XML, data mining, and information retrieval) |
There will be group programming project and 10-12 written work (time allowed).
This course is aimed at database design and use, and the implementation of database
applications. The implementation of database management systems will not be
covered in this class.
The class will cover the following
chapters:
§
Basic: 2,
3, 4, 6, 7, 8, 10.
§
Intermediate
(most likely, these chapters will be discussed): 16, and 17.
§
If
possible, we will go over selected chapters from Part 8, 9, and Appendix
C.
The tentative weekly schedule is here.
The class is at the introductory
level but you should have some knowledge of UNIX. The theory part requires some
knowledge of discrete mathematics as well (fixed point operator, relations,
set, etc.). We will use Oracle and PHP for the implementation of the project.
There will be around 10 to 12
assignments during the course. Assignments are usually due one week after they
are given out. Homework and project are important and weight 30% of your grade.
A C grade is unavoidable if you miss everything. There will be a quiz of 30
minutes at the end of each chapter (see schedule). They will be moved
accordingly. Other quizzes are often given without prior notice.
You will be asked to create your
own significant database application from scratch. This includes:
|
|
§
selected
your application (topics will be listed at the time the project is given) |
|
|
§
designing
the database |
|
|
§
obtaining
and loading your data into a real DBMS |
|
|
§
practicing
SQL (writing queries) |
|
|
§
creating
Web-interface to your database application |
Grade is computed based on the
standard scale of 100 points. The components of the final grade will be
distributed as follows:
with the following distribution:
one midterm (30%),
final comprehensive examination (35%),
homework assignments (15%), quizzes (10%), and project (10%). Type and submit your homework using
WebCT. Please submit ONLY PDF file as the TA might
not have the latest MSOffice Software. Late homework will not be accepted.
Students are required to attend
class since material covered in class and not present in the textbook will be
used in the tests and home works. Attendances will be taken at the beginning of
the class. Each student is allowed to miss two classes without prior notice.
Withdrawing must be done on time, in accordance with the university calendar.
The grade of I (incomplete) may be
given only if you are unable to complete the course due to documented
circumstances beyond your control that develop after the last day to withdraw
from the course. Appropriate circumstances include illness and death or crisis
in your immediate family. Consult the university catalog for regulations
regarding the I grade. In no case will an I grade be assigned to avoid a grade of D or F in the course.
If you elect to be graded under the
S/U option, you must declare your intention when registering for the course.
All work in the class will be graded in a manner identical to that for students
choosing the letter grade option. At the end of the semester, your final letter
grade in the course will be used to assign either a S
or an U. You must achieve a minimum grade of C in order to receive a grade of
S.
It is expected that students follow
the code of conduct stated in the University Student Handbook. Any violations
of the code will result in a grade of F for the course, in addition to any
further sanctions imposed by the university. Unless explicitly stated by the
instructor, you are assumed to perform the assigned work by yourself, without
any external collaboration. Note that a person copying an assignment is guilty
of a violation of academic conduct, as is the person from whom the assignment
was copied. Consult the web sites http://www.nmsu.edu/%7Evpsa/SCOC/misconduct.html and http://www.lib.nmsu.edu/instruction/plagiarismforstudents.htm for more on this topic.
Feel free to call Jerry Nevarez, Director of Institutional Equity, at 505-646-3635
with any questions you may have about NMSU's
Non-Discrimination Policy and complaints of discrimination, including sexual
harassment.
Feel free to call Michael Armendariz, Coordinator of
Services for Students with Disabilities, at 505-646-6840 with any questions you
may have on student issues related to the Americans with Disabilities Act (ADA)
and/or Section 504 of the Rehabilitation Act of 1973. All medical information
will be treated confidentially.