Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Rejai, Barry


Mission Statement: The mission of Park University, an entrepreneurial institution of learning, is to provide access to academic excellence, which will prepare learners to think critically, communicate effectively and engage in lifelong learning while serving a global community.

Vision Statement: Park University will be a renowned international leader in providing innovative educational opportunities for learners within the global society.

Course

CS 360 Database Management

Semester

F1J 2008 DN

Faculty

Barry Rejai

Title

Adjunct Faculty

Degrees/Certificates

Masters in Computer Science
Bachelors in Computer Science

Daytime Phone

913-485-6207

E-Mail

b.rejai@park.edu

barry.rejai@embarq.com

Web Page

http://parkonline.org/

Semester Dates

August 18 - October 12

Class Days

---W---

Class Time

5:30 - 9:50 PM

Prerequisites

CS 219

Credit Hours

3


Textbook:

Hoffer, Jeffrey A., Prescott, Mary B., Topi, Heikki, Modern Database Management, Ninth Edition, Prentice Hall, 2009, ISBN 0-13-600391-5.

Textbooks can be purchased through the MBS bookstore

Additional Resources:

McAfee Memorial Library - Online information, links, electronic databases and the Online catalog. Contact the library for further assistance via email or at 800-270-4347.

Park University Online Bookstore - Select "Distance Learning - Graduate," or "Distance Learning Internet," and then click on the appropriate course code (ex. AC 201, PA 501) to see the list of required and optional texts for each course that you are enrolled in.

Advising - Park University would like to assist you in achieving your educational goals. Your Campus Center Administrator can provide advising to you, please contact them for assistance. If you need contact information for your Campus Center, click here.

Online Tutoring Services - Park University has arranged for Online students to receive five hours of free access to Online tutoring and academic support through Smarthinking. If you would like Online tutoring, please contact me to receive their recommendation and information on how to access the Online tutoring.

Career Counseling - The Career Development Center (CDC) provides services for all stages of career development. The mission of the CDC is to provide the career planning tools to ensure a lifetime of career success.

Online Classroom Technical Support - For technical assistance with the Online classroom, email helpdesk@parkonline.org or call the helpdesk at 866-301-PARK (7275). To see the technical requirements for Online courses, please visit the http://parkonline.org website, and click on the "Technical Requirements" link, and click on "BROWSER Test" to see if your system is ready.

Park Helpdesk - If you have forgotten your OPEN ID or Password, or need assistance with your PirateMail account, please email helpdesk@park.edu or call 800-927-3024.

McAfee Memorial Library - Online information, links, electronic databases and the Online catalog. Contact the library for further assistance via email or at 800-270-4347.
Career Counseling - The Career Development Center (CDC) provides services for all stages of career development.  The mission of the CDC is to provide the career planning tools to ensure a lifetime of career success.
Park Helpdesk - If you have forgotten your OPEN ID or Password, or need assistance with your PirateMail account, please email helpdesk@park.edu or call 800-927-3024
Resources for Current Students - A great place to look for all kinds of information http://www.park.edu/Current/.


Course Description:
CS360 Database Management: 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:

Each week we will focus on the various aspects of database technology from the basic terms of the discipline, through data modeling, to the concepts utilized in the physical design and implementation of a database. The course will be conducted through a combination of reading assignments, with associated topical weekly discussions, weekly quizzes, and a comprehensive final exam. This course will build on the global and multinational aspects of databasing including the international nature and accessibility of information, and the de facto standardization of technology both for a vendor provided database management system (DBMS) and language, the structured query language (SQL).

Learning Outcomes:
  Core Learning Outcomes

  1. Analyze the difference between Data and Database management (1, 2, 3)
  2. Explain the duties of the data and database administrator. (41, 42, 45)
  3. Describe the creation and use of metadata and data dictionaries. (4, 6, 26, 27, 37, 38, 47)
  4. Identify the organizational perspective of managing data such as efficiency, privacy, security, ethical responsibility, and strategic advantage. (5, 7, 8, 9, 10, 11, 12, 13, 14, 15, 43, 44, 46)
  5. Compare a Relational Database and Object Orientated Database. (16, 23, 24)
  6. Analyze components of a Database Management System and the techniques used to store and access data within DBMS. (17, 18, 19, 20, 21, 22, 25, 36, 39, 40, 49)
  7. Describe a Data Warehouse including possible designs, use and terminology. (48, 49, 50)
  8. Explain and apply the fundamentals of Structured Query Language (SQL). (28, 29, 30, 31, 32, 33, 34, 35)


