Database Design and Development – CSIS 525

CG • Section 8WK • 11/08/2019 to 04/16/2020 • Modified 07/28/2020

Course Description

Focused on the advanced design and development of databases, students will learn how to architect data storage solutions that are highly dynamic and scalable to meet the rapidly changing needs of business. Areas will include, but are not limited to, client-server processing, parallel processing, distributed, and multidimensional databases. Students will learn how to design database management systems that scale to meet the needs of rapidly changing and competitive business environments.

Prerequisites

(CSIS 505 and Meets BMAL590 / 27 hrs in BUSI with a score of 3 and Meets MATH121 or higher with a score of 3 and Meets MATH201/BUSI230/hi/equiv with a score of 3 and Meets CSIS 212 or equivalent with a score of 3 and Meets CSIS 312 or equivalent with a score of 3 and Meets CSIS330 /CSIS331 / equiv with a score of 3) or (INFO 505 and Meets BMAL590 / 27 hrs in BUSI with a score of 3 and Meets MATH121 / higher with a score of 3 and Meets MATH201/BUSI230/hi/equiv with a score of 3 and Meets BIOL102 / HLTH221 /equiv with a score of 3)

Rationale

CSIS 525 fulfills a core competency in the Masters in Information Technology program. This course covers advanced database development and the concepts of managing database environments.

Measurable Learning Outcomes

Upon successful completion of this course, the student will be able to:

  1. Discuss the relevance of course material and the use of information technology to a biblical worldview.
  2. Justify the importance of dynamic and scalable database solutions.
  3. Examine the innovative practices of database design.
  4. Assess integrative database development processes.
  5. Design a database management system that fulfills changing business requirements.

Course Assignment

Textbook readings and lecture presentations

Course Requirements Checklist

After reading the Course Syllabus and Student Expectations, the student will complete the related checklist found in Module/Week 1.

Discussion Board Forums (5)

Discussion boards are collaborative learning experiences. Therefore, the student will create a thread in response to the provided prompt for each forum. Each thread must be 400–500 words and demonstrate course-related knowledge. For each thread, the student must support his or her argument with at least 4 citations in current APA format. In addition to the thread, the student will reply to at least 2 other classmates’ threads. Each reply must be 200–250 words and incorporate at least 2 citations in current APA format. Acceptable sources include peer-reviewed journal articles, books, the course textbook, and the Bible.

Homework (5)

The student will complete 5 homework assignments. Each assignment will consist of a variable number of questions that are focused on the textbook readings. All homework assignments must be typed into a Microsoft Word document and include screenshots.

Research Papers (2)

The student will write 2 research-based papers that each focus on a topic from the textbook readings. The topic will be of his or her choosing and must be approved by the instructor. Each paper must be at least 2,000 words and be in current APA format. Each paper will be completed in 3 parts: Topic Approval, References and Sentence Outline, and Final Draft. Each paper must include at least 7 references. Acceptable sources include peer-reviewed journal articles, books, the course textbook, and the Bible.

Projects (2)

The student will design and create 2 database projects that each meet a real-life need. Each project will include a design and development phase with ER Diagram and tables as well as a data analysis phase with advanced data mining queries. Screenshots must be included for these projects.

Midterm Exam

The Midterm Exam will cover the Starks, Pratt, & Last readings for Modules/Weeks 1–4. The exam will be open-book/open-notes, contain 50 multiple-choice questions, and have a time limit of 2 hours.

Final Exam

The Final Exam will be comprehensive; it will cover all Starks, Pratt, & Last readings for Modules/Weeks 1–8. The exam will be open-book/open-notes, contain 50 multiple-choice questions, and have a time limit of 2 hours and 30 minutes.