Database Management Systems – CSIS 325

CG • Section 8WK • 11/08/2019 to 04/16/2020 • Modified 05/03/2022

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.

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

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

Discussions are collaborative learning experiences. Therefore, the student is required to create a thread in response to the provided prompt. The student will post one thread of at least 300 words. The student will then post 2 replies of at least 150 words. For each thread, students must support their assertions with at least 4 scholarly citations in APA format. Each reply must incorporate at least 2 scholarly citation(s) in APA format. Any sources cited must have been published within the last five years. Acceptable sources include the textbook, the Bible, etc.

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 assignment must be typed into a Word document, include screenshots, and be submitted through Canvas.

The student will write a 1,500-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 Entity-Relationship (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 quiz will address the Learn material for the weeks that have been covered to date.