Database Management Systems – CSIS 325

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

Course Description

The study of relational database architecture, design, access, administration and implementation in the context of various organizational environments. The course includes issues of data normalization, standard queries, and the use of popular relational and object technologies for building business-oriented applications. Assigned projects will provide hands-on experience with industry leading SQL and RDBMS tools and ER CASE tools currently popular in business and government settings. (Formerly BMIS 325)

Prerequisites

 (MATH 201 or BUSI 230 or MATH 211) and (CSIS 211 or CSIS 208 or CSIS 212)

Rationale

A foundation in database development is essential for a thorough understanding of information systems. This course introduces the fundamentals of database development and provides the student with a conceptual and practical application of database design.

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 technology to a biblical worldview (PLO 1 – R).
  2. Describe the characteristics of business database management systems (PLO 2 – R).
  3. Design a database that follows the rules of normalization and entity integrity using entity relationship diagrams (PLO 2 – I).
  4. Create a functional business database from an entity relationship diagram (PLO 3 – I).
  5. Generate queries using the Structured Query Language (PLO 2 – R).
  6. Manage data using the Database Manipulation Language (PLO 2 – R).
  7. Describe the concepts and structures that support a relational database management system: file storage/organization, indexing, hashing, query optimization, transaction management, concurrency, security, and database recovery (PLO 2 – I).

Course Assignment

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

Discussion boards are collaborative learning experiences. Therefore, the student is required to create a thread in response to the provided prompt for each forum.

The student will complete 7 Lab assignments. Each assignment will consist of a variable number of questions that are focused on applying concepts from the textbook readings. Each Lab assignment must be typed into a Word document, include screenshots, and be submitted using the link provided in the respective module/week’s Assignments folder.

The student will write a 2,000-word research-based paper in current APA format that focuses on a database topic of his/her choosing. The topic chosen must be approved by the instructor. The Research Paper will be completed in 3 parts: Topic Approval, References Page and Sentence Outline, and Final Draft. The paper must include at least 7 references, 1 of which may be the textbook and another of which may be the Bible. All other references must be from peer-reviewed sources.

The student will design and create a database project to meet a real-life need. The project will be submitted in 2 separate phases: a design and development phase with ER Diagram and tables and a data analysis phase with advanced data mining queries. Screenshots must be included in both phases of this project.

Each exam will address the Reading & Study material for the modules/weeks that have been covered to date.