|
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 |
|
|
Office |
ADMN 201H |
|
Telephone |
(803)641-3424 |
|
|
|
|
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 |
|
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) |