Dr. Qin Ding
Office:  Sci. & Tech. C-118
Email:   dingq@ecu.edu
Phone:  (252) 328-9686
Office hours:   Monday & Wednesday 1:00 - 2:00pm, Tuesday & Thursday 11:am - 12:15pm, and by appointments

Meeting Time and Place

Monday, Wednesday & Friday 9:00am - 9:50pm, Austin 306

Textbook

A First Course in Database Systems (Third Edition), by Jeffrey D. Ullman and Jennifer Widom. Published by Prentice Hall, 2008. ISBN: 0-13600637-X, 978-0-13-600637-4

References

Database System Concepts (Fifth Edition), by Abraham Silberschatz, Henry F. Korth, and S. Sudarshan. Published by McGraw-Hill, 2005. ISBN: 007-295886-3

Fundamentals of Database Systems (Fourth Edition), by Ramez Elmasri and Shamkant B. Navathe. Published by Addison-Wesley, 2003. ISBN: 0-321-12226-7

Database Management Systems (Third Edition), by Raghu Ramakrishnan and Johannes Gehrke. Published by McGraw-Hill, 2002. ISBN: 007-246563-8

Database Systems: The Complete Book (First Edition), by Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer D. Widom. Published by Prentice Hall, 2002. ISBN: 0-13-031995-3

Prerequisites

CSCI 3200 - Data Structure and Its Applications, or
CSCI 3310 - Advanced Data Structures and Data Abstraction

Goal

The main goal of this course is to explore the relational database model, with special emphasis on the design and querying of relational databases.

Topics to be covered

Entity-Relationship Model
Relational Model
SQL
Advanced SQL
Relational Database Design

Required Work and Grades

Students are expected to attend all the lectures and to finish all the assignments. Grades will be based on midterm, final exam, assignments and in-class quizzes. No late assignments will be accepted.  No makeup for quizzes. Final exam will be comprehensive. Class work will be counted as follows.

• Assignments  - 40%
• Midterm exam - 20%
• Final exam - 30%
• Quizzes - 10%

The following table gives the percentage of points needed for the associated final grade:

A    90-100%
B   80-89%
C    70-79%
D   60-69%
F     below 60%

Tentative Schedule

 

Outline	Reading
I. Introduction	Chap 1
II. Entity-Relationship Model	Chap 4
III. Relational Model	Chap 2, 5
IV. SQL	Chap 6
Midterm	Friday, Oct. 16
V. Advanced SQL	Chap 7, 8, 9, 10
VI. Relational-Database Design	Chap 3
Final Exam	Monday, Dec. 14, 8:00am-10:30am

Note that, except for the exam schedules, everything else on this schedule may change as we progress to reflect the pace of the class.

Email

Announcements will be sent through emails if needed.  It is the responsibility of the student to regularly check his/her email.

Web Page

The web page for the course is at http://www.cs.ecu.edu/~dingq/CSCI3700

Academic Honesty

All work must be completed in a manner consistent with the ECU Academic Integrity. Please refer to the Student Handbook for further information on ECU's policy on academic integrity.

Students With Disabilities

East Carolina University seeks to comply fully with the Americans with Disabilities Act (ADA). Students requesting accommodations based on a disability must be registered with the Department for Disability Support Services located in Slay 138 ((252) 737-1016 (Voice/TTY)). Instructors should also be notified during the first week of classes.

Weather Policy

In the event of a weather emergency, information can be accessed through the following sources: ECU emergency notices www.ecu.edu/alert or the ECU emergency information hotline at 252-328-0062.

Send questions and suggestions to dingq@ecu.edu

[ CSCI 3700 Home | Syllabus | Assignments | Resources ]