Skip to content
Share
Explore
Database development
revise key ideas in Database design
status
key-point 1
key-point 2
I can use key-points to
confidence level
quizlet done
reminders
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.
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.