sl10 -database Flashcards
What is a database
An organized collection of data
Give some advantages of using a database
Allows for easy:
Adding
Modification
Deletion
Searching
What is a record in a database
A horizontal row
What is a field in a database
A vertical row
What is a flat file database
A database that has no relationships with other databases
When would a flat file database be appropriate
Storing contact details
Small product database
Maintain a game or music collection
Why are flat file databases inefficient
Lots of data is repeated, meaning that large amounts of unnecessary data is used
What are the 3 types of relationship in a database
1:1 (1 to 1)
1:M (1 to many)
M:M (many to many)
Describe a 1:1 relational database
Each record in one database corresponds to another record in a different database. They are linked together by a primary and a foreign key
Describe a primary key
A field in each record that is guaranteed to be unique
What are the SQL commands for selecting data
Select
From
Where
What are the SQL commands for modifying data
Update
Delete
Insert
What is DBMS
A database management system
What is the purpose of DBMS
Hiding the underlying structure of the data and ensuring that it maintains referential integrity
What are the 3 common database file types
CSV – Comma separated values
JSON – JavaScript object notation
XML – Extensible markup language
