Welcome to CS403: Introduction to Modern Database Systems

Specific information about this course and its requirements can be found below. For more general information about taking Saylor Academy courses, including information about Community and Academic Codes of Conduct, please read the Saylor Student Handbook.

 

Course Description

This course is a study of database architecture and the components used in implementation. Using the Structured Query Language, topics including file structures and access methods; database modeling, design and user interface; components of database management systems; information storage and retrieval are explored. 

 

Course Introduction

Though we may not recognize them in our everyday activities, databases are everywhere. They are hidden behind your online banking profile, airline reservation systems, medical records, and even employment records. This course will provide students with a general overview of databases, introducing you to database history, modern database systems, the different models used to design a database, and Structured Query Language (SQL), which is the standard language used to access and manipulate databases. Many of the principles of database systems carry to other areas in computer science, especially operating systems. Databases are often thought of as one of the core computer science topics, since many other areas in the discipline have been derived from this area.

This course is comprised of the following units:

  • Unit 1: Introduction to Modern Database Systems
  • Unit 2: Database Architecture and Date Languages
  • Unit 3: Database History
  • Unit 4: The Entity Relationship Model
  • Unit 5: The Relational Database Model
  • Unit 6: Relational Algebra
  • Unit 7: Introduction to Data Normalization 
  • Unit 8: Introduction to SQL
  • Unit 9: Basic Select Statements
  • Unit 10: The Join Statement

 

Course Learning Outcomes

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

  • draw a system diagram of a database management system showing its structure and functions;
  • identify the various people involved in database management systems;
  • explain the historical background of database management systems (DBMSes) and relate early DBMS problems and challenges to the current state of DBMS technology;
  • demonstrate the functions of a database management system;
  • develop an entity-relationship model based on user requirements;
  • perform the process of normalization;
  • convert an entity-relationship diagram to a set of normalized relations;
  • explain referential integrity and give an example of relations where it is not satisfied; and
  • use relational algebra to construct queries.

Throughout this course, you'll also see related learning outcomes identified in each unit. You can use the learning outcomes to help you organize your learning and gauge your progress.

 

Course Materials

The primary learning materials for this course are readings, lectures, video tutorials, and other resources.

All course materials are free to access, and can be found through the links provided in each unit and subunit of the course. Pay close attention to the notes that accompany these course materials, as they will instruct you as to what specifically to read or watch at a given point in the course, and help you to understand how these individual materials fit into the course as a whole. You can also access a list all of the materials used in this course by clicking on Resources in the course's "Activities" menu.

 

Evaluation and Minimum Passing Score

Only the final exam is considered when awarding you a grade for this course. In order to pass this course, you will need to earn a 70% or higher on the final exam. Your score on the exam will be tabulated as soon as you complete it. If you do not pass the exam on your first attempt, you may take it again as many times as needed, following a 7-day waiting period between each attempt. Once you have successfully passed the final exam you will be awarded a free Saylor Certificate of Completion.

Any unit assessments and other types of quizzes in this course are intended to help you to gauge how well you are learning and do not factor into your final course grade. You may retake all of these as many times as needed to feel that you have an understanding of the concepts and material covered. You can locate a full list of these sorts of assessments by clicking on Quizzes in the course's "Activities" menu.

 

Earning College Credit

This course provides students the opportunity to earn actual college credit. It has been reviewed by Brandman University and can applied as credit towards a degree by students who are currently enrolled or plan to enroll at Brandman. You can read more about this special program here.

If you are seeking to earn college credit at Brandman, you must take and pass the version of the exam titled "Proctored Final Exam." That exam will be password protected.

Note: There is a 14-day waiting period between attempts of the Direct Credit final exam. There is no imposed wait period between attempting the non-credit certificate-bearing exam and the credit exam. Some credit exams have a maximum number of attempts allowed, which will be detailed on the exam's instructions page.

 

Tips for Success

CS403: Introduction to Modern Database Systems is a self-paced course in which you the learner determines when you will start and when you will complete the course. There is no instructor or predetermined schedule to follow. While learning styles can vary considerably and any particular student will take more or less time to learn or read, we estimate that the "average" student will take 42 hours to complete this course. We recommend that you work through the course at a pace that is comfortable for you and allows you to make regular (daily, or at least weekly) progress. It's a good idea to also schedule your study time in advance and try as best as you can to stick to that schedule.

Learning new material can be challenging, so below we've compiled a few suggested study strategies to help you succeed:

  • Take notes on the various terms, practices, and theories as you read. This can help you differentiate and contextualize concepts and later provide you with a refresher as you study.
  • As you progress through the materials, take time to test yourself on what you have retained and how well you understand the concepts. The process of reflection is important for creating a memory of the materials you learn; it will increase the probability that you ultimately retain the information.
  • Although you may work through this course completely independently, you may find it helpful to connect with other Saylor Academy students through the discussion forums. You may access the discussion forums at https://discourse.saylor.org.

 

Suggested Prerequisites

In order to take this course, you should:

  • have access to a relational database management system, such as the open-source MySQL (dev.mysql.com); and
  • have completed CS201: Elementary Data Structures.

Technical Requirements

This course is delivered fully online. You will be required to have access to a computer or web-capable mobile device and have consistent access to the internet to either view or download the necessary course resources and to attempt any auto-graded course assessments and the final exam.

  • To access the full course including assessments and the final exam, you will need to be logged into your Saylor Academy account and enrolled in the course. If you do not already have an account, you may create one, free of charge, here. Although you can access some course resources without being logged into your account, it's advised that you log in to maximize your course experience. For example, some of the accessibility and progress tracking features are only available when you are logged in.
  • If you plan to attempt the optional credit recommended final exam that accompanies this course, then you will also need access to a webcam enabled computer. A webcam is needed so that our remote proctoring service can verify your identity, which will allow Saylor Academy to issue an official transcript to schools on your behalf.

For additional technical guidance check out Saylor Academy's tech-FAQ and the Moodle LMS tutorial.

 

Fees

There is no cost to access and enroll in this course. All required course resources linked throughout the course, including textbooks, videos, webpages, activities, etc are accessible for no charge. This course also contains a free final exam and course completion certificate.

This course does contain an optional final exam that will provide students an opportunity to earn college credit. Access to the exam itself is free, though it does require the use of a proctoring service for identity verification purposes. The cost for proctoring is $25 per session.


Last modified: Monday, July 22, 2019, 4:28 PM