CIS 3050 Database Analysis and Design Exam 1

Subtype

Supertype

Attribute Inheritance

Relationship Inheritance

Total Specialization Rule

Partial Specialization Rule

Disjoint Rule

Overlap Rule

Generalization

Specialization

Subtype Discriminations

Disjoint

Overlapping

Entity

Strong entity

Weak entity

Relationship

Degree of a relationship

Unary relationship

Binary relationship

Ternary relationship

cardinality constraints of a relationship

minimum cardinality

maximum cardinality

associative entity

Ternary relationships

attribute

Optional attribute

Multivalued attribute

Composite attribute

Derived attribute

Identifier

Logically

Metadata

DBMS, Database Management System

The five phases of database development is:

An Entity-relationship Model (E-R model)

primary key

Foreign key

Domain Constraints

Entity integrity

Referential integrity

one-to-many relationship
(Map Binary Relationships to Relations)

Many-to-Many relationship
(Map Binary Relationships to Relations)

One-to-one relationship
(Map Binary Relationships to relations)

Referential Integrity constraint