Core Assessment:
The core assessment for this course is a final exam which counts for 20% of the grade. Questions on the final exam will be developed to test at least eight of the eight course core objectives. Correspondence between core learning outcomes and the sample final exam artifact are as follows:

Link to Class Rubric

Class Assessment:

There will be six quizzes, a project, and the final exam. No makeup quizzes. No incomplete grades.

Grading:

Overall Course Grading

  • The Final Exam will count 20% of your total grade. Each student is responsible for:
    • Completing Weekly Reading Assignments.
    • Completing Weekly Quizzes.
    • Completing the Project.
    • Participating in the weekly Class Discussions.
    • Completing a Final Examination.

    Assignments % of Grade

    • Weekly Quizzes, Discussion Activities, and Project 80%
    • Final Examination 20%

    Failure to take a final exam will result in an automatic "F" grade. 

    Course Grading Scale - the total of all points received will determine the student's letter grade as follows:

    A = 90- 100%
    B = 80-89%
    C = 70-79%
    D = 60-69%
    F = < 60%

Late Submission of Course Materials:

1. There will be no makeup quizzes.
2. Project must be turned in at the beginning of week 8 session.
3. Failure to take a final exam will result in an automatic "F" grade.
 

Classroom Rules of Conduct:

Academic Honesty

Academic integrity is the foundation of the academic community.  Because each student has the primary responsibility for being academically honest, students are advised to read and understand all sections of this policy relating to standards of conduct and academic life. 

Definitions

Academic dishonesty includes committing or the attempt to commit cheating, plagiarism, falsifying academic records, and other acts intentionally designed to provide unfair advantage to the students.

  • Cheating includes, but is not limited to, intentionally giving or receiving unauthorized aid or notes on examinations, papers, laboratory reports, exercises, projects, or class assignments which are intended to be individually completed.  Cheating also includes the unauthorized copying of tests or any other deceit or fraud related to the student's academic conduct.
  • Plagiarism involves the use of quotation 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 assignments (any portion of such) prepared by another person, or incorrect paraphrasing.
  • Falsifying academic records includes, but is not limited to, altering grades or other academic records.
  • Other acts that constitute academic dishonesty include:
    • Stealing, manipulating, or interfering with an academic work of another student or faculty member.
    • Collusion with other students on work to be completed by one student.
    • Lying to or deceiving a faculty member.

Procedure

In the event of alleged academic dishonesty, an Academic Dishonesty Incident Report will be submitted to an Online Academic Director who will then investigate the charge.  Students who engage in academic dishonesty are subject to a range of disciplinary actions, from a failing grade on the assignment or activity in question to expulsion from Park UniversityPark University's academic honesty policy and related procedures can be found in full in the 2004-2005 Park University Undergraduate and Graduate Catalogs.

 

 
Attendance

Professors are required to keep attendance records and report absences throughout the term. Excused absences can be granted by the instructor for medical reasons, school sponsored activities, and employment-related demands including temporary duty. The student is responsible for completing all missed work.  Any student failing to attend class for two consecutive weeks, without an approved excuse from their instructor, will be administratively withdrawn and notified via email that you have been withdrawn and a grade of "WH" will be recorded.

An attendance report of "P" (present) will be recorded for students who have logged in to the Online classroom at least once during each week of the term.  PLEASE NOTE:  Recording of attendance is not equivalent to participation.  Participation grades will be assigned by each individual instructor according to the criteria in the Grading Policy section of the syllabus.

For more details on Park University on page 100 of the Park University Undergraduate Catalog or page 14 of the Park University Graduate Catalog.

Course Topic/Dates/Assignments:

Course Schedule 

Week 1: The Context of Database Management

  • Readings: Text: Read Chapters 1 and 2.
  • Class Activities: During Week 1, we begin with an overview of the course covering the content and administration of the course. Database concepts and terms are introduced, as well as a brief history of database models used over the last 30 years. In Chapter 2, we briefly cover the steps taken in a database development and compare them with the steps for a typical software development effort.
  • Weekly Tasks: Class Discussions.

Week 2: Database Analysis

  • Readings: Text: Read Chapters 3, 4, and Appendix A.
  • Class Activities: During Week 2, we'll introduce data modeling constructs by investigating both the Entity-Relation (E-R) model (for a general database application) and the Enhanced Entity-Relationship (EER) model which provides for supertype and subtype entities to help simplify many data models with similar attributes. We will see that E-R diagrams provide for an efficient graphical tool to document a database data model. Examples of notation conventions and their presentation in common software tools are illustrated in Appendix A. The concept of 'business rules' in the context of database applications is presented in both Chapters 3 and 4.
  • Weekly Tasks: Class Discussions, Project Assignment and Quiz #1. 

