Syllabus Entrance
Printer Friendly
Email Syllabus

IS 362 Applied Database Management
Wakeman, Jeremy


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

IS 362 Applied Database Management

Semester

SP 2010 HOZ

Faculty

Wakeman, Jeremy

Degrees/Certificates

MBA Northwest Missouri State University
BS Mathematics / Computer Information Systems Lincoln University

Office Location

SC016B - Outer Office

Office Hours

M-W-F 9:00 – 10:00 & M-W 3:00 – 4:15

Daytime Phone

(816) 305-5564

E-Mail

Jeremy.Wakeman@park.edu

Semester Dates

January 11, 2010 - May 7, 2010

Class Days

-M-W---

Class Time

4:30 - 5:45 PM

Prerequisites

IS361

Credit Hours

3


Textbook:

Modern Database Management (9th Edition) Prentice Hall 2009, Author Hoffer, Prescott, Topi
ISBN: 978-0-13-600391-5


NOTE: This is the same textbook that is used in IS 361

Textbooks can be purchased through the MBS bookstore

Textbooks can be purchased through the Parkville 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.
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:
IS362 Applied Database Management: This course builds on the Data Management Concepts\course and focuses on the creation, administration and use of databases. This course assumes knowledge of database system concepts. The student learner will be introduced to application program development in a database environment with emphasis on setting up, modifying, and querying a database. 3:0:3 Prerequisite: CS219

Learning Outcomes:
  Core Learning Outcomes

  1. Explain and apply the fundamentals of Structured Query Language (SQL).
  2. Use SQL to create the tables, build report forms and create queries for updating and displaying data within a database.
  3. Utilize SQL to build queries to extract data from multiple tables based on selection criteria.
  4. Design and build a relational database.
  5. Assess the duties of the database administrator.
  6. Identify the creation and use of metadata and data dictionaries.
  7. Identify the issues surrounding design of an effective database solution such as concurrency, efficiency, management of and security.
  8. Use Case Tool(s) to design database schemas.
  9. Describe the role of web-enabling databases, object-oriented database, and relational database.


Core Assessment:

Class Assessment:

Case Studies

Chapters 3, 4, 5, 6, 9, 10, and 11 have case studies that give some practical knowledge from material in the textbook. The due dates are listed below. Each Case study is worth 50 points.

 

Project #1

The project consists of creating a database in SQL with at least 5 tables. This is open for each student to choose what they want their project is to cover, (example, point-of-sale system, student record/job application, etc.). This is your chance to be creative. The deliverables will be a walk-through of the database and an Entity-Relationship Model. The project will be worth 100 Points.  

 

Project #2

This project will be exactly the same as project #1 except will be an object-oriented database. The deliverable for this project will just be a walk-through. The project will be worth 100 points.

 

Paper

The paper will be a position paper describing the pros and cons of using SQL and object-oriented languages for databases. Then after that is described then state which method you prefer, what do you think the future will be for each and why. The paper will be worth 100 points.

 

Exams

Exams will consist of Multiple Choice, and Short Answer questions that will be taken from the textbook and class discussions. Both the mid-term and final will be 100 points each.

 

There will be no make-up exams.

Grading:

 Grades Per Assignment

Deliverable

Qty

Points

Case Studies

7 / 50 points each

350 Points

Project #1 (SQL)

1

100 Points

Project #2 (Object-Oriented)

1

100 Points

Paper

1

100 Points

Mid-Term Exam

1

100 Points

Final Exam

1

100 Points

 

 Final Grades

 A = 100% - 90% {Points 850 - 765}

 B = 89.9% - 80% {Points 764 - 680}

 C = 79.9% - 70% {Points 679 - 595}

 D = 69.9% - 60% {Points 594 - 510 }

 F = 59.9% and Below {Less than 509 points}

Late Submission of Course Materials:

If an assignment is going to be late please notify me by email the day before the assignment due date to make arrangements to turn in the assignment otherwise it will be considered late. There will be no make-up exams.

Classroom Rules of Conduct:

Be seated and ready to start class on time. Since the class will be interactive computers should only be used for taking notes. Since this is an Independent study time of class will be flexible.

Course Topic/Dates/Assignments:

Class Schedule
Week 1 11-Jan 13-Jan

Class Expectations, Chapter 3 Chapter 3
Week 2 18-Jan 20-Jan

M.L. King Jr. Day (No Class) Chapter 3, Case for Chapter 3 Due
Week 3 25-Jan 27-Jan

Chapter 4 Chapter 4
Week 4 1-Feb 3-Feb

Case for Chapter 4 Due, Chapter 5 Chapter 5
Week 5 8-Feb 10-Feb

Chapter 5, Chapter 6 Case for Chapter 5, Chapter 6
Week 6 15-Feb 17-Feb

Presidents Day (No Class) Chapter 6
Week 7 22-Feb 24-Feb

Case for Chapter 6 Due, Chapter 9 Chapter 9, Chapter 10
Week 8 1-Mar 3-Mar

Chapter 10 Mid-Term, Case for Chapter 9 & 10 Due 5-Mar
Week 9 8-Mar 10-Mar

Spring Break Spring Break
Week 10 15-Mar 17-Mar

Chapter 11 Chapter 11
Week 11 22-Mar 24-Mar

Chapter 11 Chapter 11, Chapter 15
Week 12 29-Mar 31-Mar

Case for Chapter 11 Due, Chapter 15 Chapter 15
Week 13 5-Apr 7-Apr

Chapter 16 Chapter 16
Week 14 12-Apr 14-Apr

Lab Time Lab Time
Week 15 19-Apr 21-Apr

SQL Project Due, Lab Time Object-Oriented Project Due
Week 16 26-Apr 28-Apr

Paper Due, Review for Final Review for Final
Week 17 3-May 5-May
  Final Exam (Flexible)  




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 2009-2010 Undergraduate Catalog Page 92

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 2009-2010 Undergraduate Catalog Page 95

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 .

Copyright:

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

Last Updated:1/5/2010 4:10:05 PM