IS 311 - Prelim

12345678910111213
Across
  1. 2. is the structure that defines how data is organized within a database, including tables, views, and relationships.
  2. 3. These are SQL commands used to control access to data such as GRANT and REVOKE.
  3. 5. It is a DBMS based on the relational model where data is stored in tables.
  4. 6. is a virtual table based on the result of an SQL query.
  5. 10. is a rule enforced on data in a table to maintain integrity such as NOT NULL, UNIQUE, and CHECK.
  6. 11. is a database object used to speed up data retrieval operations.
  7. 12. These are SQL commands used to retrieve data from a database such as SELECT.
  8. 13. is a column or set of columns that uniquely identifies each row in a table.
Down
  1. 1. These are SQL commands used to insert, update, delete, and retrieve data such as INSERT, UPDATE, and DELETE.
  2. 2. It is a standard language for storing, retrieving, and manipulating data in a database.
  3. 3. It is software used to create, manage, and manipulate databases.
  4. 4. is a column in one table that refers to the primary key in another table to establish relationships.
  5. 7. These are SQL commands used to manage transactions such as COMMIT and ROLLBACK.
  6. 8. is a structured collection of data that is stored, managed, and accessed electronically.
  7. 9. These are SQL commands used to define and modify database structures such as CREATE, ALTER, and DROP.