Back to marketplace

Database Design & Development

No description yet. This curated deck is ready for daily study.

Total cards: 24•Content version: v4•Public deck•Updated: 8/1/2026

Card preview (24)

#1
Front (Question)

Flat File Database

Back (Answer)

All data is stored in a single table. Results in duplication of data that wastes storage space and causes modification anomalies.

#2
Front (Question)

Relational Database

Back (Answer)

Database composed of several linked tables/entities.

#3
Front (Question)

Record occurrence

Back (Answer)

This is data held on one particular thing or person, e.g. information on a single employee.

#4
Front (Question)

Field/attribute

Back (Answer)

A heading/name of an item of data in a record

#5
Front (Question)

Primary Key

Back (Answer)

A field that uniquely identifies a record in a table

#6
Front (Question)

Foreign Key

Back (Answer)

This is a primary key in another table. This allows two tables to be connected.

#7
Front (Question)

Validation

Back (Answer)

This can be applied to fields in the design of a database to allow only certain data to be entered

#8
Front (Question)

Length Check

Back (Answer)

This ensures that data can only be a certain number of characters long.

#9
Front (Question)

Range Check

Back (Answer)

This will ensure that the user is entering data between certain specified values.

#10
Front (Question)

Restricted Choice

Back (Answer)

This means the user can only enter data from within a list. Created by a lookup list. FOREIGN KEY must have this.

#11
Front (Question)

Presence Check

Back (Answer)

This checks whether the data exists. This means the user may not enter a null value into the field. PRIMARY KEY must have this.

#12
Front (Question)

Sort

Back (Answer)

To put a field/s in order of ascending/descending.

#13
Front (Question)

Compound Key

Back (Answer)

When two are more fields that are primary keys in other tables are used to create a primary key.

#14
Front (Question)

Data Dictionary

Back (Answer)

Shows the structure of the database. This is part of the design stage.

#15
Front (Question)

One to One

Back (Answer)

This type of relationship indicates when there is a single item in one table linked to another singular item in another table.

#16
Front (Question)

One to Many

Back (Answer)

This type of relationship describes one item of one table being linked to multiple items in another.

#17
Front (Question)

Many to Many

Back (Answer)

This type of relationship describes multiple items from one table being linked to multiple items in another. You should avoid these.

#18
Front (Question)

Wire Framing

Back (Answer)

This is the general method employed to design the user interface for software.

#19
Front (Question)

SQL

Back (Answer)

Structured Query Language. A special-purpose programming language designed for managing data held in a database.

#20
Front (Question)

SQL SELECT statement

Back (Answer)

Used to retrieve data from tables in a database

#21
Front (Question)

SQL INSERT statement

Back (Answer)

INSERT INTO usedcars (model,price,year) VALUES (“Fiesta”,9,999,”2018”)

#22
Front (Question)

SQL UPDATE statement

Back (Answer)

used to make changes to existing records within a table UPDATE usedcars SET price=29995.00 WHERE year=’2014’

#23
Front (Question)

SQL DELETE statement

Back (Answer)

used to remove records from a table DELETE FROM usedcars WHERE year=’2014’

#24
Front (Question)

Wildcard

Back (Answer)

A special character that represents other unknown characters in a search. Eg. % (* in Access), _ (? in Access)