Database development
Database development

analysis and GDPR

database design

implement with SQL

test and evaluate

click to expand a topic

Database Unit: topic map

⁠

Loading…⁠

⁠

Reading and and answering database questions

here are the skills you should be building up

update the skill level as you try more questions

If you want to improve these skills add them to your

task planner⁠

⁠

Skills for n5 database exam questions 2 2

Skills for n5 database exam questions 2 2

Skill

skill level

I can read sample data and work out what data types would be needed. I know how to highlight and label before starting my answer.

I can read sample data and work out the Primary Key and Foreign Key. I know how to highlight and label before starting my answer.

I can read sample data and work out what validations (or constraints) are appropriate for each column. I know how to highlight and label before starting my answer.

If there are two tables I know how to link rows by finding matching values for PK and a FK. I know there may be more than one row in the many table which matches a row in the one table.

If there are two tables I know how to include a join (equi-join) when writing a select query

I can read an SQL select query and match it with the rows and columns in a table, I can highlight what I work out.

I know how to use SQL code in the same question or other questions to help me write my own SQL code.

I can write a SELECT query after reading the question and highlighting the clues.

I know how to identify the clues for the fields / columns used with SELECT in a query

I know how to identify the clues for the table used with FROM in a query

I know how to identify the clues for the conditions used with WHERE in a query including a join if needed

I can use the AND keyword when there are two or more conditions

I know how to identify the clues for sorting one or more columns with ORDER BY including ascending or descending

I can complete a data dictionary to show PK, FK, data types, size of text fields, validations constraints including presence check, range, restricted choice, field length and foreign key lookup

I can identify which attributes are required for each entity

I can use a "crow's foot" symbol to identify a many-to-one relationship

I can give a suitable name to a relationship between two entities

I can write an UPDATE statement using WHERE to match the appropriate rows

I can write a DELETE statement using WHERE to match the appropriate rows

I know that using DELETE without a WHERE will remove all rows

I know that DELETE removes an entire row, not just a value within the row

I can read and write an INSERT statement to add a new row to a table. I can debug an INSERT statement.

I can read SQL code to identify which data types are being used.

There are no rows in this table

Count

⁠