Syllabus Entrance
Printer Friendly
Email Syllabus

IS 361 Data Management Concepts
DeWispelare, Aaron R.


Mission Statement: Park University provides access to a quality higher education experience that prepares a diverse community of learners to think critically, communicate effectively, demonstrate a global perspective and engage in lifelong learning and service to others.

Vision Statement: Park University, a pioneering institution of higher learning since 1875, will provide leadership in quality, innovative education for a diversity of learners who will excel in their professional and personal service to the global community.

Course

IS 361 Database Management Concepts

Semester

S1T 2013 DL

Faculty

DeWispelare, Aaron R.

Title

Professor of Computer Science & Mathematics/Adjunct Faculty

Degrees/Certificates

Ph.D. Systems Engineering, University of Virginia
M.S. Systems and Electrical Engineering, Air Force Institute of Technology
B.S., Mechanical Engineering;  B.S. Electrical

Office Location

San Antonio, TX

Office Hours

8:00 - 5:00 M-W-F

Daytime Phone

830-981-2357

Other Phone

210-416-5292

E-Mail

aaron.dewispelare@park.edu

adewisp@gvtc.com

Semester Dates

S1T 2013 January 14, 2013 to March 10, 2013

Class Days

Online

Class Time

Online

Prerequisites

CS 219

Credit Hours

3


Textbook:

Hoffer, Jeffrey A., Ramesh, V., Topi, Heikki, Modern Database Management, Eleventh Edition, Prentice Hall, 2013, ISBN-13: 9780132662253

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/.
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 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.
FAQ's for Online Students - You might find the answer to your questions here.


Course Description:

Data Management Concepts: This course provides an overview of data management concepts. This course will explore the enterprise perspective of managing data needs of an organization. This includes data integrity, database models, and integration of database, security, and database administration issues. The student learner will be introduced to query processing within a database environment. 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 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

  1. Analyze the differences between Data and Database management
  2. Explain the duties of the data and database administrator.
  3. Describe the creation and use of metadata and data dictionaries.
  4. Identify the organizational perspective of managing data such as efficiency, privacy, security, ethical responsibility, and strategic advantage
  5. Compare a Relational Database and Object Orientated Database.
  6. Analyze components of a Database Management System and the techniques used to store and access data within DBMS.
  7. Describe a Data Warehouse including possible designs, use and terminology.
  8. Explain and apply the fundamentals of Structured Query Language (SQL).


  Instructor Learning Outcomes
  1. Analyze the differences between Data and Database management
  2. Explain the duties of the data and database administrator
  3. Describe the creation and use of metadata and data dictionaries
  4. Identify the organizational perspective of managing data such as efficiency, privacy, security, ethical responsibility, and strategic advantage
  5. Compare a Relational Database and Object Orientated Database
  6. Analyze components of a Database Management System and the techniques used to store and access data within DBMS
  7. Describe a Data Warehouse including possible designs, use and terminology
  8. Explain and apply the fundamentals of Structured Query Language (SQL).
Core Assessment:
Exams
Short Essay questionsProblem Solving, e.g. hands on SQL assignments
True/False plus justification for the answer
Homework Assignments
Short Essay questions
Problem Solving
True/False plus justification for the answer
Paper
Write a short review/essay paper about a subject in database technology







Class Assessment:

Evaluation Criteria for Grading

