databases

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/48

encourage image

There's no tags or description

Looks like no tags are added yet.

49 Terms

1
New cards
What is a primary key?
A unique identifier for each record in a database table. It must be unique and not null.
2
New cards
What are the two requirements of a primary key?
It must be unique and not null.
3
New cards
Why is a primary key used?
To uniquely identify and distinguish each record from all other records in a table.
4
New cards
What is a foreign key?
A field in one table that references the primary key of another table, creating a link between the tables.
5
New cards
What is the purpose of a foreign key?
To establish relationships between tables and maintain referential integrity.
6
New cards
What is a composite key?
A unique identifier made up of two or more fields.
7
New cards
When is a composite key needed?
When no single field can uniquely identify each record in a table.
8
New cards
What is an entity in a database?
A distinct object or thing, such as a person, place, event, or product, that can be identified and stored as a record.
9
New cards
What is an attribute?
A property or characteristic of an entity that provides more detail about it.
10
New cards
Give examples of attributes.
Name, age, address, date of birth, or email address.
11
New cards
What is a relationship in a database?
A connection or association between two or more entities that defines how they interact.
12
New cards
What is an update anomaly?
A problem that occurs when the same data is stored in multiple locations and not all copies are updated consistently.
13
New cards
What is the consequence of an update anomaly?
Data becomes inconsistent, inaccurate, or unreliable.
14
New cards
Give an example of an update anomaly.
If John Smith changes his email address, all occurrences of the email address must be updated or the data will become inconsistent.
15
New cards
What is a delete anomaly?
A problem that occurs when deleting one piece of data also removes the only instance of another important piece of data.
16
New cards
Give an example of a delete anomaly.
If Peter Jones is removed from a database, the details of car 1WRC 634 may also be lost if they are stored together.
17
New cards
What is an insert anomaly?
A problem that occurs when data cannot be added because some required information is missing.
18
New cards
Give an example of an insert anomaly.
A new car cannot be added to the database because no driver has been assigned yet and all fields are required.
19
New cards
What is the hierarchical structure of data from smallest to largest?
Field (attribute) → Record → Table (entity) → Database.
20
New cards
What is a field (attribute)?
A single piece of data about an entity, usually represented by a column in a table.
21
New cards
What is a record?
A collection of related fields describing one instance of an entity, usually represented by a row in a table.
22
New cards
What is a table (entity)?
A collection of related records about a particular entity.
23
New cards
What is data integrity?
The overall accuracy, consistency, validity, and reliability of data.
24
New cards
What is currency as a factor affecting data integrity?
How up-to-date the data is.
25
New cards
What is authenticity as a factor affecting data integrity?
How trustworthy the source of the data is.
26
New cards
What is relevance as a factor affecting data integrity?
How closely the data relates to the intended purpose or context of use.
27
New cards
What is accuracy as a factor affecting data integrity?
How correct or precise the data is.
28
New cards
What are outliers in relation to data integrity?
Data values that are unusual and may reduce how representative or consistent the data is.
29
New cards
What is validity in relation to data integrity?
The extent to which data accurately measures or represents the real-world phenomenon or concept it is intended to describe.
30
New cards
What is the difference between validity and accuracy?
Validity is whether the data measures the correct thing, while accuracy is how precise and correct the data is.
31
New cards
What is data?
Raw, unprocessed facts and figures with little meaning on their own.
32
New cards
What is information?
Data that has been processed, organised, and given context so that it becomes meaningful and useful.
33
New cards
What is the relationship between data and information?
Information is produced when raw data is processed, organised, and interpreted.
34
New cards
What is a flat file database?
A database that stores all data in a single table or file without relationships between tables.
35
New cards
What is a relational database?
A database that stores data in multiple related tables linked using primary and foreign keys.
36
New cards
What is an advantage of a relational database over a flat file database?
It reduces data redundancy and minimises anomalies while improving data integrity.
37
New cards
What does RDBMS stand for?
Relational Database Management System.
38
New cards
What is an RDBMS?
Software used to create, manage, access, and manipulate relational databases.
39
New cards
Give examples of RDBMS software.
MySQL, Microsoft Access, Oracle Database, PostgreSQL, and Microsoft SQL Server.
40
New cards
What is the role of an RDBMS in handling access to data?
It controls how users store, retrieve, update, secure, and manage data in a database.
41
New cards
What is meant by the independence of data from the RDBMS?
The data can exist separately from the software used to manage it, allowing systems to change without altering the data itself.
42
New cards
What is the purpose of normalising data?
To reduce redundancy, prevent anomalies, and improve data integrity and efficiency.
43
New cards
What is Third Normal Form (3NF)?
A stage of database normalisation where data is organised to remove repeating groups, partial dependencies, and transitive dependencies.
44
New cards
What is the first step in normalising data to 3NF?
Convert the data into First Normal Form (1NF) by removing repeating groups and ensuring atomic values.
45
New cards
What is Second Normal Form (2NF)?
A table in 1NF where all non-key attributes depend on the whole primary key.
46
New cards
What is Third Normal Form (3NF)?
A table in 2NF where non-key attributes depend only on the primary key and not on other non-key attributes.
47
New cards
Why is normalisation to 3NF important?
It reduces redundancy, prevents update, insert, and delete anomalies, and improves data integrity.
48
New cards

what are the factors affecting validity and acuuracy

  • currency

  • authenticity

  • relevance

  • accuracy

  • outliers (cleaning)


49
New cards