MIS Appendix C Flashcards
Attributes
The data elements associated with an entity.
Business Rule
Defines how a company performs a certain aspect of its business and typically results in either a yes/no or true/false answer.
Cardinality
Expresses the specific number of instances in an entity.
Composite Entity
Entities that exist to represent the relationship between two other entities.
Data Model
Logical data structures that detail the relationships among data elements using graphics or pictures.
Database
Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).
Database Management System (DBMS)
Creates, reads, updates, and deletes data in a database while controlling access and security.
Entity
Stores information about a person, place, thing, transaction, or event.
Entity-Relationship Diagram (ERD)
A technique for documenting the entities and relationships in a database environment.
Field
A characteristic of a table.
Foreign Key
A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.
Many-To-Many Relationship (M:N)
Between two entities in which an instance of one entity is related to many instances of another and one instance of the other can be related to many instances of the first entity.
Multi-Valued Attribute
Having the potential to contain more than one value for an attribute.
Null-Valued Attribute
Assigned to an attribute when no other value applies or when a value is unknown.
One-To-Many Relationships (1:M)
A relationship between two entities in which an instance of one entity can be related to many instances of a related entity.
