Flashcards
Database Concepts
Flashcards do conjunto (22)
- 1What is a database?Something to store data either on a computer or a manual paper system.
- 2Flat-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. - 3Relational 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. - 4Relational database advantages?• Avoids data duplication.
• Data can be edited easily. - 5What is DBMS?Database management system: Provides an interface for the user to interact with the database.
- 6What is a form?Tool which allows a user to enter or change data in a table.
- 7What is a table?A set of data elements organised in columns and rows.
- 8What is a query?The primary method of retrieving info from the database - a request for information.
- 9What is a report?A tool to help output information from the database.
- 10What is an entity?A subject or thing of importance. Each entity should have its own table.
- 11What is a primary key?Something that will be different in each record.
- 12What is a foreign key?A primary key within a different table.
- 13Advantages of an electric database?You can make many copies and can search info in a range of ways.
- 14What is SQL?Structured Query Language: Allows you to insert, add or delete info from your database.
- 15What is data integrity?Whether a piece of data is plausible or not.
- 16What is validation?A check to see if something makes sense.
- 17What is verification?Checking that data is true or correct.
- 18What is a format check?Checking data is set out correctly eg. data in the format of DD/MM/YYYY in a date.
- 19What is a presence check?Checking that all important info has been entered eg. online goods having the customers delivery address.
- 20What is a range check?Used to store data within ranges eg. 1-10.
- 21What is a lookup check?Allows you to search for tabled data.
- 22What is a size check?Checking the size of the data eg. no more than 25 characters.
Informações
- Descrição
- GCSE Computer Science FlashCards sobre Database Concepts, criado por Connor Begg# em 07-01-2016.
- Criado por
- Connor Begg#
- Visualizações
- 4
- Tags
- Avaliação