Vi ste ovdje
Database Systems and Relational Databases
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 Objectivesrecognize 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
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
Trajanje:
2 h
Šifra:
df_dbfn_a01_it_enus
Koraci do učenja
Prijavite se, a ako nemate korisničko ime, registrirajte se.
Pronađite edukacijske programe u Katalogu i Certifikaciji, ili koristite polje za pretragu.
Upisani programi dostupni su u meniju Korisnik, Moji tečajevi.
Trebate pomoć?
- Česta pitanja - FAQ
- telefon: +385 1 6558 440
- email: support@cognita.hr
- Kontakt forma
