|
|
|
|
|
|
|
I reserve the
right to change this syllabus at any time.
| Instructor: | Dick Grant | |
| Phone: | 407-328-2055 | |
| Office: | V102F Sanford | |
| Office Hours | ||
| Email: | grantd@scc-fl.edu | |
| Textbook: |
|
Fundamentals of Database Management Systems by Gillenson; 1st Edition. ISBN 0-471-26297-8 |
Course Description
Course Objectives
Attendance
Grading
Assignments
Exams
Questions
Withdrawals
Academic Integrity
Emergency Notification
Class Schedule
Welcome Letter
This course covers a wide variety of technical and managerial topics related to the design, construction, use, and maintenance of databases. It is not a beginning course. CGS2100C Microcomputer Applications is the prerequisite. You will design, create and use database tables. You will also learn the basics of the Structured Query Language (SQL). This will involve some rudimentary programming. You will learn about different types of databases including the strengths and weaknesses of each.
Upon completion of this course, the student will be able to:
- Create entity relationship diagrams.
- Design and construct database tables.
- Use the data definition (DDL) and data manipulation (DML) commands of the Structured Query Language (SQL)
- Use normalization and denormalization to create effective database tables.
- Given a scenario, determine the appropriate type of database.
- Utilize transactions and concurrency control to insure the integrity of database systems in multi-user environments.
- Explain the issues related to distributed database systems.
- Explain the additional features available with object-oriented databases.
- Explain the role of the database in client/server (2-tier) and n-tier environments.
- Explain the use of databases for online analytical processing (OLAP).
- Create an appropriate design for data driven web sites.
- Explain the role of the database administrator.
Students taking this course on campus:
Attendance will be taken at each class meeting. No part of your final grade depends directly on attendance. However, your attendance is critical for success in this course. It is college policy that the instructor may withdraw a student who has missed 10% or more of the scheduled class meetings.
Students taking this course online:
If you are taking this course online, it is conducted entirely via the virtual Angel classroom. There are no required sessions on campus. However, to "attend" class you must accomplish the following items. I will withdraw you from class automatically if you fail to meet any of these requirements.
- Complete the check in process before the end of the first week of class.
- Log in to the Angel course site at least once every two weeks.
- Substantially complete and submit assignments. I will automatically withdraw you from class if you fail to substantially complete and submit any two consecutive assignments.
Exceptions to the above are granted under extraordinary circumstances such as illness, military commitments, or religious holidays.
Category Points Pct of Grade Chapter Assignments 365 points 65% Midterm Exam 100 points 17.5% Final Exam 100 points 17.5% Total 565 points 100
Final letter grade will be assigned based on the percentage of total points the student earns.
Percentage of Points |
Grade |
| 90% and up | A |
| 80% - 89% | B |
| 70% - 79% | C |
| 60% - 69% | D |
| Below 60% | F |
It is important for you to complete the chapter assignments in a timely manner. Assignments are due by midnight (EDT/EST) on the date indicated in the class calendar. The maximum score attainable will be reduced by 50% if I receive your assignment after that point in time but before midnight on the same day of the following week. Assignments handed in more than 1 week late will receive a score of zero points.
You may not turn in the same assignment more than once. If an assignment has multiple parts (for example parts A and B), you must turn in all parts at the same time. You cannot turn in one part one week and the other part another week.
Graded assignments will be returned to you via email within one week of my receiving them or within one week of the due date whichever is later. Your grade for the assignment will be included in the returned project. Grades are posted to a grade book available to you. You should regularly check this grade book to monitor your progress and class standing. The grade book is accessible from a link on the class home page.
Top
Midterm and final exams are conducted via the Internet. There is no component of the exams that require you to be on campus.
The midterm exam will be made available at the beginning of the week indicated in the course syllabus. It must be completed by midnight on the last day of the week indicated. Midterm exams received after that point will receive a grade of zero.
The final exam will be made available at the beginning of the week indicated in the course syllabus. It must be completed by midnight on the last day of the week indicated. Final exams received after that point will receive a grade of zero. Only under emergency situations will you be able to make up a missed exam without prior approval. I will require written documentation to support your request.
The exact due date of exams are listed in the course calendar in Angel and on the course syllabus.
Your willingness to ask questions will be one of the biggest factors in your success in this class. Check the class bulletin board first to make sure your question has not already been asked and answered. If it has not, post your question to the bulletin board. I monitor the bulletin board throughout the day on Monday through Friday. (Monday through Thursday in the summer term.) Other students may also answer your question. You can post questions on the bulletin board anonymously. Feel free to email me directly if you have a question and you are uneasy about asking that question on the bulletin board. I check the class email several times a day Monday through Friday. (Monday through Thursday in the summer term.) Plan your work so that questions can be handled during these time periods. You may also make an appointment to meet with me in person if necessary. You may also call me with questions.
You should feel free to ask questions during class if you are taking this course on campus. In addition to the above resources, I'm usually available directly before class for questions.
You may withdraw from class by visiting the registration office at the Sanford or Lake Mary campus. The deadline to withdraw is usually the point when 70% of the class has been completed. After that deadline I can withdraw you from class. You must send or fax a written notice to me if you miss the deadline to withdraw. If you run into problems and are unable to complete this course, I expect you to administratively withdraw from the class. Students who fail to withdraw will be graded with zeroes for the incomplete assignments and exams. Only under the most extreme emergency circumstances should you ask me to change your status to withdraw after grades are submitted. I will required written documentation for the request.
I expect all your work in class to be your original work. Do not give a copy of your project or any part of your project to another student. If you do, all people involved will be given a zero on that assignment with no means to make up the grade. Obtain my approval first if you think you need to "borrow" code, ideas, or text from a book, the internet, a coworker, or anyone else.
Some assignments require you to write a short paper. You must document your sources for these papers as indicated in the assignments. Do not copy the material from the source. Using short direct quotes is acceptable but these must be documented via a footnote.
A second instance of cheating will result in a failing grade for the course for all those involved. You should also review the policy on academic integrity in the student handbook.
In case of emergency conditions, verify the college is open and classes are being held by calling 407-328-2290 or 407-328-4277. The SCC website home page features updated announcements.
Please complete the class check in process prior to 8/28/2007. This is the add/drop deadline. The check in process is described in this welcome letter. Below is the class schedule. You may work at a faster pace than the schedule below describes. After you check in, your userid and password will allow you to access all class materials. I suggest you follow the class schedule in sequence. Do not fall behind. The topics for bulletin board discussion will be those listed below during the weeks indicated. The assignments are due by midnight on the last day of the week indicated . The exact date is listed in the class calendar. Week 1 listed below Wednesday, 8/22/2007 and ends Tuesday, 8/28/2007.
Week # |
Class Topics |
Assignment Due |
| 1 | Chapter 1 - Data: The New Corporate Resource | Chapter 1 Assignment |
| 2 | Chapter 2 - Simple File Storage and Retrieval | Chapter 2 Assignment |
| 3 | Chapter 3 - Data Modeling | Chapter 3 Assignment |
| 4 | Chapter 4 - The Database Management System Concept | Chapter 4 Assignment |
| 5 | Chapter 5 - The Relational Database Model: Introduction | Chapter 5 Assignment |
| 6 | Chapter 6 - The Relational Database Model: Additional Concepts | Chapter 6 Assignment |
| 7 | Chapter 7 - Logical Database Design | Chapter 7 Assignment |
| 8 | Chapter 8 - Physical Database Design | Chapter 8 Assignment |
| 9 | Midterm Exam (Chapters 1-8) | Midterm Exam |
| 10 | Chapter 9 - Relational Data Retrieval: SQL | Chapter 9 Assignment |
| 11 | Chapter 10 - Object-Oriented Database Management | Chapter 10 Assignment |
| 12 | Chapter 11 - Data Administration, Database Administration, and Data Dictionaries | Chapter 11 Assignment |
| 13 | Chapter 12 - Database Control Issues: Security, Backup and Recovery, Concurrency | Chapter 12 Assignment |
| 14 | Chapter 13 - Client/Server Database and Distributed Database | Chapter 13 Assignment |
| 15 | Chapter 14 - Data Warehouse | Chapter 14 Assignment |
| 16 | Final Exam (Chapters 9-14) | Final Exam |