Databases basics Flashcards
(18 cards)
What is a table?
A structure where data is organised in rows and columns
Tables are used to store data about related items, e.g. customers, products, sales.
Define a record.
A collection of data items, which may be of different data types, all relating to the individual or object that the record describes.
What is a field in a database?
Part of a record designed to hold a single data item of a specified type.
What is a Primary Key?
A field that uniquely identifies an individual record in a table.
What is a Foreign Key?
A primary key in one entity which is included in another entity to link the two tables.
Define a database.
A (large) collection of data items and links between them, structured in a way that allows it to be accessed by a number of different application programs.
What is an Autonumber data type?
A number field, where the database chooses the next available number automatically.
Give examples of Autonumber.
- ID field
- Customer Number
What is a Text data type used for?
To store a string of characters up to a certain field size.
Provide examples of Text data type.
- Name
- Email Address
- Phone Number
What does the Date and Time data type store?
A specific date and time, which can be formatted to display in different ways.
List examples of Date and Time data type.
- Date of Birth
- Transaction Date
- Login time
What does the Number data type store?
A numeric value, which could be an integer or a decimal number.
Give examples of Number data type.
- Age
- Number of Likes
- Total number of pupils
What is the purpose of the Currency data type?
To store the value of a specific amount of money, with a set currency symbol.
List examples of Currency data type.
- Price
- Discount Amount
- Total Profit
What does the Yes / No data type represent?
Stores only one of two options: Yes or No, also known as a Boolean.
Provide examples of Yes / No data type.
- Any Medical conditions?
- Do you consent to your photograph being used?
- Do you want to receive the newsletter?
