Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Digital Technology > Database key terms > Flashcards

Database key terms Flashcards

1
Q

Table (entity)

A

A table consists of one or more records, it is a structure where data is organised in rows and columns

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Field (attribute)

A

A field contains one items of data about a person or thing. it is vertical

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Record

A

A collection of data items related to an object or person (horizontal)

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Primary key

A

Uniquely identifies records in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Foreign key

A

A field in one table which refers to the primary key in another table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Composite key

A

A composite key is one that consists of two or more fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Data dictionary

A

Shows the structure of data items to be used in the database by defining the basic organization of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Presence check

A

Checks data has been entered into a field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Range check

A

Checks that data has been entered within the upper and lower limits

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Length check

A

Ensures the data is the correct number of characters

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Type check

A

Ensures that the data entered is the correct type

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Format check

A

Checks that the data matches the predetermined format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Wireframe

A

A diagram to show the layout of a page of a multimedia application before coding it

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Form and report wireframes (what do they contain)

A

Logo, Field names, Headers, interactive buttons, Footer, User interaction items

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Navigational structure diagram

A

Shows the pathway between hyperlinks and pages of a multimedia application

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

ERD diagram

A

Entity relationship diagram - Planning tool which shows the relationships between tables and data in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Relationship

A

Links two tables in a database using a field that exists in each of the tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

QBE

A

Query by example - Used to search and extract data from the database to find the answer to a question.

It is a kind of form which the user fills out to find the relevant data. Easier for the user to use as they don’t need to learn how to find data using SQL- Structured Query language

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Logical operators

A

Used to analyse two values and return either a true or false result

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

SQL statements

A

Structured query language - Used to create databases and retrieve/process data within a database.

SELECT
FROM
WHERE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

reports

A

Provides the user with a summary data relating to all records in the report. It allows query results to be shown in a user friendly way

22
Q

Forms

A

Used to enter a new record into a table or modify an existing record and view any records already stored in the table

23
Q

Macros

A

A set of commands which is used to perform a repetitive task automatically

24
Q

Relational database

A

A database where all the tables are linked by various relationships. Reduces data redundancy and increases data integrity

25
Q

Data redundancy

A

Unnecessary duplication of data in a database. The same data is present in multiple tables and can slow the database down by increasing the file size and amount of data to be processed

26
Q

Data integrity

A

Accuracy of data stored in a database

27
Q

Referential integrity

A

Ensures that an entry cannot be made in one table with a foreign key, if the key field does not exist in the linked table

28
Q

Look up list

A

A list of data which can be used to provide all available values for a given data field

29
Q

Input masks

A

Method of controlling the format of data which is being entered into a database

30
Q

Cascade delete/update

A

Ensures that changes made in the linked table (where foreign key is entered) are also shown in the primary table

31
Q

Waterfall model

A

Represents a sequential approach to application development

The stages need to be completed in order and the next stage cannot begin until the previous stage has been completed

32
Q

Iterative development approach

A

Testing and making changes at different stages of development

33
Q

Bugs

A

An error or fault which leads to errors in the execution of a program or application

34
Q

Testing evidence

A

Documentation which illustrates the outcome of tests applied to application software, this may be in the form of annotated screenshots

35
Q

Testing strategies (the table headings for the testing evidence)

A

Individual tests
descriptions of the area to be tested
Test number
Actual outcomes of testing
Expected outcomes of testing
Comments about the outcomes of testing

36
Q

Null data

A

Used to test that the system can cope when NO DATA IS ENTERED

37
Q

invalid data

A

Abnormal data which is entered and shouldn’t normally be accepted by the system

38
Q

Extreme data

A

Data entered which lies at the boundary and should be accepted by the system

39
Q

Erroneous data

A

Data which is the wrong data type than what should be entered, should be rejected

40
Q

White box testing

A

Used to test code
The tester must have an idea of how the system is to be used. This approach is very effective as it can identify any errors in the early stage of system development

41
Q

White box testing advantages and disadvantages

A

Adv: Started at an earlier stage, doesn’t need gui to be made yet to test, More thorough

Disadv: Testing can be complex as the tester is working with code, Tester needs to have a comprehensive knowledge of programming before testing to insure effectiveness

42
Q

Black box testing

A

Examines the software functionality
The tester knows the formal inputs and expected outputs and documentation of testing forms the basis

43
Q

Black box adv and disadv

A

Adv: Tests are completed from an end user pov, tester doesn’t need to know programming languages to test the system, tests can be completed as soon as specifications are completed

Disadv: Only a small number of input tests can be completed which leaves many paths untested, Tests can be difficult to design if there are no specifications

44
Q

System testing

A

Tests how all parts of the system work together and is carried out on a completed system.S

45
Q

system testing adv and disadv

A

Adv - Simulates actual system usage, Doesn’t make any system structure assumption

Disadv - Can miss logical errors, high possibility of redundant testing

46
Q

Alpha testing

A

Early test of new or updated system software and is done by the manufacturers before the beta testing commences (done by the users).

this type of testing incorporates black box testing methods

47
Q

Alpha testing adv and disadv

A

Adv - simulates real time behaviour, Errors are detected early on

Disadv - Developers could be dissatisfied with the results, Functionality cannot be fully tested as the system is still in development

48
Q

Beta testing

A

Carried out using free trial versions of the application. A sample of the intended audience sample the product.

49
Q

Beta testing adv and disadv

A

Adv - Reduces chance of the product failing, Increases customer satisfaction, collects data and tests it at the same time whilst saving time for the developers by allowing a separate audience to test it for them.

Disadv - Less control of how testing is conducted as it is completed in the real world, finding the right testers can be a problem

50
Q

A/B testing

A

Compares two versions of a web page to test which one holds up better and is better recieved by the target audience

51
Q

A/B testing adv and disadv

A

Adv - Ease of implementation, Ease of analysis and test design, Flexible

Disadv, Limited number of concepts, inefficient data collection

52
Q

Evaluation

A

To improve the product being developed by identifying problems with the application. It is used to gain feedback from the end user

Digital Technology (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions