(Fall
2009)
(Class: TuTh
Webpage: http://www.cs.wayne.edu/~shiyong/csc6710/csc6710.html
The goal of the course is to
present a basic introduction to database management systems, with an emphasis
on database design methodologies (ER diagrams and normalization theory) and
database query languages (relational algebra and SQL). Students will design and
implement a simple database system to deepen their understanding of the basic
database concepts and theories. After taking this course, you will have the
capability of developing various database applications such as enterprise
information systems, e-commerce systems, business management systems, and more
recently, gene and protein information systems in bioinformatics.
The objective of the course is
that students will learn the concepts of DBMS and apply them to the design of
database, refining the design, and finally the implementation of the course
project. This is essential for one to become a successful database programmer
or a DBA, and a very important introduction towards studying other higher
level database topics like transaction processing systems (to be covered in
Database Management II), and pursuing researches in the database field.
A tentative series of lectures are
given in the following which is subject to change. The lecture slides are
available. (remark: chapters with * are self-study only)
The course will require the
following work:
All the above work is expected to
be done individually except the projects which will be completed by a group of
at most two students.
If you have any feedback,
suggestion, concern, or complaint about any aspect of the class, you should
either meet the instructor during his office hours or make an appointment with
him to discuss them. You will not discuss them with other students in public
either in class or outside the class, even you have a good intention for
finding whether your concern is a common concern or not. It is the
instructor’s job to find out how many students might have the same
concern, not your job. You are only allowed to express your own feedback,
concern, suggestion, or complaint, not those of others. The instructor has the
final authority for all aspects of the class.
Office hours are used for
clarification of doubts and confusions. Students should not ask a TA or
instructor for an evaluation of their assignment or project and use the
informal positive feedback as a promise for good grades. It is not the
responsibility of the TA and instructor in their office hours to tell you what
parts of your assignment solutions are wrong.
You can have one
late assignment submission up to one week without any penalty. Please indicate
on the cover page of your submission when you use your late excuse. If late
excuse is not used, a penalty of 10 % per day will be assessed up to one week.
No credits will be given for works handed in one week after the due date.
Copying an assignment from another
student in this class or obtaining a solution from some other source will lead
to an automatic failure for this course and to a disciplinary action. Allowing
another student to copy one's work will be treated as an act of academic
dishonesty, leading to the same penalty as copying. You should learn how to
protect your data. Failure to do so is also unprofessional and it may expose
you to the danger that someone will copy your homework and will submit it as
his or her own (see above). In this case, you may be given a score of 0 for the
assignment in question (and the other party will get a failure).
If you need a special
accommodation due to mental or physical disability or other medical reasons,
please contact the Educational Accessibility Services (
·
Oracle ISQL*Plus
(connect identifier srv10db_STUDENT)