Mathematics/Computer Science

CSC 3800 – DATEBASE MANAGEMENT SYSTEMS

 

Instructor: Dr. Chuck Lillie

Semester: Fall 2008

Class Location: Science 1256

Time: MF 10:00 a.m. -- 11:15 a.m.

Section: 01

 

 

Description

The course covers the goals of DBMS including data independence, relationships, logical and physical organizations, schema, and subschema. Hierarchical, network, and relational models are covered with an emphasis on the relational model. Small SQL queries are created and examined.

Course Materials

Textbook: Ullman and Widom, A First Course in Database Sysems, 3rd Edition, 2008

 

Prerequisites:

CSC 2850

 

Course Content:

 

Goals

 

Objectives

By the end of the semester the student will be able to:

 

Assignments

Assignments

 

Office Hours

Office: Science 1219

Phone: 521-6415

E-mail: lilliec@uncp.edu

 

Office Hours:     MWF 8:15 to 8:45 AM

               MW 2:30 to 3:30 PM

               F 2:30 to 4:00 PM

  Other times by appointment

  Open door indicates unscheduled office hours

 

Course Links

            PHP Reference Manual: http://www.php.net/manual/en/

PHP/MySQL Reference: http://us2.php.net/mysql_result

            MySQL Reference Manual: http://dev.mysql.com/doc/refman/5.0/en/index.html

            HTML Tutorial: http://www.echoecho.com/html.htm

WAMP (Apache, MySQL, PHP on Windows): http://www.wampserver.com/en/

 

Exams and Homework

The final exam is comprehensive. Other than the final, one midterm exam will be given during the class hours. Homework problems will be assigned. All assignments must be completed by the due date. Late homework will not be accepted!!  Homework assignments are individual assignments, but I encourage you to work in groups.  However, each student is expected to turn in their own individual work.

 

Grading Policy

You are responsible for all material covered in class even if you are absent. The final grade will be a weighted average of the tests, homework, and the final exam scores.

 

Grade Components

 Name 

 Weight 

  Homework

  30%

  Mid Term  

  30%

  Final Exam

  40%

 

Final Grades

93 – 100 = A

88 – 89 = B+

78 – 79 = C+

68 – 69 = D+

Below 60 = F

90 –  92 = A-

83 – 87 = B

73 – 77 = C

63 – 67 = D

 

 

80 – 82 = B-

70 – 72 = C-

60 – 62 = D-

 

 

Attendance Policy

Attendance will be checked. Excused absences must be documented and presented to me as soon as possible before or after the absence.  Missing more than three unexcused classes will adversely affect your grade.

 

Student Conduct & Honor Code

The UNCP Academic Honor Code will be strictly observed in this class.

UNCP Academic Honor Code

 
Please note that the use of University computers, as well as E-mail and Internet communications is for University-related business only.

 

Dates

Last day to drop the class with W: Monday, October 20, 2008.

Final Exam: Monday, December 8, 2008, 10:45 a.m. - 1:15 p.m.

 

Students with Disabilities:

Any student with a documented disability needing academic adjustments is requested to speak directly to Disability Support Services and the instructor, as early in the semester (preferably within the first week) as possible.  All discussions will remain confidential.  Please contact Disability Support Services, DF Lowry building, 910-521-6695. 

 

This syllabus is available in alternative formats upon request.  Please contact Disability Support Services, DF Lowry building, 910-521-6695.

 

Updated August 4, 2008 | lilliec@uncp.edu

 

                                                                                                                                                                                                                                 

Dr. Chuck Lillie Home Page

Lillie Home Page

                                                                                                              

Contact Web Page Owner at lilliec@uncp.edu