TSYSSchool of Computer Science

ColumbusStateUniversity

Course Title: CPSC3131 –Database Systems

Instructor

Name:Neal L Rogers, Ph.D.

Office: Tech 425

Phone:(706) 565-4095

E-Mail:

Website:

Office Hours

Office hours can be found on the home page of website. (Link above!)

Required textbook

/ Title: Database Concepts (4th Edition, 2010)
by David Kroenke & David Auer,
Publisher: Prentice Hall
Format: Paperback; 457 pages
ISBN-10: 013 608 6535

Supplementary materials

Lecture notes, class handouts, external research (online and offline)

Catalog Course Description

The course covers the fundamentals of database systems. Topics to be covered include the following: file systems and database concepts, database models, relational database model, introduction to SQL, database design and implementation, database integrity, and normalization of database tables. Implementation techniques using commercial DBMS will be considered. The course includes lab work and individual database application programming projects.

Course Prerequisite

Prerequisite(s): CPSC1302 with ‘C’ or better.

Course Objectives:

Upon completing this course, the students will demonstrate an understanding of file systems and database concepts, database models, relational database model, introduction to SQL, database design and implementation, database integrity, and normalization of database tables.

Course Outcomes:

At the end of the course the student will be able to describe and explain the following:
1. Students will learn the fundamental concepts of database systems.

Strategies and Actions used to produce the outcome:

Study of the functions of modern database systems

Study of the components of modern database systems

Study of the evolution of database systems

ABET Criteria covered: C and I

Program Objectives covered: 2

Assessment Methods: Theory and practical Assignments, Quizzes and Written Exam.

2. Students will have an understanding of the relational database management model.

Strategies and Actions used to produce the outcome:

Study of the relation database model

ABET Criteria covered: A and C

Program Objectives covered: 1 and 2

Assessment Methods: Theory and practical Assignments, Quizzes and Written Exam.

3. Students will understand entity-relationship diagramming and normalization.

Strategies and Actions used to produce the outcome:

Study of the tools used in database design

ABET Criteria covered: I

Program Objectives covered: 3

Assessment Methods: Theory and practical Assignments, Quizzes and Written Exam.

4. Students will learn the Structured Query Language (SQL).

Strategies and Actions used to produce the outcome:

Study of SQL for creating databases and manipulation of data.

Use of SQL for developing databases using a relational DBMS

ABET Criteria covered: C and I

Program Objectives covered: 3

Assessment Methods: Theory and practical Assignments, Quizzes and Written Exam.

5. Students will understand transactions, locking mechanisms and database recovery.

Strategies and Actions used to produce the outcome:

Study of the management of transactions, concurrency and data security in modern database systems

ABET Criteria covered: I

Program Objectives covered: 2

Assessment Methods: Theory and practical Assignments, Quizzes and Written Exam.

6. Students will learn about basic database administration.

Strategies and Actions used to produce the outcome:

Study of the tasks in database administration and their management, including the responsibilities of the database administrator.

ABET Criteria covered: J

Program Objectives covered: 2

Assessment Methods: Theory and practical Assignments, Quizzes and Written Exam.

7. Students will learn about how database processing is used in business intelligence.

Strategies and Actions used to produce the outcome:

Study basic concepts of data warehousing, online analytical processing (OLAP) and data mining.

ABET Criteria covered: I

Program Objectives covered: 2

Assessment Methods: Theory and practical Assignments, Quizzes and Written Exam.

8. Students will gain competence in using a popular (DBMS) for developing applications.

Strategies and Actions used to produce the outcome:

Study basic concepts of data warehousing, online analytical processing (OLAP) and data mining.

ABET Criteria covered: I

Program Objectives covered: 2

Assessment Methods: Practical Assignments.

This course will require you to do practical work with the Microsoft Access DBMS and MySQL.

Course Methods

This will be an in-class lecture course, taught face-to-face. There will be a lab component, in which the student will learn by several hands-on experiences by completing assignments using one of the Database Systems.

Methods for Evaluating Students

The evaluation methods will include homework, three or more quizzes, lab experiences, and a final exam. The relative grading is shown below.

Homework and Labs (Average)40%
Quizzes and Final (Average)60%

Assignment of Letter Grades

