WorksheetsIBDP Database A.2.1 - A.2.5
Total questions: 15
Worksheet time: 11mins
Set of programs that we need to handle databases.
Relational Database Management System (RDBMS)
Database Management System (DBMS)
Database Handling Software
None of the above
A process done by the computer to check the input from the user if it is valid and following the input requirements or specifications.
Proof reading
Validation
Verification
All of the above
Set of programs needed to create a link or relationship between databases or database tables.
Relational Database Management System (RDBMS)
Database Management System (DBMS)
Database Linker
None of the above
A database administrator can set up __________ to give different users levels of usage for the database.
verification rules
validation rules
access rights
record locking
__________ is when one user is currently updating one record and it cannot be updated by other users of the database.
Verification
Validation
Record access rights
Record locking
__________ is a diagram showing the entities, attributes and links between entities.
Database dictionary
Database link diagram
Database schema or schema
Database connection diagram
Tick three (3) characteristics of a Logical schema.
Describes the data or the record in the database
Describes the fields or attributes in a database
Describes the types of keys (primary key, foreign key) that exist between the entities in a database
Describe where we are going to store the database and back up method in creating a copy of the database.
Describe the relationships that exist between the entities.
_________ describes related information on how we are going to save our database, where to store our database, what storage media to use, frequency on saving the database and frequency of backing up the database.
Logical Schema
Physical schema
Conceptual schema
Database schema
________ refers to the database or collection of data displayed in rows and columns.
Tuples
Attributes
Entities
Primary Key
_________ refers to one row of related data.
Tuples or Records
Attributes or Fields
Entities or Tables
File
__________ refers to the name of the data in one column. A word/phrase that can easily describe all the data in one column.
Tuples or records
Attributes or fields
Entities or tables
File
__________ a key or a field that is a primary key in another table.
Super key
Candidate key
Foreign key
Alternate key
______ a special field or attribute in a database entity that will never accept duplicate entries because the data entry into it must be unique.
Primary key
Foreign key
Alternate key
Super key
These are candidate keys that we did not select to be the primary key in one entity.
Foreign key
Alternate key
Compound key
Super key
A combination of two or more keys and one of the fields or keys is a foreign key in another table.
Primary key
Compound key
Alternate key
Composite key
