SULLIVAN UNIVERSITY COMPUTER
SCIENCE DEPARTMENT
COURSE
SYLLABUS
CSC 210 DATABASE DESIGN
INSTRUCTOR: WJ Patterson OFFICE HOURS: Friday 9am – 11am
EMAIL: wjpatterson@sullivan.edu
PHONE: (502) 456-6504
COURSE DESCRIPTION
This course provides a complete introduction to
database concepts and the relational database model. Topics include QBE, SQL,
normalization, design methodology, DBMS functions, database administration, and
other database management approaches, such as client/server databases, object
oriented databases, and data warehouses.
Prerequisite: CSC105 Introduction to
Programming Logic
COURSE OBJECTIVES
Upon completion of this course, the
student will be able to:
1. Understand the Relational
model.
2. Understand data definition
and data manipulation languages.
3. Understand normalization.
4. Understand the
Entity-Relationship design model.
5. Understand security,
concurrency and deadlock.
6. Understand Structured Query
Language (SQL).
7. Understand distributed
databases.
8. Understand database
requirements and translates those requirements into a valid database design.
REQUIRED TEXT
Concepts
of Database Management, Pratt, Adamski, Course
Technology, ISBN# 0-619-06462-5.
COURSE OUTLINE
Week 1: Chapter 1: Introduction to Database
Management
Week 2: Chapter 2: The Relational Model 1:
Introduction, QBE, and Relational Algebra
Week 3: Chapter 3: The Relational Model 2: SQL
Week 4: Chapter 4: The Relational Model 3:
Advanced Topics
Week 5: Chapter 5: Database Design 1:
Normalization
Week 6: Chapter 6: Database Design 2: Design
Methodology
Week 7: Chapter 7: DBMS Functions
Week 8: Chapter 8: Database Administration
Week 9: Chapter 9: Database Management Approaches
Week 10: Course wrap-up
Week 11: Final Exam
Class attendance and
punctuality are essential to the learning process. Attendance will be recorded daily. Any student entering the classroom late - 5
minutes or more after class has begun - will be marked tardy. The accumulation
of 2 tardies will be counted as one absence. Any student accumulating 8 absences during
the quarter will be dropped from the class.
There is no distinction between an excused or unexcused absence in this
policy. If you must be absent for an
extended period of time, contact the instructor as soon as you are able.
Note: Refer to the Student
Handbook for complete details of the Sullivan University Attendance Policy.
The
Note: Refer to the Student
Handbook for complete details of the Sullivan University Dress Standards.
to plagiarize is to;
w steal and pass off (the ideas or words of another) as one's own;
w use (a created production) without crediting the source;
w to commit literary theft;
w present as new and original an idea or product derived from an existing source.
Note: Refer to the Student
Handbook for complete details of the
Computer Science Tutors are available for all students
Monday - Thursday afternoon between
Consult the Student Scene or Night Scene Newsletter for daily schedules,
or ask your instructor for more information.
Computer labs will be available
daily to students during the following hours:
Monday
- Thursday............
Friday
& Saturday..............
Sunday..............................
Students are encouraged to use the computer labs
when classes are not in session during the day, and at the following times:
Monday
- Thursday.....................
Friday, Saturday
& Sunday.......... some labs
available all day
When a class is in session, students
may use any computer not used by a student in the class, as long as the
scheduled class is not disrupted. The
following rules apply during these times:
Ø
Do not enter a computer lab while an
instructor is lecturing to the class.
Ø
Do not ask the instructor for
assistance with an assignment or project.
Ø
Sit in the back of the room, if possible.
Ø
Allow students in the scheduled class to use their
choice of computer.
Ø Notify
the instructor if you are having a computer hardware problem.
** Food and drinks are NOT
allowed in any carpeted area of the building**
*********************************
It is a Class C felony in
the State of
* Changing the
"Welcome to
* Changing any
desktop setting or windows setting unless part of a class assignment
* Loading personal
programs or games on a computer
* Intentionally
modifying files not specifically assigned as part of a class assignment
* Using any computer
for personal reasons
*********************************
Quarter grades will be
based on the schedule shown below.
|
GRADING SCALE: A = 90 - 100 B = 80 - 89 C = 70 - 79 D = 60 - 69 F = below 60 |
Note: This is a core course of the Computer
Science Department. A grade of “C” or better is required for successful
completion for any Computer Science student |
Graded Assignments: Homework assignments 200 Points
Personal
Database Project 200 Points
Bi-Weekly
Exams 400 Points
Final
Exam 200 Points
Total 1000 Points
Homework Assignments
Homework exercises will be assigned from the
textbook on a weekly basis, and are due at the beginning of class on the
due date. No late homework will be accepted. If you have to miss class on the
due date, it is YOUR responsibility to get the assignment to the instructor.
Personal
Database Project:
Each student
will prepare a personal database on the topic of his or her choice, with the
approval of the instructor. Suggestions
include a database based on a book/video/CD collection; household inventory;
contact list; software registration; or other topic of personal
interest to the student. Project
proposals may be submitted at any time, but must be approved no later than
Thursday of Week Three. The completed
project is due on or before Thursday of Week Ten, and is worth 25% of the final
course grade. Specifics on the database
structure and grading system will be discussed in detail in class. Late assignments will be deducted 10 % per
day that they are late, and will not be accepted more than one week late.
Exams:
There
will be 5 exams given during the course given every other Thursday beginning
WEEK 2. You will be allowed to drop your
lowest test score. The highest 4 scores will count towards your final
grade. There will be NO MAKEUPS
given. If you miss a test, that will count as the one you drop. If you
miss 2 or more, they will count as ZERO.
Also, a comprehensive Final Exam will be given.
Participation:
Students
are expected to be prepared each day for class and to actively participate in class.
Classroom
Policies:
Cell
phones are to be turned off during class time.
Students who use a cell phone in class will have points deducted from
the Attendance grade. Pagers may be set
to vibrate, but the student should not answer a page during class time.
Computer
use during class time is encouraged, but ONLY for work related specifically to
this class. If you choose to work on
material NOT related to this class during this time,
you will be marked absent for that day.
CSC210
DATABASE DESIGN -- STUDENT LEARNING OUTCOMES
After successful completion of this
course, the student will be able to demonstrate the following skills:
UNDERSTAND
DATABASE CONCEPTS
□
List several
common uses of databases
□
Explain the role
of redundancy in a relational database
□
Explain the use
of views in a database
□
Describe the
functions of a Database Management System (DBMS):
o
Concurrent update
support
o
Security services
o
Data integrity
□
Describe methods
used to secure data in a database
UNDERSTAND THE RULES OF RELATIONAL DATABASE DESIGN
□
Describe and
apply entity integrity
□
Describe and apply
referential integrity
□
Describe and
apply data integrity
□
Describe and
apply first normal form
□
Describe and
apply second normal form
□
Describe and
apply third normal form
□
Create an
Entity-Relation model in first normal form (1NF), based on an unnormalized table of data
□
Create an
Entity-Relation model in second normal form (2NF), based on an unnormalized table of data
□
Create an
Entity-Relation model in third normal form (3NF), based on an unnormalized table of data
□
Identify a
database structure that is not in third normal form (3NF)
USE ACCESS TO CREATE A WORKING DATABASE
□
Create database
tables in Access
□
Create a database
queries in Access
□
Use key fields to
create relationships between tables
CREATE SQL STATEMENTS
□
Create an SQL
statement using simple and compound conditions
□
Create an SQL
statement using computed fields
□
Create an SQL
statement using subqueries
□
Create an SQL
statement using multiple tables
□
Create an SQL
statement to group records
□
Create an SQL
statement to join tables
□
Create an SQL
statement to update data
UNDERSTAND THE ROLE OF A DATABASE ADMINISTRATOR (DBA)
□
Describe how to
formulate and enforce database policies
□
Describe DBMS
maintenance and selection
□
Describe database
design, testing and performance tuning