IS 361 Data Management Concepts
S1T 2012 DLA
Hammond, Scott G.
MBA, MAFMMCSE, MCSD, MCT
Cape Coral, Fl US
Mon - Sat 9-6 PM EST
Textbook: Hoffer, Jeffrey A., Ramesh, V., Topi, Heikki, Modern Database Management, Tenth Edition, Prentice Hall, 2011
Textbooks can be purchased through the MBS bookstore
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 email@example.com or call 800-927-3024Resources for Current Students - A great place to look for all kinds of information http://www.park.edu/Current/.Advising - Park University would like to assist you in achieving your educational goals. Please contact your Campus Center for advising or enrollment adjustment information.Online Classroom Technical Support - For technical assistance with the Online classroom, email firstname.lastname@example.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.FAQ's for Online Students - You might find the answer to your questions here.
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 discussion questions which are posted on the appropriate public discussion threads, weekly homework assignments and weekly internet research assignments which are submitted to the appropriate private drop boxes, and a proctored 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
Evaluation Criteria for Grading
Weekly Activities to Submit Via Dropbox
Weekly Discussion Participation
Grading: Overall Course Grading
Assignments % of Grade
(Weekly Tasks consist of Discussion Participation and weekly Activities [Internet Research, Questions, and Homework Problems])
· Obtaining a proctor by the end of week 4 of the term (10 points) 1%
Guidelines for selecting an acceptable proctor can be found at the Park University Web Site. For proctored examinations, photo identification is required at the time of the test. A proctor request form will be made available to you during the first weeks of class so that you can send your requested proctor to me for approval. Failure to take a final proctored exam (or submit your final project for some online graduate courses) will result in an automatic "F" grade. I will give 10 points to students who have arranged for a proctor by the end of week 4.
Course Grading Scale - the total of all points received (total of all weekly assignments and final exam) will determine the student's letter grade as follows:
A grade of incomplete can only be given to students who have documented evidence of a medical emergency (the student themselves only).
Late Submission of Course Materials:
Submission of Late Work: There is a late submission penalty of 50% of the assignment value for each day late - see the course FAQs for more information on this policy.
Make-up Work: Because solutions to most of the assignments are published weekly along with submission critiques in order to provide rapid feedback, the nature of this course does not lend itself to any make-up work or any extra credit work.
Classroom Rules of Conduct:
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.
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.
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 ParkUniversity. ParkUniversity's academic honesty policy and related procedures can be found in full in the 2010-2011 Park University Undergraduate and Graduate Catalogs
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.
Students are expected to spend a substantial amount of time online and offline each week including but not limited to responding to the weekly conference discussions, sending/receiving Email, reading and viewing online lectures, completing online quizzes and tests, and conducting research over the World Wide Web. A rule of thumb is that you should spend a minimum of approximately 4-5 hours per week online reviewing course content, and engaging in the conference discussion and an additional 4-6 hours per week on readings, preparing assignments, or examinations.
Week 1: Introduction to Databasing
Week 2: Query By Example (QBE)
Week 3: Data Modeling/Entity-Relationship Diagrams
Week 4: Logical Database Design/Relational Model/Normalization
Week 5: Physical Database Design and Client/Server Architectures
Week 6: Structured Query Language (SQL)
Week 7: Data and Database Administration, and Database Security
Week 8: Introduction to Data Warehousing and Object-Oriented Databases and Proctored Final Exam
· Readings: Text: Read Chapters 9 and 13 (only an initial part of each chapter is present in our text), and read the remaining part of Chapter 13 on the publisher’s student resources web site at (http://wps.prenhall.com/bp_hoffer_mdm_10/161/41379/10593099.cw/index.html) - select the tab labeled “Chapters 12 – 14” located on the left side of the screen. Then select from among the links to navigate to Chapters 12, 13 or 14. The complete version of Chapters 12, 13, and 14 are found through these links).
· Overview:Chapter 9 examines one of 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 data mining and visualization, and the extract, transform, and load (ETL) process.Chapter 13 introduces the alternative database model of the object-oriented (OO) model. We compare the OO model with models covered earlier in course, and examine the provided examples of OO databases.
· Class Activities/Weekly Tasks (see topics for details): Activity Question(s) and the proctored 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 students and faculty members are encouraged to take advantage of the University resources available for learning about academic honesty (www.park.edu/current or http://www.park.edu/faculty/).from Park University 2011-2012 Undergraduate Catalog Page 93
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. from Park University 2011-2012 Undergraduate Catalog Page 93
Attendance Policy:Instructors are required to maintain attendance records and to report absences via the online attendance reporting system.
Park University 2011-2012 Undergraduate Catalog Page 96
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 .
Last Updated:12/16/2011 8:11:49 AM