Design Flashcards
(15 cards)
Entity
A person, place, thing or event…..
Entity Occurrence
A specific example of an entity.
Attribute
An entity is described by its attributes. Each attribute is a characteristic of the entity
Primary Key
An attribute or combination of attributes that uniquely identifies one, and only one
Foreign Key
An attribute in one table that uniquely identifies a row of another table
Compound Key
A compound key is a primary key that comprises two or more attributes.
Relationship
A relationship is a natural association between one or more entities
What are the three types of cardinality
one-to-one
one-to-many
many-to-many
What is an Entity-occurrence diagram
a diagram which illustrates the relationships between the entity occurrences of one entity
Entity-relationship diagrams
An entity-relationship diagram is a graphical representation of the entities in a system.
What are the Five Attribute Types
Text
Number
Date
Time
Boolean
What are the four types of validation
Presence Check
Restricted Choice
Field Length
Range
What is Presence Check
Checks if the user has entered any Data.
What Restricted Choice
Only lets you select a input from and option or list
What is Field Length
Indicates the maximum number of characters that are required.
