Database Systems and Relational Databases


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number


Overview/Description
A database is used by organizations to store their data, and allow their employees to access, update, and manage it. Organizations use a Database Management System, also known as a DBMS to control, store, organization and retrieve that data for the users through end-user applications. There are multiple types of database, such as flat-file, network, and hierarchical. The most widely used database is the relational database, which is based on a mathematical theory. A relational database stores data in relations, which are tables, that store data in rows or tuples and columns or attributes. The relational database is based on the relational model and consists of a relational schema which contains the database objects. This course discusses what database and DBMSs are, the different database models and the database architectures. It also discusses what relational databases are, its components, and how relational databases were identified by Dr. Edgar Codd, including the 12 rules that were identified that a database should adhere to be considered relational.

Target Audience
People who want to get a thorough understanding of the fundamentals of databases.

Expected Duration (hours)
2.0

Lesson Objectives

Database Systems and Relational Databases

  • recognize the differences between a database and a DBMS
  • recognize the different types of database users
  • identify the requirements of a good database
  • match the database architecture with its correct description
  • match the database model with its correct description
  • recognize the features of databases and DBMS
  • describe database models and database architectures
  • describe the features and recognize the types of relational databases
  • recognize how to model the database
  • describe how to outline a relationship database schema
  • describe the concept of referential integrity
  • recognize how to normalize the relations
  • describe relational database concepts
  • recognize the constructs in a relationship database schema
  • normalize database tables
  • Course Number:
    df_dbfn_a01_it_enus