COURSE SYLLABUS
|
Instructor |
|
Phone |
|
|
Office |
Kricker 125 |
E-mail |
mgoetting@shawnee.edu |
|
Office
Hours |
|
Dept. |
Business
Administration |
Course
Description:
This course focuses on the use of Database Management Systems (DBMS) to solve a broad range of business problems. These problems include: storage, management, retrieval, and the synthesis of data to information. Lecture and assignments will be divided between a theoretical discussion of data and the practical use of one or more database system.
Prerequisites:
• BUIS 1001 – Computer Applications
Texts / Materials
(Required):
Peter Rob and Carlos Coronel
Database Systems: Design, Implementation, and Management. Sixth Edition
ISBN: 0-619-21323-x
Grading:
Homework and Projects:
Assignments will be due at the beginning of the class period on the due date. Assignments turned in during the class period or later will be accepted but will be subject to a penalty (reducing the total score). A 10% penalty will be applied for each assignment that is turned in during the class period on the due date. A 20% penalty will be assessed for each week (or part week) that an assignment is late if it is not turned in on the due date.
Unless specifically agreed (in advance) homework IS DUE on the due date. If you are unable to attend class the assignment is to be emailed, faxed or postmarked on or before the due date to avoid the penalty. If you receive an unsatisfactory (less than 80%) mark on an assignment, that was turned in on time, you have the option of resubmitting it by the next class period. An automatic reduction of 20% will be applied to the resubmitted work's score. If you earned a 60% on an assignment and resubmitted it for a 95%, your net score of 75% would be a significant improvement.
Attendance and
Participation:
Your success outside of school requires your daily attendance and so does this class. Regular roll will not be taken but your participation in this class is needed and required.
Extra Credit:
Extra credit may be awarded to students that go well beyond the required
assignments, assist during lab time with their fellow students, or other
factors as deemed by the instructor.
Make-Up
Examinations:
Scheduling and availability of make-up examinations is at the discretion of
the instructor.
Scale:
90.0% - 100% A
80.0% - 89.9% B
70.0% - 79.9% C
60.0% - 69.9% D
0.0% - 59.9% F
Evaluation
Criteria:
Weekly Assignments 60.00%
Examination One 10.00%
Examination Two 10.00%
Final Examination 20.00%
Total 100.00%
Tentative Study
Schedule:
WK Class Date(s) Topics / Chapters
1 Introduction Chapter 1 – Database Systems
2 Chapter 2 – Data Models
3 Chapter 3 – The Relational Database Model
4 Chapter 4 – Entity Relationship (ER) Modeling
5 Chapter 5 – Normalization of Database Tables
6 Examination One (Chapters: 1-5)
Chapter 6 – Introduction to Structured Query Language (SQL)
7 Chapter 6 - Continued
8 Chapter 7 – Advanced SQL
9 Chapter 7 - Continued
10 Chapter 8 – Database Design
11 Examination Two (Chapters: 6,7, and 8)
Chapter 9 – Transaction Management and Concurrency Control
12 Chapter 10 – Distributed Database Management Systems
13 Chapter 11 – Object Oriented Databases
14 Chapter 12 – The Data Warehouse
15 Chapter 15 – Database Administration
X Final Examination (Chapters: 1-12, 15)
Assignment Notes:
Each assignment will be requested in a particular format (printed, written, or digitally). All printed or written assignments must have the students name, project name, and due date on the assignment. You may need to use a cover sheet for this information. Assignments received without this information will be counted as not being turned in and will be destroyed.
All digital assignments must be turned in on either 3 1/2" floppy disks, CD-R, DVD+-R, DVD+-RW, or CD-RW. Disks should be labeled with the students name, the project name, and the due date. CD/DVD media should have the students name on the face of the disk and the project should be saved in a directory with the date followed by a meaningful name. An example would be of a project is titled "Tick-Tak-Toe" and was due on 2/14/2003 then the folder name should be similar to 20030204_TTT.
Assignments and Media will be returned with grade and notes attached. Media may be reused, if desired.
Record Retention:
The instructor will retain all student work that was not returned for a period of two weeks after the end of the term. Any material/media remaining after the two week period will be destroyed/erased, unless prior arrangements are made.
Academic
Misconduct Statement
Academic Misconduct in any form is in direct violation of
the Shawnee State University Student Conduct Code and will not be tolerated.
This includes, but not limited to: copying or sharing answers on assignments or
tests, plagiarism, and turning in someone else's work as your own. Depending on
the act, a student could receive a zero (0%) on the test/assignment, F grade
for the course, and could be suspended or expelled from the University. Please
see the Student Handbook for the complete Student Conduct Code. (This statement
is based on the
Payne Protocol:
The instructor reserves the right to modify this syllabus without advance notice.