CSCI345: Database Management Systems

Updated 2019.12.18

Spring, 2020 Syllabus

Instructor

Tom Kleen, Heelan Hall 274, 279-5411, tom.kleen@briarcliff.edu

Office Hours

Mon, Wed: 10-11; Tue, Thu: 2-3; Fri: 9-10

Prerequisites

CSCI202

Textbook:

Database Processing, 12th Edition, by David Kroenke.

Course Learning Outcomes

1.    To become familiar with the wide range of applications for which databases are used

2.    To become familiar with the history of database processing

3.    To learn how to do effective data modeling

4.    To learn how to normalize a relational database model

5.    To learn the basics of Structured Query Language (SQL)

6.    To become familiar with the concepts that are important for multi-user databases

7.    To acquire expertise using an actual database management system

Expectations:

I expect you to:

1.     Be honest.

2.     Attend class every day.

3.     Read the book.

4.     Complete the assignments on time.

Evaluation methods:

Daily homework assignments, quizzes, and 3 or 4 tests.

Course Content:

We will thoroughly cover parts 1-3. We will also cover parts of part 4 and part 5. We will do a project at the end of the term.

Grading:

Your grade will be based on three things:

1.    20% homework.

2.    10% project

3.    70% at least four tests, each weighted equally.

4.    Grading scale:

A

93-100

A-

90-92

B+

87-89

B

83-86

B-

80-82

C+

77-79

C

73-76

C-

70-72

D+

67-69

D

60-66

F

0-59

Course withdrawal

Withdrawal deadline before the institution of penalty grading is March 30, 2020. After the withdrawal deadline students may withdraw, but will receive a penalty grade of WP (withdrawal passing) or WF (withdrawal failing). Withdrawals are not permitted during finals week.

Required materials

You must purchase the textbook.

Attendance:

You are expected to be here every day. See attendance policy.

Assignments

We will have daily hands-on assignments. Assignments must be on time. The drop box closes at class time on the due date. If you do not get the assignment in the drop box before it closes, you will not be able to hand it in and you will receive a 0.

Tests

Before missing class on the day of a test, you must clear it with me before the test, and you must have a very serious reason for missing the test. If you are sick, you will need a note from the school nurse or a doctor. If you miss a test without clearing it beforehand, you will receive a 0 for that test. Leaving a voice-mail or an email without a reply is not considered clearing it beforehand. You must talk to me.

Title IX Educational Act

Info on the BCU Sexual Harassment policy.

Academic Honesty

All students are expected to abide by the Briar Cliff academic integrity statement and the Computer Science Department academic integrity statement.

Disability Statement

Persons with disabilities who need accommodations should initially contact Jeanene Sampson (Heelan Hall-108 or 712-279-5562) to discuss needs. Documentation of the disability is required.

Disclosure

The instructor retains the right to clarify and/or to emend the contents of the syllabus, provided that students are given reasonable and timely notice of such adjustments.

Course Schedule

We meet Tuesday and Thursday from 9:30-10:45. The time for the final test is on our home page.

Attendance

I expect you to be here every day. See attendance, test, and homework policies. Print out this document, sign it, and hand it in next class.

Electronic devices

Turn off or silence your cell phone and any other electronic devices that could distract you and put them out of sight before class begins.

Computer use during lectures

You may use your computer during a lecture for the purpose of taking notes. You may not use the computer to play games, surf the Internet, email, IM, tweet, etc. If you do, your computer may get unplugged.