1/8
Looks like no tags are added yet.
Name | Mastery | Learn | Test | Matching | Spaced | Call with Kai | Chat |
|---|
No analytics yet
Send a link to your students to track their progress
Subject area
decompose a complex model into group of related entities called subject area
Independent / Dependent
Refer to strong entities as independent and weak entiies as dependent
Unified Modeling Language UML
commonly used for software development similar to database structures includes ER conventions
IDEF1X
stands for information Definition version. became popular due to early adoption by US of defense
Strong table
strong entity becomes strong table. PKEY must be unique and required and should be stable simple and meaningless
Artifiical Key
system generated by database designer. usually integers and new rows are inserted to table
weak table
a weak entity becomes a weak table
supertype table
supertype entity becomes a supertype table
subtype table
subtype entity becomes subtype table