Database development
use the table below track your revision progress to key ideas in database design
drag rows up as you progress
update your confidence level
update quizlet setting, you can add more then one activity option as you complete them
add personal reminder notes
revise key ideas in Database design
0
status
key-point 1
key-point 2
I can use key-points to
confidence level
quizlet done
reminders
learned
1
learned key point
drag learned items here
flashcard
learned
tested
1
Count
revising
1
key point being revised
drag revising items here
flashcard
1
Count
to do
13
end-user
Identify the end-user requirements of a database problem.
functional requirement
Identify the functional requirements of a database problem.
entity-relationship diagram
entity, entity name, attribute, relationship
Describe and give examples of entity-relationship diagrams with three or more entities.
cardinality
1:1 relationship, 1:M relationship, M:N relationship
Indicate cardinality of relationship (one-to-one, one-to-many, many-to-many) in an ERD.
entity instance
entity-instance diagram
Describe and give examples of an instance using an entity-occurrence diagram.
compound key
Describe and and give examples of a compound key.
data dictionary
entity name, attribute name, primary key, foreign key
Describe and give examples of a data dictionary with three or more entities.
attribute type and size
text , number, date, time, Boolean, attribute size
Describe and give examples of attributes in a data dictionary.
constraints and validation
presence check, restricted choice, field length, range check
Describe and give examples of constraints or validation in a data dictionary.
query design
fields, tables, search criteria, sort order, grouping
Give an example of a design for a solution to a query including tables and queries.
query including join
equi-join
design for a solution to a query including a join
query including aggregate calculations
max, min, average, sum, count
design for a solution to a query including aggregate calculation.
query including row calculations
design for a solution to a query including row calculation.
13
Count
15
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.