Block 2 - Unit 4a Flashcards
The field whose value uniquely identifies each record on a table is known as the———–
Primary key
——–the expectations of the user is the first step in database design.
Discussing
The most common type of data
Text
You can combine and maintain large amounts of data in one ——— database
Access
Through ——— a database is scrambled and compacted
Encryption
To prevent errors or corruptions you must provide users with ——— which include how to navigate through records and how to add/edit data.
User documentation
To make your database easier to use, enter a ——– for each field.
Description
Lays the foundation for every database and is limited to a single distinct subject.
Table
Apply the ———- data type when no other field can be the primary key
Auto number
Creating new fields, changing a data type, or moving the location of the database fall under database ———-
Maintenance
A collection of data contained in multiple tables, each similar to each other.
Relationship database
A structured collection of data that is stored in a computer system.
Database
Databases maintain a great amount of vital information and must be protected from ——– access
Unauthorized
A valuable resource to any organization , business or company
Data
In a database,a ——— exists between common fields on different tables
Relationship
Determining where to store the database is apart of the —————
Physical design
Represents exactly one instance of the object or event which the table holds details about.
Record
Describes the information contained in the column and should be something that will be easily recognizable.
Field
Request ———– from users to ensure the database is and remains effective.
Feedback.
A field’s ——– determines the type of information that can be stored in that field.
Datatype
Define a relational database.
Collection of data contained in multiple tables, each similar to each other
What is the first step in database design.
Discuss the expectations of the user
What is done before you identify the types of data to store in your database?
Determine the purpose of the database
The ——– describes the info contained in a column and should be something that will be easily recognized
Fields name
Typing a ——– for each field helps a user input appropriate data into that field.
Description
What is the most common data type
Text
How many primary keys can there be on a table
One
What is a relationship, in regards to databases
A link between two similar things. Between common fields on multiple tables and ensures data is not accidentally updated on one table but not on the other.
During the physical design, you must determine where the database will be ——-
Stored
One auto restrict access to a database is to apply a combination of ———-and ———
Encryption and password
To prevent data error or corruption within the database you must provide users with ———- ————
User documentation.
List two examples of database maintenance.
Create new fields and Change data type from text to number.
