Course Description: This course provides an overview of database system concepts. The course deals with file organization methods, database models, data integrity and security, and database administration issues. The student will be introduced to application program development in a database environment with emphasis on setting up, modifying, and querying a database. Prerequisite: CS219. 3:0:3
Educational Philosophy: I will do my best to present the material in an understandable and enjoyable manner. However, I cannot do the learning for you, so you must take personal responsibility for your education. Part of that responsibility involves respecting those around you and their right to learn. Outside conversation should be kept out of the classroom. Tardiness is also a disruption and should be avoided unless absolutely necessary.
Learning Outcomes:The following are the learning outcomes for this course:
1. Describe a relational database and object-oriented database.
2. Describe components of a database management system and the techniques used to store and access data within the DBMS.
3. Understand the basic fundamentals of Structured Query Language (SQL).
4. Use SQL to create the tables within a database and queries for updating tables.
5. Utilize SQL to build queries to extract data from multiple tables based on selection criteria.
6. Describe the creation and use of metadata and data dictionaries.
7. Understand issues of implementing an enterprise database or other DBMS solution such as concurrency, efficiency, management of and security.
8. Understand the role and issues surrounding the management of data such as efficiency, privacy, security, ethical responsibility, and strategic advantage.
9. Describe the duties of the database administrator.
10. Describe and understand the role of web-enabling databases.
11. Utilize modeling software to build a database design.
12. Describe normalization and perform normalization of a database model.
I've rearranged the outcomes by importance as I see them. I will do my best to address all of these objectives, but I will focus on what I feel is most important based on my work experience involving databases, mainly outcomes 1 through 9. I will still address outcomes 10 through 12, but not as detailed as the others. I expect that after this class is complete you will have a solid foundation in understanding the principles of databases and SQL.
Course Assessment: There will be daily quizzes starting the second class period. The quizzes will be worth 10% of your final grade and will cover material reviewed up to that point. There will be between 12 and 14 quizzes, but only 10 will count towards your final grade. I will use your top 10 grades. Since I treat the quizzes in this way, quizzes cannot be made-up for any reason. There will also be weekly assignments. I will assign them on Wednesday, and they will be due at the beginning of class the following Monday. These assignments will count for 50% of your final grade. There will be a final exam on the last day of class covering all material from the beginning. This exam will count for 30% of your final grade. Your participation in class, which also includes attendance and classroom behavior, will count for the remaining 10% of your final grade.
Grading: Grading Scale: The following grading scale will be used. A = 90% or higher, B = 80-89.9%,
C = 70-79.9%, D = 60-69.9%, F = Below 60%. Extra credit will NOT be given to offset low scores or absences.
Late Submission of Course Materials: Assignments should be turned in at the beginning of class. Late assignments must be approved by me. All absences must be made up by HANDING IN the completed assignment as soon as possible after the absence. Work must be shown that indicates how each answer was obtained, wherever possible. Failure to make up an absence results in a reduction of 1% of the final grade for each absence. If extenuating circumstances arise, please make them known to the instructor so that he can work with you in your situation. Four (4) unexcused absences will force an "Academic Withdrawal" to occur. Only 1 "two-week" T.D.Y. will be allowed during the course.
When you turn in an assignment, include your full name, the date, and the assignment number in the upper right corner. Concerning grading, I am human and I will make mistakes. You have until the next class period to return an assignment to me if you feel I graded it incorrectly. I will review the assignment and return points to you as needed. However, whether I have made a mistake or not, assignments cannot be returned for review after the next class period. I will be happy to review the issue, but no more points will be awarded.
Classroom Rules of Conduct: I expect you to conduct yourselves in a professional manner. You should respect both yourself and those around you. Outside conversation has no place during class time. There will be a 10 minute break at the halfway point of the class. Any conversation with others not relating to the class should be kept to this time. I will not tolerate any rude comments, including discriminatory or sexual comments, and I will dismiss students from the class, if I feel it is necessary. I think a learning environment based on mutual respect is beneficial to everyone.
Course Topic/Dates/Assignments: All assignments for the week will be due the first class of the next week. Assignments are subject to change.
Week 1-Chapters 1 and 2
Chapter 1-1.2, 1.3, 1.4, 1.5, 1.6, 1.7, 1.8, 1.9,
1.10, 1.13, 1.14, 1.15, 1.17, 1.20
Fired Up Project Questions-1, 2, 3, 4,
5, 6, 7
Chapter 2-2.1, 2.2, 2.3, 2.4, 2.5, 2.7, 2.10, 2.11,
2.12, 2.15, 2.17, 2.19, 2.23, 2.31, 2.32,
2.35, 2.52, 2.53, 2.57, 2.58
Fired Up Project Questions-Part A
Week 2-Chapter 3
Chapter 3-3.1, 3.2, 3.6, 3.8, 3.12, 3.13, 3.15, 3.17,
3.22, 3.23, 3.27
Week 3-Chapters 4 and 5
Chapter 4-4.1, 4.2, 4.3, 4.7, 4.9, 4.10, 4.11, 4.12,
Chapter 5-5.2, 5.3, 5.5, 5.6, 5.7, 5.10, 5.11, 5.15,
Week 4-Chapter 6
Chapter 6-6.1, 6.6, 6.8, 6.11, 6.12, 6.13, 6.14,
6.17, 6.22, 6.24, 6.29, 6.34, 6.35, 6.37
Fired Up Project Questions-A, B, C, D, E,
F, G, H, I, J, K
Week 5-Chapter 7
Chapter 7-7.12, 7.13, 7.21, 7.22, 7.23, 7.24, 7.25,
7.26, 7.28, 7.33, 7.35, 7.36, 7.42, 7.57,
Fired Up Project Questions-A, B, C, D
Week 6-Chapter 10
Chapter 10-10.1, 10.2, 10.3, 10.6, 10.7, 10.8, 10.9,
10.10, 10.11, 10.12, 10.15, 10.19, 10.20,
10.21, 10.22, 10.23, 10.24, 10.26, 10.32,
Week 7-Chapter 16
Chapter 16-16.1, 16.2, 16.3, 16.4, 16.5, 16.6, 16.7,
16.8, 16.9, 16.10
Week 8-Monday-Final Review
Plagiarism:Plagiarism involves the use of quotations without quotation marks, the use of quotations without indication of the source, the use of another's idea without acknowledging the source, the submission of a paper, laboratory report, project, or class assignment (any portion of such) prepared by another person, or incorrect paraphrasing.
Park University 2005-2006 Undergraduate Catalog Page 85-87
Instructors are required to maintain attendance records and to report absences
via the online attendance reporting system.
Park University 2005-2006 Undergraduate
Catalog Page 89Please contact me if you have an emergency or are expecting to be absent. I will not always be able to answer my phone depending on what time it is and where I am. I should be available by phone between the hours of 6 P.M. and 10:00 P.M. on Thursdays, Fridays, Saturdays, and Sundays. However, the best way to reach me is by email. I check my email regularly even when I am at work, so I can respond quicker in this manner. Please feel free to send me emails, but include CS360 Database Management in the subject line. Please call me only if you have not been able to reach me any other way, or it is an emergency.
Park University is committed to meeting the needs of all students that meet the criteria for special assistance. These guidelines are designed to supply directions to students concerning the information necessary to accomplish this goal. It is Park University's policy to comply fully with federal and state law, including Section 504 of the Rehabilitation Act of 1973 and the Americans with Disabilities Act of 1990, regarding students with disabilities. In the case of any inconsistency between these guidelines and federal and/or state law, the provisions of the law will apply. Park University is committed to meeting the needs of all learners that meet the criteria for special assistance. These guidelines are designed to supply directions to learners concerning the information necessary to accomplish this goal. It is Park University's policy to comply fully with federal and state law, including Section 504 of the Rehabilitation Act of 1973 and the American with Disabilities Act of 1990, regarding learners with disabilities and, to the extent of any inconsistency between these guidelines and federal and/or state law, the provisions of the law will apply. Additional information concerning Park University's policies and procedures related to disability can be found on the Park University web page:
Copyright:This material is copyright and can not be reused without author permission.