Week 3: Database Design

  • Readings: Text: Read Chapter 5.
  • Class Activities: During Week 3, Chapter 5 provides the basis of completing the logical data model by transitioning the E-R model to a relational model through the normalization process. Normalization is explored to promote understanding of the relational database model.
  • Weekly Tasks: Class Discussions and Quiz #2. 

Week 4: Structured Query Language (SQL)

  • Readings: Text: Read Chapters 7 and 8.
  • Class Activities: During Week 4, Chapters 7 and 8 introduce the structural Query Language (SQL) as the direct database interface for relational databases. The data definition language (DDL) and data control language (DCL) are introduced, and the data manipulation language (DML) is explored in more detail so that the student is conversant in querying in SQL. Chapter 8 ends with a discussion of useful current and proposed programming constructs like triggers and procedures, and illustrates ways SQL can be integrated with other programming languages.
  • Weekly Tasks: Class Discussions and Quiz #3. 

Week 5: Physical Database Design/Client-Server Architectures/Distributed Databases

  • Readings: Text: Read Chapters 6, 9, 10, 12, and 14.
  • Class Activities:  During Week 5, we shift from logical modeling involving data and its structure constrained by business rules to physical modeling where we focus on how we will implement the database. We look at providing estimates of permanent and random access memory sizes, and estimates of performance response times for typical database activities. We also discuss ways of increasing response time performance. We will continue with physical database design by considering the network environment in which the database will be implemented. The first consideration here is the type of architecture (i.e. client/server) in which to host the database. Various client/server architectures are examined ranging from file servers to the popular two and three tier designs. We will also discuss the web based popular alternative to the client/server architectures for hosting databases. Issues, such as security, and applications examples are provided for the internet environment associated with databases. We will explore the database network environment design by covering the aspect of distributed databases. The advantages gained by partitioning the tables in a large relational database are weighed against the networked complexity of data synchronization. Topics of data integrity, quality, concurrence, replication, committing changes, and back-up are introduced.
  • Weekly Tasks: Class Discussions and Quiz #4. 

Week 6: Data and Database Administration/Data Warehousing

  • Readings: Text: Read Chapters 11 and 13.
  • Class Activities:  During Week 6, We will examine the function of data stewardship and its two components, data administration (DA) and database administration (DBA). The programmatic tasks associated with designing and maintaining a database such as determining requirements for data security, privileges of uses, data update timing, back-up schedules, etc. are appropriately handled by a data user representative, the data administrator. The DBMS tasks associated with implementing and operating a database such as installing a DBMS, upgrading software, loading/importing data, implementing security policy, performing back-ups, etc. are appropriately performed by a DBA. Additionally, the topics of database deadlocking, and recovery are covered. Chapter 11 examines the newest databasing concept, data warehousing. The need for this structure, and its attendant advantages are covered in exploring the star schema architecture. We continue the discussion of data warehousing by introducing the concept of data marts, and exploring the topics of data cleansing and reconciliation, and data mining and visualization.
  • Weekly Tasks: Class Discussions and Quiz #5.

Week 7: Object Oriented Approach to Databasing

  • Readings: Text: Read Chapters 15 and 16.
  • Class Activities:  During Week 7, we will introduce the database model of the future, the object-oriented (OO) model. We compare the OO model with models covered earlier in course. We use the material in Chapter 15 and 16 to provide examples of an OO database.
  • Weekly Tasks: Class Discussions and Quiz #6. 

Week 8: Assigned Project Due and Final Exam

  • Readings: All Chapters and Appendix A.
  • Class Activities:  The student will take a timed final exam in the classroom. This will be a timed closed book and closed notes comprehensive exam covering all material presented up to and through week seven. The student must turn in the assigned project prior to taking the final exam.
  • Weekly Tasks: Turn in project and take the final exam.

 

Academic Honesty:
Academic integrity is the foundation of the academic community. Because each student has the primary responsibility for being academically honest, students are advised to read and understand all sections of this policy relating to standards of conduct and academic life.   Park University 2008-2009 Undergraduate Catalog Page 87

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 2008-2009 Undergraduate Catalog Page 87

