4278686
Description
Flashcards by Connor Begg#, updated more than 1 year ago
|
Created by Connor Begg#
almost 10 years ago
|
|
| Question | Answer |
| What is a database? | Something to store data either on a computer or a manual paper system. |
| Flat-file database? | • All the data is contained in one table. • Flat file databases can be created in spreadsheets or in all databases. • In flat-file databases each table row is known as a record and each column is a field. |
| Relational database? | • Data is contained in separate tables. • All data tables are linked by key fields. • Relational database management systems (RDBMS) are used to control database access. |
| Relational database advantages? | • Avoids data duplication. • Data can be edited easily. |
| What is DBMS? | Database management system: Provides an interface for the user to interact with the database. |
| What is a form? | Tool which allows a user to enter or change data in a table. |
| What is a table? | A set of data elements organised in columns and rows. |
| What is a query? | The primary method of retrieving info from the database - a request for information. |
| What is a report? | A tool to help output information from the database. |
| What is an entity? | A subject or thing of importance. Each entity should have its own table. |
| What is a primary key? | Something that will be different in each record. |
| What is a foreign key? | A primary key within a different table. |
| Advantages of an electric database? | You can make many copies and can search info in a range of ways. |
| What is SQL? | Structured Query Language: Allows you to insert, add or delete info from your database. |
| What is data integrity? | Whether a piece of data is plausible or not. |
| What is validation? | A check to see if something makes sense. |
| What is verification? | Checking that data is true or correct. |
| What is a format check? | Checking data is set out correctly eg. data in the format of DD/MM/YYYY in a date. |
| What is a presence check? | Checking that all important info has been entered eg. online goods having the customers delivery address. |
| What is a range check? | Used to store data within ranges eg. 1-10. |
| What is a lookup check? | Allows you to search for tabled data. |
| What is a size check? | Checking the size of the data eg. no more than 25 characters. |
Want to create your own Flashcards for free with GoConqr? Learn more.