Romania Clasa a XII-a ICT (natural sciences)

1. Modern user skills

Why databases

• Database Concepts: DBMS, Relations and Keys – Keeping data in separate files causes duplication, inconsistency and poor security. A database stores related data in one organised place, and a DBMS (like MySQL) is the software that manages it. In the relational model, data is kept in tables (relations) made of columns (attributes) and rows (tuples); a domain is the set of allowed values of a column. A candidate key uniquely identifies each row; one is chosen as the primary key and the others are alternate keys.

2. Working with a database application

Microsoft Access

• Database Concepts: DBMS, Relations and Keys – Keeping data in separate files causes duplication, inconsistency and poor security. A database stores related data in one organised place, and a DBMS (like MySQL) is the software that manages it. In the relational model, data is kept in tables (relations) made of columns (attributes) and rows (tuples); a domain is the set of allowed values of a column. A candidate key uniquely identifies each row; one is chosen as the primary key and the others are alternate keys.
• Relational Databases: Tables, Rows, Columns and Keys – Keeping data in many separate files leads to repeated data, mismatched copies and hard searching, so we use a database managed by a DBMS. In the relational model data sits in tables called relations. A column is an attribute, a row is a tuple, and the set of allowed values for a column is its domain. The number of columns is the degree; the number of rows is the cardinality. A candidate key is any column (or set) that can identify every row uniquely; the one chosen is the primary key and the others are alternate keys. A foreign key is a column in one table that refers to the primary key of another table, linking them.

3. Project

Database project

Coming soon