DBMS Ch 4

2. KEY the sQL clause to identify the field as a foreign key for referential integrity
3. Ensures the change of one table and all other records related to it
4. Where information about tables in the database is located.
5. The clause used to enforce legal-values integrity
7. A computer that allows other users access to the database through clients
8. The field or combination of fields on which the index is built
9. SQL cluae to to specify the primary key for a field
11. different types of privileges can be granted to users and, if necessary, later revoked
12. The SQL command used to delete a table that is no longer needed
17. When you create an index whose key is a single field
19. system where the database resides on a computer called the server and users access the database through clients
20. The prevention of unauthorized access to the database
21. Any foreign key must have a matching primary key, or be permitted to be null
22. A computer that is connected to a network and has access through the server to the database

1. SQL command to delete an index
4. Ensures the deletion of one table and all other records related to it
6. SQL command to create an index
10. index An index with more than on key field
13. sql command to allow admin to revoke user privileges
14. the rule that no field that is part of the primary key may accept null values.
15. Changes to a table's structure are made using this SQL command
16. The main mechanism for increasing the efficiency with which data is retrieved from the database
18. The property that states that no record can exist in the database with a value in the field other than one of the legal values.