Weekly Activities to Submit Via Dropbox

  • 1.0 Questions. To earn full credit, each submission must –
  • 1.1 Address all aspects/parts of the question(s).
  • 1.2 Show a thorough understanding of question(s) posed in your answer/position.
  • 1.3 Exhibit critical thinking and analytical skills in supporting your answer/position.
  • 2.0 In answering the question(s), ensure you follow guidelines stated in the question(s).
  • 2.1 Answer/position should be about 100-150 words in length.
  • 2.2 Formatting must conform to APA style.
  • 2.3 All answers/positions must be supported by appropriate academic references (worth 20 -25% of each activity). See the course FAQs on how to properly cite and complete citations from various sources including the text book and the student’s own personal experiences.
  • 2.4 Use American Standard English with correct grammar, punctuation, sentence structure, and spelling.
  • 3.0 Activities must be submitted via Dropbox.
  • 3.1 Activities must be submitted as an attachment to the Dropbox in MS Word, and the student must identify themselves by name on each sheet of any attachment.
  • 3.2 Activities must be submitted on due date or late penalty will be imposed (50% penalty for each day late).
  • 1.0 Internet Research. To earn full credit, each submission must –
  • 1.1 Address all aspects/parts of the internet research exercise.
  • 1.2 Show a thorough understanding of internet research exercise in your answer/position.
  • 1.3 Exhibit critical thinking and analytical skills in supporting your answer/position.
  • 2.0 In responding to the internet research exercise, ensure you follow guidelines stated in the internet research exercise.
  • 2.1 Answer/position should be about 100-150 words in length.
  • 2.2 Formatting must conform to APA style.
  • 2.3 All answers/positions must be supported by appropriate academic references (worth 20 -25% of each activity). See the course FAQs on how to properly cite and complete citations from various sources including the text book and the student’s own personal experiences.
  • 2.4 Use American Standard English with correct grammar, punctuation, sentence structure, and spelling.
  • 3.0 Activities must be submitted via Dropbox.
  • 3.1 Activities must be submitted as an attachment to the Dropbox in MS Word, and the student must identify themselves by name on each sheet of any attachment.
  • 3.2 Activities must be submitted on due date or late penalty will be imposed (50% penalty for each day late).
  • 1.0 Homework. To earn full credit, each submission must –
  • 1.1 Address all aspects/parts of the homework problems.
  • 1.2 Show a thorough understanding of homework problems in your answers.
  • 1.3 Exhibit critical thinking and analytical skills in supporting your answers.
  • 2.0 In responding to the homework problems, ensure you follow guidelines stated in the homework problems.
  • 2.1 Answers should include appropriate diagrams as stated in the problems.
  • 2.2 All answers must be supported by appropriate academic references (worth 20 -25% of each activity) including those for the homework problems from the text book. See the course FAQs on how to properly cite and complete citations from various sources including the text book and the student’s own personal experiences.
  • 2.3 Use American Standard English with correct grammar, punctuation, sentence structure, and spelling.
  • 3.0 Homework problems must be submitted via Dropbox or fax for hand drawn diagrams.
  • 3.1 Homework problems must be submitted as an attachment to the Dropbox in MS Word or faxed for hand drawn diagrams, and the student must identify themselves by name on each sheet of any attachment or fax.
  • 3.2 Homework problems must be submitted on due date or late penalty will be imposed (50% penalty for each day late).

Weekly Discussion Participation

  • 1.0 Discussion. To earn full credit, a discussion topic, issue, or question  which you discuss must –
  • 1.1 Respond directly to all parts of the discussion topic, issue, or question. You can respond independently, or piggy back off another student’s comments, but you must address all parts of the discussion topic yourself. 
  • 2.0 Clearly and concisely summarize your answer/position.
  • 2.1 Demonstrate critical thinking, be logical, and support arguments with evidence. All answers/positions must be supported by appropriate academic references (worth 20 - 25% of each activity). See the course FAQs on how to properly cite and complete citations from various sources including the text book and the student’s own personal experiences.
  • 3.0 Be approximately 100 - 150 words in length.
  • 3.1 Post to the Discussion Forum by the due date or late penalty will be imposed (50% penalty for each day late).
  • 3.2 Use American Standard English with correct grammar, punctuation, sentence structure, and spelling.
  • 4.0 I typically will infrequently join the discussions so as not to intimidate or otherwise bias or constrain the flow of the discussions until toward the end of the discussion or in weekly feedback to the students.

Grading:

  Overall Course Grading

  • The exam will count 20% of your total grade. You will know in advance the standards for each assignment. My goal is to give you prompt, clear, and useful feedback to help you become a better writer and thinker. You will be able to track your average exactly throughout the course. Each student is responsible for:
    • Completing Weekly Reading  Assignments .
    • Completing Weekly assigned Activities (Questions, Internet Research, and Homework), and submitting them to the instructor.
    • Participating in the weekly on-line Discussion.
    • Completing a Final Proctored Examination.

Assignments % of Grade

    • Weekly Tasks (15 tasks, 790 points total) 79%

 (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%

    • Proctored Final Examination (200 points) 20%

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 =

90- 100%

B =

80-89%

C =

70-79%

D =

60-69%

F =

< 60%

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 (in order to protect the integrity of the course grading).

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 2012-2013 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. Course Incompletes will only be considered for students who have a personal documented medical emergency during the term. 

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.

Course Topic/Dates/Assignments:

Course Schedule 

  

Week 1: Introduction to Databasing  

  • Readings: Text: Read Chapter 1
  • Overview: 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. Chapter 1 continues with a coverage of the steps taken in a database development and compare them with the steps for a typical software development effort. We see our first database application toward the end of Chapter 2 for the Pine Valley Furniture Company, which includes examples of database tables implemented in Microsoft (MS) Access (a popular PC based Database Management System [DBMS]).
  • Class Activities/Weekly Tasks (see topics for details): Discussion Topic Thread Participation and Activity Question(s).

 

Week 2: Query By Example (QBE)   

  • Overview: An example of the Graphical User Interface (GUI) for MS Access is shown on the publisher’s student resources web site at ( http://wps.prenhall.com/bp_hoffer_mdm_9/85/21941/5616992.cw/index.html - select the tab labeled “Seventh Edition QBE Resources” located on the left side of the screen). This example under links for the 7th Edition, Chapter 2 QBE material (pp. 68 – 70, Figures 2-15, 2-16 and 2-17) and Chapter 9 QBE material (pp. 375 – 384, Figures 9 -10, 9-11, 9-12, 9-13, 9-14, 9-15, 9-16 and 9-17) provides a detailed look at a vendor’s implementation of Query By Example (QBE) as a GUI based interface to a relational database. The use of MS Access in this detailed example show the utility of this approach to ad hoc querying for a vendor produced DBMS.
  • Class Activities/Weekly Tasks (see topics for details): Discussion Topic Thread Participation and Activity Homework Problems.
  • eProctor website will open this week. Please complete your Proctor Final Exam Request form and submit to arrange for a proctor which is required for your final exam.

 

Week 3: Data Modeling/Entity-Relationship Diagrams   

  • Readings: Text: Read Chapter 2 and Appendix A.
  • Overview: During Week 2, we'll introduce data modeling constructs by investigating both the Entity-Relation (E-R) model (for a general database application) in Chapter 2. We will see that E-R diagrams provide for an efficient graphical tool to document a database data model. The concept of “business rules” in the context of database applications is introduced and presented in Chapter 2.
  • Class Activities/Weekly Tasks (see topics for details): Discussion Topic Thread Participation and Activity Homework Problems.

 

Week 4: Logical Database Design/Relational Model/Normalization

  • Readings: Text: Read Chapter 4.
  • Overview: During Week 4, Chapter 4 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 in detail to promote understanding of the relational database model.
  • Class Activities/Weekly Tasks (see topics for details): Discussion Topic Thread Participation and Activity Homework Problems.

 

Week 5: Physical Database Design and Client/Server Architectures 

  • Readings:Text: Read Chapters 5 and 8.
  • Overview: 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. In Chapter 5, 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. Chapter 8 continues 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. Chapter 8 includes a discussion of popular application interfaces for databases. Additionally, Chapter 8 discusses the web based popular alternative to the client/server architectures for hosting databases. Applications examples are provided for the internet environment associated with databases.
  • Class Activities/Weekly Tasks (see topics for details): Discussion Topic Thread Participation and Activity Internet Research.

 

Week 6: Structured Query Language (SQL) 

  • Readings:Text: Read Chapter 6
  • Overview: During Week 6, Chapter 6 introduces 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.
  • Class Activities/Weekly Tasks (see Conference Threads for details): Discussion Topic Thread Participation and Activity Homework Problems.

Week 7: Data and Database Administration, and Database Security

  • Readings: Text: Read Chapter 11.
  • Overview:During Week 7, Chapter 11 examines 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.
  • Class Activities/Weekly Tasks (see topics for details): Activity Question(s).

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.

  • The student will take a timed and proctored final exam. It is the student’s responsibility to schedule the proctored exam with the appropriate official proctor, and the student is encouraged to do so at the earliest opportunity. The completed exams are due to me by Friday of the eighth week of the term at 5:00 PM Eastern Time. This will be a timed closed book and closed notes comprehensive proctored exam covering all material presented in the course.

·         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 95-96

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 95

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.
ONLINE NOTE: Students must participate in an academically related activity on a weekly basis in order to be marked present in an online class. Examples of academically-related activities include but are not limited to: contributing to an online discussion, completing a quiz or exam, completing an assignment, initiating contact with a faculty member to ask a course related question, or using any of the learning management system tools.

Park University 2011-2012 Undergraduate Catalog Page 98

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 .

Additional Information:
 

Rubric



   
       
           
           
           
           
           
       
       
           
           
           
           
           
       
       
           
           
           
           
           
       
       
           
           
           
           
           
       
       
           
           
           
           
           
       
       
           
           
           
           
           
       
       
           
           
           
           
           
       
   

           

Competency


           

           

Exceeds 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:12/26/2012 5:42:13 AM