database
Call Kai
Learn
Practice Test
Spaced Repetition
Match
Flashcards
Knowt Play1/19
There's no tags or description
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai |
|---|
No analytics yet
Send a link to your students to track their progress
20 Terms
what is a flat file database
a flat file database stores everything in one single table
what are the Advantages
simple to design, easy to use, good for small datasets
what are the disadvantages
data redundancy, data inconsistency, not scalable, hard to maintain
what is a relational database
A relational database splits data into multiple tables and links them togther
what are the advantages
reduces duplication, more consistent data, easier to update, more scalable
what are the disadvantages
more complex, requires designing/planning, slower for simple tasks
what is a primary key
a field that uniquely identifies each records
what is a foreign key
a field that links to a primary key in another table
what is a secondary key
a field used for searching but its not unique
what is Entity Relationship Modelling
A way of designing database visually
what does ERM help plan
tables, relationships keys
what is normalisation
normalisation is the process of organising data to reduce duplication
why
to remove repeated data, improve consistency and avoid update errors
what are the advantages
reduces redundancy, improves data integrity, makes update easier
what are the disadvantages
more complex, requires join leading to slower queries
what is indexing
indexing creates a quick lookup system for data
what are the advantages
faster for searching, improves performance
what are the disadvantages
uses extra storage, slows down updates
Explain the difference between a flat file and a relational database.
A flat file database stores all data in a single table, which can lead to duplication and inconsistency. A relational database stores data in multiple linked tables, reducing redundancy and improving data organisation.
Explain the purpose of primary and foreign keys.
A primary key uniquely identifies each record in a table, ensuring no duplicates. A foreign key is used to link tables together by referencing a primary key in another table, allowing relationships between data to be established.