(Fall
2011)
(Class: TuTh 4:30-5:50PM, Main 129)
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 (EAS) Office (1600 David Adamany
Undergraduate Library) at?phone
(313) 577-1851 or at Email eas@wayne.edu?for a registration.
· Oracle ISQL*Plus (connect identifier oradev_STUDENT)