Attendance Policy:
Instructors are required to maintain attendance records and to report absences via the online attendance reporting system.

  1. The instructor may excuse absences for valid reasons, but missed work must be made up within the semester/term of enrollment.
  2. Work missed through unexcused absences must also be made up within the semester/term of enrollment, but unexcused absences may carry further penalties.
  3. In the event of two consecutive weeks of unexcused absences in a semester/term of enrollment, the student will be administratively withdrawn, resulting in a grade of "F".
  4. A "Contract for Incomplete" will not be issued to a student who has unexcused or excessive absences recorded for a course.
  5. Students receiving Military Tuition Assistance or Veterans Administration educational benefits must not exceed three unexcused absences in the semester/term of enrollment. Excessive absences will be reported to the appropriate agency and may result in a monetary penalty to the student.
  6. Report of a "F" grade (attendance or academic) resulting from excessive absence for those students who are receiving financial assistance from agencies not mentioned in item 5 above will be reported to the appropriate agency.

Park University 2008-2009 Undergraduate Catalog Page 89-90

Disability Guidelines:
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. Additional information concerning Park University's policies and procedures related to disability can be found on the Park University web page: http://www.park.edu/disability .



Rubric

CompetencyExceeds Expectation (3)Meets Expectation (2)Does Not Meet Expectation (1)No Evidence (0)
Evaluation                                                                                                                                                                                                                                                 
Outcomes
3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is demonstrated by correctly answering 3 out of 3 questions regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is demonstrated by correctly answering 2 out of 3 questions regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is demonstrated by correctly answering 1 out of 3 questions regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. The artifact demonstrates the student ability to judge relative value of information based on prior knowledge. Evaluation is not demonstrated when less than 1 out of 3 questions are correctly answering regarding: (a) relational data base characteristics (b) object oriented data base characteristics (c) comparison of relation and object oriented databases. 
Synthesis                                                                                                                                                                                                                                                  
Outcomes
3,7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 10 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 7 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is demonstrated by correctly answering 5 out of 10 questions regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology The artifact demonstrates the student ability to creatively apply prior knowledge and skills to produce an original narrative. Synthesis is not demonstrated when less than 5 out of 10 questions are correctly answered regarding: (a) creation and use of meta data and data dictionaries (b) data warehouse designs, use, and terminology 
Analysis                                                                                                                                                                                                                                                   
Outcomes
1,6                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  
The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 14 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 10 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is demonstrated by correctly answering 7 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management The artifact demonstrates the student ability to differentiate information in an organizational structure. Analysis is not demonstrated by correctly answering less than six 7 out of 14 questions of the type: (a) components of a Database Management System or DBMS (b) techniques used ot store and access data within a DBMS (c) data management and data base management 
Application                                                                                                                                                                                                                                                
Outcomes
4                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates student ability to use principles as they relate to core course topics. Application is demonstrated by correctly answering 13 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage The artifact demonstrates student ability to use principles as they relate to core course topics. Application is demonstrated by correctly answering 10 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage The artifact demonstrates student ability to use principles as they relate to core course topics. Application is demonstrated by correctly answering 7 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage The artifact demonstrates student ability to use principles as they relate to core course topics. Application is not demonstrated by correctly answering less than 7 out of 13 questions regarding organization perspective of managing data, including (a) efficiency (b) privacy and security (c) ethical responsibility (d) strategic advantage 
Content of Communication                                                                                                                                                                                                                                   
Outcomes
2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is demonstrated by correctly answering 3 out of 3 questions regarding: (a) duties of data administration (b) duties of data base administration The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is demonstrated by correctly answering 2 out of 3 questions regarding: (a) duties of data administration (b) duties of data base administration The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is demonstrated by correctly answering 1 out of 3 questions regarding: (a) duties of data administration (b) duties of data base administration The artifact demonstrates student ability to explain accepted practices in managing data base systems. Ability is not demonstrated by answering questions regarding: (a) duties of data administration (b) duties of data base administration 
Technical Skill in Communicating                                                                                                                                                                                                                           
Outcomes
8                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 8 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 6 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is demonstrated by correctly answering 4 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL The artifact demonstrates the student ability to proficiently use terminology related to specific course area. Use of terminology is not demonstrated by correctly answering less than 4 out of 8 questions regarding (a) explaining fundamentals of Structured Query Language or SQL (b) applying fundamentals SQL 

Copyright:

This material is protected by copyright and can not be reused without author permission.

Last Updated:7/15/2008 4:53:44 PM