Question Time – Relational Databases


– 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”?

Share Button
Posted in Computer Science, Computing Concepts, Databases, Quiz Tagged with:

Our Latest Book

Follow this blog