System database. Fundamentals of database management systems: concept, characteristics, architecture. Data Model. Normalization.

Practical lesson 6
System database. Fundamentals of database management systems: concept, characteristics, architecture. Data Model. Normalization.The objective of the lesson: to give information about the design and structure of databases, work in MS Access and improvement of related software
Speaking: What database products do you know and use at workand at home?
Practical work 1.
Work in Group: to make the SWOT analysis on the theme"Databases"

Practical work 2.
Key terms. Puzzle

Practical work 3.
Match the company department 1-8 with the type of data it works with a-h.

Practical work 4.

Practical work 5.
The DBMS acts as an interface between what two components of an enterprise-class database system?
Database application and the database
Data and the databaseThe user and the database application
Database application and SQL
The following are components of a database except ________ .user datametadatareportsindexes
An application where only one user accesses the database at a given time is an example of a(n) ________ .
single-user database applicationmultiuser database applicatione-commerce database applicationdata mining database applicationSQL stands for ________ .
Structured Query LanguageSequential Query LanguageStructured Question LanguageSequential Question LanguageThe DBMS that is most difficult to use is ________ .Microsoft's SQL ServerMicrosoft's AccessIBM's DB2
Oracle Corporation's Oracle+
Row is synonymous with the term:
record.
Relationcolumn.
field.
The primary key is selected from the:
composite Answer key.
determinants
candidate Answer key.
foreign Answer key.
Normalization ________ data duplication.
EliminatesReducesIncreasesMaximizes