SLR 9 AND 10 FLASHCARDS
暂无描述。系统推荐的高质量记忆内容,适合每天坚持背诵学习。
卡片预览 (24 张)
What is hashing?
Hashing converts data into a fixed-length unique code called a hash used to verify integrity and enable fast lookup.
Give one use of hashing.
Used in password storage (store hashed passwords) and database indexing for quick retrieval.
What is a collision in hashing?
When two different inputs produce the same hash value.
What is symmetric encryption?
Encryption where the same key is used to encrypt and decrypt the data.
What is asymmetric encryption?
Encryption that uses a public key to encrypt and a private key to decrypt.
One advantage of symmetric encryption.
Fast and efficient for encrypting large amounts of data.
One disadvantage of symmetric encryption.
Key distribution problem – both parties must securely share the same key.
One advantage of asymmetric encryption.
Secure key exchange without needing to share a secret key beforehand.
One disadvantage of asymmetric encryption.
Slower than symmetric encryption due to complex mathematical calculations.
What is run-length encoding?
A lossless compression method that stores repeated values as one value and a count (e.g. AAAA → A4).
What is dictionary coding?
A lossless compression method that replaces repeated strings with shorter references stored in a dictionary.
What is lossy compression?
Compression that removes some data to reduce file size and cannot be perfectly reconstructed.
What is lossless compression?
Compression that preserves all original data so the file can be perfectly reconstructed.
What are databases?
Organised collections of related data stored electronically for efficient retrieval and manipulation.
What is an entity?
A real-world object or concept about which data is stored (e.g. Student).
What is an attribute?
A property or characteristic of an entity (e.g. StudentID, Name).
What is a primary key?
An attribute that uniquely identifies each record in a table.
What is a foreign key?
An attribute in one table that references the primary key in another table.
What is referential integrity?
Ensures that foreign key values must match a valid primary key value or be null.
Define normalisation.
A process of structuring a relational database to reduce redundancy and improve integrity.
What is 1NF?
All attributes contain atomic values and there are no repeating groups.
What is 2NF?
In 1NF and all non-key attributes fully depend on the entire primary key.
What is 3NF?
In 2NF and no non-key attribute depends on another non-key attribute.
Why normalise a database?
To reduce redundancy and prevent insertion, deletion and update anomalies.