Introduction to Modern Database Systems

View Resource

Read the Fine Print

Subject:

Science and Technology

Institution Name:

The Saylor Foundation

Collection:

Saylor Foundation

Grade Level:

Post-secondary

Abstract:

This course provides a general overview of databases, including topics such as 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. Upon successful completion of this course, the student will be able to: compare and contrast the database approach and the file system approach; explain what a database management system is as well as the various components; identify the various people involved in database management systems; explain the historical background of database management systems; compare the various database models; describe the functions of a database management system; explain the three-schema database architecture; describe what tables, indexes, and views are as well as discuss the differences among them; explain the entity-relationship model; develop an entity-relationship model based on user requirements; describe the relational database model; explain the process of normalization; convert an entity-relationship diagram to a set of normalized relations; explain referential integrity; identify how relational algebra is used to construct queries; describe and use data definition commands; describe and use data manipulation commands; explain how to join tables together for queries. (Computer Science 403)

Languages:

English

Material Type:

Assessments, Audio Lectures, Homework and Assignments, Readings, Syllabi, Video Lectures

Media Format:

Audio, Graphics/Photos, Text/HTML, Downloadable docs, Video

Conditions of Use:

Creative Commons Attribution-Noncommercial 3.0
You are welcome to share, remix, and adapt this course under the terms of the Creative Commons Attribution 3.0 Unported License; however, many linked materials within this course are copyright of their respective authors/owners and may not be openly-licensed. Please respect the copyright and terms of use associated with each resource.

Copyright Holder:

The Saylor Foundation