ACSC 520 - SECTION 1
DATABASE SYSTEM DESIGN
FALL 1998

Description

Database organization; design and use of database management systems; database models; network, hierarchical, and relational; data description languages, data independence, and representation. (3 credit hours)

Prerequisite

grade of C or better in ACSC 420

Meets

TTh 9:25 - 10:40 ADMN 232

Instructor

Janie H. Key

Office

ADMN 201H

Telephone

(803)641-3424

email

janiek@usca.edu

Fax

(803)641-3726

Office Hours

MWF 12:00 - 1:00, TTh 1:45 - 2:45 (Other hours by appointment & drop-in)

Text

Database Processing, Fifth Edition, by David M. Kroenke

Chapters: 1,2,3,5,6,8,9,10,11,13,15,16,17,Appendix

Note - You will also need at least two 3-1/2", CSD approved brand, diskettes. (3M, IBM, Kodak, Maxell, BASF, Verbatim Datalife, Inmac Plus)

Course Objectives

To provide understanding of the concepts used in designing database management systems; to provide understanding of the organization and use of a database; to provide understanding of the design and use of various database models; and to provide an introduction to the use of a variety of database management systems.


Final Grade

Scale

Homework

40%

A

90-above

C

70-76

Exams

30%

B+

87-89

D+

67-69

Final

30%

B

80-86

D

60-66

 

 

C+

77-79

F

below 60


Other

Approximately one chapter will be covered each week. You are responsible for material in the text, all material covered in class, and supplemental handouts. Your final grade is determined by demonstrated achievement of the course objectives as measured by grades received on homework, exams, and a comprehensive final. There will be group projects.

Exams

There will be three major exams and a final.

Tentative Exam Dates

Exam 1 - Thur., Sept. 17
Exam 2 - Thur., Oct. 22
Exam 3 - Thur., Nov. 19
Final - Tue., Dec. 15, 8 AM

Homework

Homework is due at the beginning of class on the due date. Homework may be turned in early. Please staple all written papers in the upper left corner if there is more than one page. Be sure your name and problem number are on the top sheet.

Attendance

The 75% attendance rule applies in this course. That is, the maximum number of unexcused absences allowed in this course, before a penalty is imposed, is four.

Turn In

You must turn in a hardcopy of computer exercises, showing results. Keep a copy of all program files on diskette including group project work.

Makeup Work

Makeup work is given for excused absences only (documentable incapacitating illness, official representation of the University, death of a close relative, religious holiday, and other circumstances preventing attendance but beyond control of the student.) Makeup exams will be given with the final exam. The student is responsible for all assigned work and must confer with the instructor as soon as possible, in the event of an absence. Problems turned in after 5:00 PM , Dec. 7, will receive no credit.

Special Note

If you have a learning or physical disability which might affect your performance in this class, please inform your instructor and the USC-Aiken Counseling Center as soon as possible in order to verify your status and provide you with appropriate assistance. The Counseling Center is located in Room 116C of the Administration Building (phone 641-3317)


Topics

Week 1

Background and Introduction to Database Processing (Chapter: Appendix, 1)

Week 2

Intro to Database Systems (Chapter: 1,2)

Week 3

Intro to Database Systems (Chapter: 2, MS ACCESS)

Week 4

Data Modeling (Chapter: 3)

Week 5

Relational Model (Chapter: 5)

Week 6

Normalization (Chapter: 5)

Week 7

Normalization (Chapter: 5,6)

Week 8

Database Design and Implementation (Chapter: 8)

Week 9

Database Application (Chapter: 9)

Week 10

Database Application (Chapter: 10, 11)

Week 11

Structured Query Language (Chapter: 10, 11)

Week 12

Structured Query Language (Chapter: 11)

Week 13

Hierachial and Network Data Models (Chapter: 13)

Week 14

Database Administration (Chapter: 15,16)

Week 15

Project Summary and Review (Chapter: 17)



This page copyright © 1998-99, The Board of Trustees of the University of South Carolina.
Send comments to: janiek@usca.edu.
URL:http://www.usca.edu/math/~mathdept/jkey/c520f981.html
This page has been accessed 116 times since November 2, 2001 . Last updated Friday, 28-Dec-2001 08:49:19 EST.