Syllabus Entrance
Printer Friendly
Email Syllabus

CS 360 Database Management
Tankins, Edwin S.


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 BU

Semester

U1H 2008 BU

Faculty

Tankins, Edwin S.

Title

INSTRUCTOR CS

Degrees/Certificates

BS METALLURGICAL ENG
MS METALLURGICAL ENG

Office Location

MCAS BEAUFORT, BUILDING 596 ROOM 213

Office Hours

1630 - 1700 hrs

Daytime Phone

(843) 342 - 5050

E-Mail

Edwin.Tankins@park.edu

tankins@hargray.com

Semester Dates

6 June - 31 July 05

Class Days

--T-R--

Class Time

7:35 - 10:05 PM

Prerequisites

CS 140

Credit Hours

3


Textbook:
Hoffer,Jeffrey &McFadden,Fred & Prescott, Mary, (2005) Modern Database Management 9th Edition Upper Saddle River, NJ: Pearson Education, Inc.

Textbooks can be purchased through the MBS bookstore

Textbooks can be purchased through the Parkville Bookstore

Additional Resources:
Mannino,(2004)Database Application and Administration, 2nd Edition, McGraw Hill,

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:
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 believe learning should be an enjoyable, challenging exxperience. I try to bring real world experiences to the class room. I try to bring excitement to learning by various approaches and grading criteria producing successful students. The facilitator's educational philosophy is one of interactiveness based on lectures, readings, quizzes, dialogues, examinations, internet, special projects and writings. The facilitator will engage each learner in what is referred to as disputational learning to encourage the lively exploration of ideas, issues, and contradictions. I encourage students to call me at home whenever they need help.

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:
Students are required to read all assigned material prior to class.Homework will be completed prior to class and will be reviewed during class. Complete a database project to demonstrate knowledge of the concepts covered in class. There will be quizzes, a midterm and final exam. Assign a sufficient amount of homework and lab projects such that all the above objectives are met. Exams will include one or more of: Short answers, multiplechoice, True/False, and completion.

Grading:

Grading weights are as follows: homework/quizzes 15%, Laboratory/ special projects 10%, Mid-Term 30%, Final exam 40%, and participation 5%. Your overall score is determined as follows: (your_total_hw-quizz_pts/max_hw-quizz_pts)*15 + (your_total_labwork_pts/max_lab_pts)*10 + (your_total_part_pts/max_part_pts)*5 + (your_total_mid-term exam_pts/max_mid-term exam_pts)*30 + (your_total_final exam_pts/max_final exam_pts)*40  Letter grades are assigned (based on your overall score) as follows: 90 - 100 A ,80 - 89 B, 70 - 79 C, 60 - 69 D, and Less than 60 F.
 
Article Review 1. Choose an article from a current periodical(less than 12 months old) related to database management. 2. Summarize the article in 150 words or less. 3. Critique the article citing points of agreement or disagreement and explain why. 4. Please type your product. 5. Attach a copy of the article. 6. Prepare to share your information on 26 June! Project 1. Design an Access database that will meet your home or office neeeds. 2. Create an Entity-Relationship Diagram and its associated data structures. 3. Database will include: 3.1. two tables 3.2. input form with data validation 3.3. two reports 3.4. query utilizing two or more tables 4. Project is due on 24 July 2008. GOOD LUCK.          

Late Submission of Course Materials:
Homework must be turned in at the beginning of class on the day it is due. The date due will be annotated at the beginning of each assignment. Late homework will be accepted at the start of the next class meeting but will incur a 7 point (out of 100) reduction in score. The instructor will accept late assignments if extenuating circumstances exist.Late homework will not be accepted after a week past the due date and will receive an automatic zero for that assignment.

Classroom Rules of Conduct:
Students must read all assigned chapters for that night prior to that scheduled class meeting. Students are expected to be well prepared to discuss examples and assignments provided at the end of each chapter or handed out by the instructor. Students are expected to come to all classes and be on time. Classes missed for legitimate reasons: illnesses, death in the family, work assignments, temporary duty are excusable. The student s responsible for providing the instructor a reason for the excused absence either prior to or immediately after the absence.

Course Topic/Dates/Assignments:

DATE        CHAPTER                       TOPIC                                               ASSIGNMENT
 
3 June              I                      The Database Environment                        pp(31-32) # 1,3, 7 & 9
 
5 June              II                     The Database Dev Environment                pp(76-78) #4,5,
                                                                                                                           9,10-11
10 June            III                   Modeling Data in the organization              pp(137-146)
                                                                                                                       #1,5,6-8
12 June            IV                  The Enhanced E-R Model & Bus Rules      pp(188-193)#1,2,
                                                                                                                             6,8
17 June            V                    Log DB Design & the Relational Model     pp(243-250)#1,5,
                                                                                                                                 6,8 
19 June            VI                   Physical Database Design             pp(298-302)#1,5,9,15,18
                                                          & Performance
24 June            VII                  Introduction to SQL                     pp(349-353) #1,4,6,8,9
 
26 June                          MIDTERM EXAM               
 
1 July              VIII                   Advanced SQL                         pp(395-398) # 1,2,6,8,9
 
3 July               IX                    The Client/Server DB                 pp(421- 422) #1 - 5
                                                    Environment 
8 July                X                    The Internet DB Environment      pp(454-455) #1-6
 
10 July              XI                    Data Warehousing                     pp(509-514) #2,3,5,9,13-14
 
15 July              XIII                  Data & DB Administration        pp(609-612) #1,2,4,5,6
 
17 July              XIV                  Distributed Databases              Student presentation from
                                                                                                 the internet. Use the web
                                                                                                 site given in the textbook
22 July              XV                   Object Oriented Data  
                                                                       Modeling               "      "   "     "      "                                              
                                      
                         XVI                 Using Databases To
                                                 Provide Object   Persistence        "     "   "      "       "
 
 24 July                                 FINAL EXAMINATION
                   

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 2007-2008 Undergraduate Catalog Page 85-86

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 2007-2008 Undergraduate Catalog Page 85

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.
  3. Work missed through unexcused absences must also be made up within the semester/term of enrollment, but unexcused absences may carry further penalties.
  4. 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".
  5. A "Contract for Incomplete" will not be issued to a student who has unexcused or excessive absences recorded for a course.
  6. 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.
  7. 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 2007-2008 Undergraduate Catalog Page 87-88

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 copyright and can not be reused without author permission.

Last Updated:4/17/2008 12:33:16 PM