Task 1. Fill in the blanks in the sentences of words within the meaning of the proposed list.
Words: Referential integrity, subset, compound key, database, primary key, redundancy, foreign key, index
1. Further improvements are, however, needed, especially in areas of ______________ and data security.
2. Add a to _______ _______ every database table to uniquely identify each record.
3. If reference is made to a primary key from another table, this is termed a _______ ______.
4. A _______ _____ is a key that consists of multiple columns, because one column is not sufficiently unique.
5. A special data structure that serves the processes of accessing relationship information by storing specific values that correspond
to portions of the relationship content is the concept of a database _______.
6. __________ ________ is a relational database concept, which states that table relationships must always be consistent.
7. MySQL is a very powerful program in its own right. It handles a large ______ of the functionality of the most expensive and
powerful database packages.
8. Software programmers are well acquainted with _________ concepts through relational databases like Oracle, SQL SERVER
and MySQL, etc.
Ответы
Ответ:
1. Further improvements are, however, needed, especially in areas of redundancy and data security.
2. Add a to primary key every database table to uniquely identify each record.
3. If reference is made to a primary key from another table, this is termed a foreign key.
4. A compound key is a key that consists of multiple columns, because one column is not sufficiently unique.
5. A special data structure that serves the processes of accessing relationship information by storing specific values that correspond to portions of the relationship content is the concept of a database index.
6. Referential integrity is a relational database concept, which states that table relationships must always be consistent.
7. MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
8. Software programmers are well acquainted with database concepts through relational databases like Oracle, SQL SERVER and MySQL, etc.
Объяснение: