Syllabus
 

Course Information

Course Name: Database System and Application
College: School of Optical-Electrical and Computer Engineering 
Fields of Study: Engineering 
Disciplines: Computer
Sub-Disciplines: Computer Science and Technology
Registration Recommendations: International graduate students, domestic students 
Prerequisites: Computer Introduction(Optional) 
Lecture Hours & Credits: 48 lecture hours; 3 credits

Prerequisite

This course covers fundamental undergraduate-level material. You don’t necessarily have any programming background or experience before taking this course.

Objectives

This course aims to respond to the current trend in database application and to meet the demand of network oriented massive information storage, focuses on introducing cluster database and WEB database for both international students and domestic students. By compacting database principle and theory, the course focuses on practical technology, including the relation model, object relational technology and database design techniques. The mainstream of database systems such as SQL SERVER and ORACLE RAC database are introduced, and one comprehensive project is illustrated as the real development case for internationalization and practical training.

Contents

The course is composed of ten topics and one comprehensive training project:
Module 1 Introduction to database system
Module 2: Data model
Module 3: A relational database and SQL language
Module 4: Relational database theory
Module 5: Object-Oriented and Objects-Relational database theory
Module 6: Database transaction management
Module 7: Integrity and security
Module 8: Database design
Module 9: WEB database design
Module 10: Database cluster
Comprehensive training project: Financial regulation system for group company based on the INTERNET

References

Course Grading Policy

Important: You must pass the final exam to pass the course

Bonus (Optional):

If you pass any one of the following certification exam,

  • ORACLE
  • IBM DB2
  • SAP ERP
  • Microsoft SQL Server

you would be able to get the bonus marks for an "upgrade".

There are no makeup exams, quizzes, labs or assignments. Most of the quizzes and exams are planned in the beginning of the lecture, so please don’t be late.

If you miss an exam, quiz, lab or assignment, you will receive zero marks. Exceptions will ONLY be made for documented medical reasons or extenuating family circumstances, and with the instructor’s approval, the marks of the missed part will be moved to the Final Exam. Students are responsible for presenting the document to the instructor.

All assignments have to be typed and submitted through email. Please refer to the APA.7z file as a format template and the font size has to at least than 11 for Times Roman or similar sizes if you use other fonts.

Doing Your Own Work: you are expected to do your own work and not to copy from others. Group discussion of course material and studying together for tests is highly encouraged. However, assignments and examinations must reflect the knowledge of the individual, not of a group. Assignments or exams copied from another will automatically get a mark of 0, and the students (copier and copiee) involved may be expelled from the class.

Plagiarism:

  • Plagiarism occurs when a student presents work or data as original when part, or whole, was written or composed by someone other than the student.
  • Plagiarism occurs when paragraphs, phrases, sentences, or ideas within the work are taken from another source without referencing or citing the author.
  • If you find something interesting in the Internet, quote the detailed web site location, but NEVER just do cut and paste.

 

 

 

TOP