Database Design and Development – CSIS 525

CG • Section 8WK • 11/08/2019 to 04/16/2020 • Modified 09/05/2023

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.

For information regarding prerequisites for this course, please refer to the Academic Course Catalog.

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.

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 the Course Overview.

Discussions (5)

Discussions are collaborative learning experiences. Therefore, the student will create a thread in response to the provided prompt for each discussion. 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.

Create Queries Homework Assignments (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 Paper Assignments (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 will be completed in 3 parts: Topic Approval, References and Sentence Outline, and Final Draft. The Topic Approval must be one paragraph and the Final Draft must be at least 2,000 words and be in current APA format. Each paper must include at least 7 references. Acceptable sources include peer-reviewed journal articles, books, the course textbook, and the Bible.

Research Project Assignments (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.

Quiz: Midterm

The Quiz: Midterm will cover readings for the assigned Module: Week. The quiz will be open-book/open-notes, contain 50 multiple-choice questions, and have a time limit of 2 hours.

Quiz: Final

The Quiz: Final will be comprehensive; it will cover the readings of the assigned Module: Week. The quiz will be open-book/open-notes, contain 50 multiple-choice questions, and have a time limit of 2 hours and 30 minutes.