Persistent organised store of data that is used on a computer system i.e. booking systems,product details, price lists, customer details + production of invoices.
1 of 15
How can data handling software be used (i.e. spreadsheet/relational db)?
Sometimes has wizards to help create a commonly used db structure. Data maintenance features: editing/deleting records + adding new records + simple queries used to retrieve specific data from a table or use criteria to filter records to those you wa
2 of 15
What is data redundancy and data integrity?
Redundancy: where data is repeated unnecessarily in a database – time consuming + waste of storage space. Integrity: correctness of data in a database.
3 of 15
What is the Database Management software application designed to do?
Designed to interact with database users, interact with other software applications & capture, extract + analyse data. I.e. Oracle, MS Access + MySQL.
4 of 15
What is Program-Data independence in a DBMS (Database Management Software Application)?
Data is separated from applications that access it so programs work independently of data. Advantage: db admins can modify the software tools that control the db but the db will remain unchanged by these programs.
5 of 15
What is a relational database?
Where data is contained in more than one table –tables joined by linking primary key in 1 table to a foreign key in another. Most common type of relationship = one-to-many (i.e 1 doctor can have many patients, 1 student…)
6 of 15
What is a foreign and a primary key?
A foreign key is a field in a table which can be linked to the primary key of another table to form a relationship. A primary key is a unique identifier (i.e. code number) that can be used to identity each record in a db table.
7 of 15
What is an entity?
A real object about which data is stored in a database that corresponds to tables in the database
8 of 15
Why are data tables be linked in databases?
To reduce the duplication of data – increasing accuracy + consistency of data (therefore saving storage space) and making it simpler to keep information up to date.
9 of 15
What is a data entry form?
An input screen allowing chosen data items to be displayed and edited. Forms are linked directly to customer details + so can be used for data entry/editing.
10 of 15
What are queries used for in databases? Give examples of queries.
To extract information from tables: a select query -where the criteria is fixed + is specified at design time, parameter query –reusable since it requests the criteria to be input before the query runs.
11 of 15
What are reports used for in databases?
To summarise and present the data that is in the tables. Each report can be formatted to present the info in the most readable way. (Efficient when used by large organisations to provide monthly statement to their customers)
12 of 15
Why are modules used in databases?
Modules are created to add extra functionality to a database.
13 of 15
What are validation checks?
Automatic checks made by a computer to ensure that any data entered into the computer is valid and sensible –no guarantee that data has been entered correctly, only that it’s in a valid format.
14 of 15
Give examples of validation.
An input mask (used to control data entry into a field), presence check, range check + list check (data entered is from predetermined list i.e.combo-box) –(often a customised error)
15 of 15
Other cards in this set
Card 2
Front
How can data handling software be used (i.e. spreadsheet/relational db)?
Back
Sometimes has wizards to help create a commonly used db structure. Data maintenance features: editing/deleting records + adding new records + simple queries used to retrieve specific data from a table or use criteria to filter records to those you wa
Card 3
Front
What is data redundancy and data integrity?
Back
Card 4
Front
What is the Database Management software application designed to do?
Back
Card 5
Front
What is Program-Data independence in a DBMS (Database Management Software Application)?
Comments
Report