Databases_Flashcards
No description yet. This curated deck is ready for daily study.
Card preview (6)
What makes a good primary key in a database?
A good primary key is unique, not null, stable (unchanging), and minimal.
How do we prevent redundant data in a database?
By using normalisation, relational table design, and enforcing foreign key constraints.
What is normalisation, and why is it important?
Normalisation is the process of structuring a database to reduce data redundancy and improve data integrity.
What does each letter in ACID stand for?
Atomicity, Consistency, Isolation, Durability.
Why are ACID properties important?
They ensure reliable processing of database transactions, even in case of errors or failures.
How can we write SQL queries to search for specific data in a table?
By using SELECT statements with WHERE clauses, e.g., SELECT name FROM students WHERE grade = ‘A’;