Database Terminology

1234567891011121314151617
Across
  1. 1. Structured Query Language
  2. 2. It is used to make each record unique in at least one way by forcing a field to have a unique value.
  3. 3. It consists of end users, applications, and a programming interface
  4. 8. It is concerned with database creation and administration, internal system operation, request processing, memory management, and data management
  5. 9. It is a set of programs that allow for the management of a database.
  6. 12. It is a database concept that ensures the consistency and accuracy of data by enforcing relationships between tables.
  7. 15. It is a rule that you apply or abide by while doing SQL operations.
  8. 16. It is a concept related to (duplicate data) and Inconsistency (contradictory data).
  9. 17. It identifies all of the real-world objects that have been specified by the end users and passes them into the actual entities – the tables and attributes, the columns of those tables.
Down
  1. 1. DQL SQL Command to query a table
  2. 4. They start with a period and control the shell’s output formatting, and also provide a number of utility features.
  3. 5. It is a value record of data and a key column for each record to identify it.
  4. 6. DML SQL Command to populate a table
  5. 7. A RDMS that does not require a separate server process or system to operate.
  6. 9. A computerized record keeping system with the overall purpose of maintaining information and making it available whenever required.
  7. 10. It is a logical expression against which inserted values are tested and subsequently accepted or rejected.
  8. 11. DML SQL Command to erase objects
  9. 13. it is as either empty or undefined.
  10. 14. DDL SQL Command to implement new object