Database development

icon picker
database topic map

click to expand a topic

Database Unit: topic map

database content map

Loading…

Reading 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
Skill
skill level
1
I know how to read a table of rows and columns to find and highlight: primary key (compound PK), clues for validation constraints, foreign key
2
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.
3
When there are two or more tables I know how to include a join (equi-join) when writing a select query
4
I can read an SQL select query and match it with the rows and columns in the tables, I can highlight what I work out.
5
I know how to use SQL code in the same question or other questions to help me write my own SQL code.
6
I can read sample data and work out what data types would be needed, also PK, FK and validations. I know how to highlight and label before starting my answer.
7
I can write a SELECT query after reading the question and highlighting the clues.
8
I know how to identify the clues for the fields / columns used with SELECT in a query
9
I know how to identify the clues for the table used with FROM in a query
10
I know how to identify the clues for the conditions used with WHERE in a query including a join if needed
11
I can use the AND keyword when there are two or more conditions
12
I know how to identify the clues for the conditions used with ORDER in a query including ascending or decending
13
I can identify how aggregate functions and the group keyword affect how rows are returned in a query
14
I can plan and write how a series of two queries can be used to return results needed
15
I can make a sketch of a a query result (view) to help work out how to code a second query
16
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
17
I can identify which attributes are required for each entity
18
I can use a "crow's foot" symbol to identify a many-to-one relationship
19
I can give a suitable name to a relationship between two entities
20
I can write an UPDATE statement using WHERE to match the appropriate rows
21
I can write a DELETE statement using WHERE to match the appropriate rows
22
I know that using DELETE without a WHERE will remove all rows
23
I know that DELETE removes an entire row, not just a value within the row
24
I can read and draw an entity occurrence diagram
There are no rows in this table
24
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.