Back to marketplace

Databases Design and 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)

End User Requirements

Back (Answer)

The requirements are what the users expect to be able to do using the database.

#2
Front (Question)

Functional Requirements

Back (Answer)

Processes that the database system has to be able to do.

#3
Front (Question)

What does ER stand for in ER diagrams

Back (Answer)

Entity Relationship

#4
Front (Question)

What are ER diagrams used for ?

Back (Answer)

Used to represent the relationship between tables.

#5
Front (Question)

One-to-Many Cardinality

Back (Answer)

When one table can be present in many other tables. You also need a verb to describe the relationship.

#6
Front (Question)

3 types of validations in a database

Back (Answer)

• Length Check • Range Check • Restricted Choice • Presence Check • Lookup

#7
Front (Question)

Presence Check

Back (Answer)

When a field cannot be left empty, the primary key must have a presence check

#8
Front (Question)

Length Check

Back (Answer)

Set number of characters that can be entered. Eg; phoneNumber = 11

#9
Front (Question)

Restricted Choice

Back (Answer)

Can only choose a limited selection of options Eg Countries In The UK

#10
Front (Question)

Range Check

Back (Answer)

Numbers only When the number needs to be within a range Eg HotelRating = 1 - 5

#11
Front (Question)

What is Referential Intergrity ?

Back (Answer)

Whenever a Foreign Key is used, it must reference a valid and existing Primary Key in the first table. Can be used to cascade changes made to the database.

#12
Front (Question)

GDPR ensures the data held must be:

Back (Answer)

Must be accurate Held Securely Not kept longer than necessary Processed lawfully Used for declared purpose only

#13
Front (Question)

Search a record in SQL

Back (Answer)

SELECT FROM WHERE

#14
Front (Question)

Sorting a record in SQL

Back (Answer)

SELECT FROM WHERE ORDER BY (DESC or ASC)

#15
Front (Question)

Why are two tables created ?

Back (Answer)

To avoid data duplication and anomalies

#16
Front (Question)

How are two tables linked

Back (Answer)

By the Foreign Key

#17
Front (Question)

Deleting a record in SQL

Back (Answer)

DELETE FROM WHERE

#18
Front (Question)

Editing a record in SQL

Back (Answer)

UPDATE SET WHERE

#19
Front (Question)

Advantages of using a database

Back (Answer)

Search efficiently Sort efficiently Requires less storage

#20
Front (Question)

Adding a new record in SQL

Back (Answer)

INSERT INTO VALUES

#21
Front (Question)

3 types of fields

Back (Answer)

• Numeric • Text • Boolean • Date • Time

#22
Front (Question)

What is the difference between a flat file and relational database ?

Back (Answer)

Flat File: One table Relational Database; Multiple tables linked together.

#23
Front (Question)

What is a Foreign Key ?

Back (Answer)

When the primary key is used in another table

#24
Front (Question)

What is the advantage of linking tables ?

Back (Answer)

Helps to reduce input errors and data inconsistency