Analysis Flashcards
Identify the end-user requirements of a database problem
The end user requirements of a database system are the tasks that the user would want to be able to carry out.
Identify the functional requirements of a database problem
The processes that the system has to perform
Details of the data that the database will store
What does GDPR mean?
General Data Protection Regulation
Describe the implications of GDPR
a legislation which sets out rules for the protection of personal data
Describe an entity
An entity is an object about which a database will store information.
Describe an attribute
an item of information that relates to particular entity.
Describe and use a primary key
a field which uniquely identifies a record in a database
Describe and use a primary key
a primary key from one table which is used in a second table to link the tables together.
Describe attribute types
Attributes can have different data types:
text
number
date
boolean
Describe and use attribute size
a measure of how much space the field will take up when stored in main memory or backing storage
Describe and use presence check validation
ensures that data is entered in a field
examples include:
name number email DOB postcode
Describe and use restricted choice validation
Restricted choice limits data entry to a set of acceptable values
Describe and use field length validation
Field length validation limits the number of characters that can be stored in a field
Describe and use range validation
Range check ensures that data falls between two values.
Create an entity-relationship diagram
a graphical representation of entities in a database, and their relationship to each other
