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
Skills for n5 database exam questions 2 2
Skill
skill level
1
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.
2
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.
3
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.
4
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.
5
If there are two tables I know how to include a join (equi-join) when writing a select query
6
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.
7
I know how to use SQL code in the same question or other questions to help me write my own SQL code.
8
I can write a SELECT query after reading the question and highlighting the clues.
9
I know how to identify the clues for the fields / columns used with SELECT in a query
10
I know how to identify the clues for the table used with FROM in a query
11
I know how to identify the clues for the conditions used with WHERE in a query including a join if needed
12
I can use the AND keyword when there are two or more conditions
13
I know how to identify the clues for sorting one or more columns with ORDER BY including ascending or descending
14
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
15
I can identify which attributes are required for each entity
16
I can use a "crow's foot" symbol to identify a many-to-one relationship
17
I can give a suitable name to a relationship between two entities
18
I can write an UPDATE statement using WHERE to match the appropriate rows
19
I can write a DELETE statement using WHERE to match the appropriate rows
20
I know that using DELETE without a WHERE will remove all rows
21
I know that DELETE removes an entire row, not just a value within the row
22
I can read and write an INSERT statement to add a new row to a table. I can debug an INSERT statement.
23
I can read SQL code to identify which data types are being used.
There are no rows in this table
23
Count

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.