– Online Database –
– SQL Activities –
Feeling confident with your computing knowledge of Relational Databases?
Spend a few minutes to answer or research the following questions:
?
What are tables used for in a relational database?
?
How do tables, records and fields relate to each other?
?
What are the main data types when storing data values?
?
What is the purpose of a primary key?
?
What is the purpose of a foreign key?
?
What are the three types of relationship in a database?
?
Using a school database can you give an example of each type of relationship?
?
Why is the customer name not a good field to use as a primary key?
?
Why is meant by an autoNumber or autoIncrement field?
?
When storing data about cars for a car dealer database, what field could be used as a primary key?
?
Why is it sometimes necessary to create a link table?
?
What is the difference between an entity and a table?
?
What does the acronym CRUD stands for?
?
What language is used to run queries in a database? What does it stand for?
?
What are the main keywords used in the SQL language to start a CRUD query?
?
In a database what is meant by redundant data?
?
What is the purpose of normalisation?
?
Can you describe the characteristics of a relational database in 1NF, 2NF, 3NF.
?
What is meant by “flat file”?
?
What is meant by atomic data?
?
What is meant by referential integrity?
?
In a client-server web application, where is the relational database stored?
?
What is meant by “SQL injection”?
LMC Simulator
Flowchart Studio
Python Syntax
