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
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
16
entity-relationship diagram
attribute, entity
design entity names and attributes within an entity-relationship diagram
many to one relationship
design a one to many relationship within an entity-relationship diagram
data dictionary
attribute, entity, data types, validation constraints
use entity name and attributes in a data dictionary
number data type
use number as a data type for an attribute in a data dictionary
text data type
use text as a data type for an attribute in a data dictionary
date data type
use date as a data type for an attribute in a data dictionary
time data type
use time as a data type for an attribute in a data dictionary
boolean data type
use boolean as a data type for an attribute in a data dictionary
size of text data type
use attribute size for text data in a data dictionary
primary key
use primary key in a data dictionary
foreign key
referential integrity
use foreign key in a data dictionary
presence check
validation constraint
use validation for presence check in a data dictionary
restricted choice
validation constraint
use validation for restricted choice in a data dictionary
field length
validation constraint
use validation for field length in a data dictionary
value range check
validation constraint
use validation for value range check in a data dictionary
query
query design
use a query design including multiple tables, fields, search criteria, sort order
16
Count
18
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.