Creado por Malachy Moran-Tun
hace más de 2 años
|
||
What is an Entity?
What are Attributes and Records?
What is a Flat File Database?
What is a Primary Key?
What is a Secondary Key?
What are the 3 Types of Relationships between Entities?
What is a Foreign Key?
How are Tables Linked in Many-to-Many Relationships?
What is Referential Integrity?
What is Normalisation?
What is First Normal Form?
What is Second Normal Form?
What is Third Normal Form?
Why is Normalisation Important?
What is Capturing Data, and what Methods can be Used?
How can Data be Transferred between Systems without the need for Human Intervention?
What is a Transaction?
What is ACID?
What is Record Locking?
What is Serialisation?
What is Timestamp Ordering?
What is Commitment Ordering?
What is SQL?
What do the Following Commands do?
> SELECT
> FROM
> WHERE
> ORDER BY
How does the LIKE Command Work?
What does the JOIN Command do?
How does the CREATE TABLE Command Work?
What Data Types can be used when Creating a Table?
How does the ALTER TABLE Command Work?
How does the INSERT INTO Command Work?
How does the UPDATE Command Work?
How does the DELETE Command Work?