Across
- 4. In a relational database is a predefined format of rows and columns that define an entity.
- 6. Relationships occur when each record in TableA may have many linked records in TableB but each record in TableB may have only one corresponding record in TableA
- 7. Relationships occur when each record in TableA may have many linked records in TableB and vice-versa
- 8. Allow you to create "virtual tables" that are generated on the fly when they are accessed
- 11. Is a predefined row/column format for storing information in a relational database. They are equivalent to tables
- 14. Is a term from set theory which refers to a collection of one or more attributes.
- 17. files these are data files that contain records with no structured relationships.
- 18. Are a group of database commands which are to be treated as a single atomic event.
- 19. It is a database feature used for locating data quickly within a table.
- 21. A single data item related to a database object.
- 23. Consists of one set of tuples for a given relational table.
- 24. Is an industry-standard language used for manipulation of data in a relational database.
- 25. This term refers to information about data itself
- 26. SQL keyword is used to represent either a missing value or a value that is not applicable in a relational table.
- 27. Is a collection of meta-data that describes the relations in a database
- 28. key it is a combination of attributes that can be uniquely used to identify a database record without any extraneous data
- 29. is a single object about which data can be stored.
- 30. is a single unit of data stored as part of a database record.
Down
- 1. cstatement in SQL is used to edit values for attributes in one or more records of a relational table.
- 2. SQL command is used to add records to a table within a database
- 3. Is the primary mechanism for retrieving information from a database and consist of questions presented to the database in a predefined format.
- 5. Itis the process of structuring relational database schema such that most ambiguity is removed
- 9. Statement in SQL is the primary mechanism for retrieving information from a relational database.
- 10. key In a relational table this uniquely identifies each record in the table
- 11. statement in SQL cancels the proposed changes in a pending database transaction.
- 12. NULL Constraints in SQL allow you to specify that a column may not contain NULL values
- 13. ensure that transactions occur in an ordered fashion
- 15. onstraints allow database administrators to specify that a column may not contain duplicate values.
- 16. Relationships occur when there is exactly one record in the first table that corresponds to exactly one record in the related table.
- 20. is a relational database system developed by IBM Corporation,
- 22. key it is a field in a relational table that matches the primary key column of another table.
- 24. joins Allow you to retrieve related records from the same table.
- 28. it is a statement in SQL marks the final step in the processing of a database transaction