Welcome to CIS 205

Fall 2019 Section 001

Introduction to Database Management Systems

To follow the sequence of activities and assignments of this course , click on the Modules Tab on the left side of the screen

Course Overview

The class will have activities, assignments and reading material. As a result of using the Canvas LMS, in the course, all assignments, discussions and quizzes must be accessed online using the Canvas Learning Management System (LMS). These Assignments, will be a combination of Discussions, Quizzes, and Applied Database Assignments that can be accessed and submitted through Canvas. We will also have in class practice activities that will prepare you for the homework assignments. It will be your responsibility to participate in many of the homework activities outside of the scheduled hours for the course. The reference material in the modules will be available for your review throughout the semester. We begin this week by first going over the class Syllabus, and introducing some fundamental concepts and applications in database base management systems.

Course Description Computer Information Systems 205 - Database Management Systems 4 credits (8 hours lecture, 2 hours lab per week)

This course provides an introduction to the design and implementation of relational data base management systems using Structured Query Language (SQL). The course covers fundamental data base design and

implementation techniques and provides hands-on exercises for applying the techniques to real-world problems through the use of Enterprise Level Database Management software such as MySQL or Oracle.

Prerequisites: CIS 103 or (CSCI 111 and CSCI 112)

Upon completion of this course students will be able to:

Design and Create Conceptual Relational Database Using a professional modeling application
Implement Physical Database from a Conceptual Design
Work as part of a professional team to design, code, test and debug normalized databases
Correctly use the elements of Relational Algebra retrieving result sets from relational databases
Create source code and execute SQL statements that are syntactically correct
Demonstrate a knowledge of input and output routines, data types, and data operations
Demonstrate a knowledge of key concepts in Database Theory

Who Should Take Course and Why

This course is structured for student wanting advance training in designing, implementing and interacting with relational databases using professional Relational Database Management Systems RDMS. Additionally, students wanting to survey advanced concepts in the Database Theory, Database Programming, and Database Implementation should take this course.