The method of assigning letter grades based on overall course averages is CSU standard: The basic method is described as follows:

A90 – 100D60 – 69
B80 – 89FBelow 60
C70 – 79

Notes:

  • Students are responsible for all assigned readings and all information presented in class and lab session, including any changes in due dates, assignments, exams, etc.
  • Students should mute all phones. All other electronic devices are NOT allowed without prior permission of the instructor. (Includes: laptops, PDAs, iPads, etc.) No texting allowed during class session.
  • LATE ASSIGNMENTS WILL NOT BE ACCEPTED.
  • Students are expected to attend all of the class lectures, lab, and review sessions.
  • Students are NOT permitted to submit extra work in an attempt to raise grade.

Other Course Policies

Attendance Policy

I usually do not take roll, but believe that it is important for students to attend class regularly.

If you find it necessary to miss one or more classes, you are still responsible for all material covered in the class, and for submitting the homework on time (prior to the start of class).

Students absent without excuse on a day that homework is due will get a 0 (zero) on that homework assignment, unless it is submitted early.

Any student absent without excuse on a day when he or she is called to present a homework solution to the class will receive a 0 (zero) for that presentation.

Students should notify me in advance of expected class absences to avoid penalties on homework due on the date you miss. Excuses will be granted after the absence only for cases of medical emergencies etc. as defined in CSU policy.

For more information on class attendance and withdrawal, refer to

Dropping the Course

We hope that you will complete the course and profit from it. If it is necessary for you to withdraw from the course during the semester, you must follow all official CSU procedures for withdrawing. It is not sufficient to notify the instructor; you must use the ISIS system and withdraw officially. The instructor may drop you for inactivity if you miss four classes or get behind two or more assignments. For details on how to withdraw from a course, see the web page:

NOTE: The deadline to drop courses has been changed to the fourth week of class!

Policy on academic integrity: Students are encouraged to study together; however, each student must individually prepare his/her own submissions. Cheating or plagiarism is not permitted and will be sanctioned according to the CSU policy on academic standards. You should carefully read the section on Academic Misconduct in the Student Handbook. Your continued enrollment in this course implies that you have read it, and that you subscribe to the principles stated therein.

Policy prohibiting sexual harassment: As your instructor, one of my responsibilities is to treat all studentsfairly and equally and to abide by the policies and procedures governing faculty/student relationships, including those concerning sexual harassment as stated in the Faculty Handbook.

Students with a documented disability as described by the Rehabilitation Act of 1973 (P.L. 933-112 Section 504) and Americans with Disabilities Act (ADA) that affect their ability to participate fully in class or to meet all course requirements are encouraged to bring this to the attention of the instructor so that appropriate accommodations can be arranged. Further information is available from the Office of Disability Services in the Center for Academic Support and Student Retention, Tucker Hall (706) 568-2330. Course requirements will not be waived but reasonable accommodations may be provided as appropriate.

ABET Criteria:

  1. An ability to apply knowledge of computing and mathematics appropriate to the discipline;
  2. An ability to analyze a problem, and identify and define the computing requirements appropriate to its solution;
  3. An ability to design, implement and evaluate a computer-based system, process, component, or program to meet desired needs;
  4. An ability to function effectively on teams to accomplish a common goal;
  5. An understanding of professional, ethical, legal, security, and social issues and responsibilities;
  6. An ability to communicate effectively with a range of audiences;
  7. An ability to analyze the local and global impact of computing on individuals, organizations and society;
  8. Recognition of the need for, and an ability to engage in, continuing professional development;
  9. An ability to use current techniques, skills, and tools necessary for computing practice.
  10. An ability to apply mathematical foundations, algorithmic principles, and computer science theory in the modeling and design of computer-based systems in a way that demonstrates comprehension of the tradeoffs involved in design choices;
  11. An ability to apply design and development principles in the construction of software systems of varying complexity.

CS Program Objectives:

Our graduates will have achieved:

1)a broad general education assuring an adequate foundation in science and mathematics relevant to computing.

2)a solid understanding of concepts fundamental to the discipline of computer science.

3)good analytic, design, and implementation skills required to formulate and solve computing problems.

4)the ability to function and communicate effectively as ethically and social responsible computer science professionals.