Module 8
synonymous with columns; the fields associated with an entity.
Attributes
____________ critical integity constraints enforce businees rules vital to an organization's success and often require more insight and knowledge
Business
Defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer
Business rule
Enforces business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints.
Business-critical integrity constraints
3 Terms that represent data elements associaed with an entity:
Columns, Attributes, & Fields
compiles all the metadata about the data elements in a data model
Data dictionary
Two terms representing the smallest or basic unit of infomation.
Data element/field
Maintains information about various types of objecs, events, people, and places
Database
synonymous with table; stores information about a person, place, thing or event.
Entity
3 Business adavantages of a relational database.
Increased: Flexibility, informaton integrity, information security, scalability & performance Reduced: Information Redundance
The measure of the quality of information
Information integrity
The duplication of data, or storage of the same data in multiple places is...
Information redundancy
Provides details about data
Metadata
The ___________ view of information deals with the physical storage of information on a storage device.
Physical
Field that uniquely identifies a given record in a table
Primary key
A tool that helps users graphically design the answer to a question against a database.
Query-by-example
__________ integrity constraints are rules that enforce basic and fundamental information-based constraints
Relational
Allows users to create, read, update, and delete data in a relational database
Relational database management system
Business-critical integrity constraints tend to mirror the very rules by which an organization achieves success.
True
Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information-searching tasks.
True
Integrity _________ are rules that help ensure the quality of information.
constraints
The ____________ view of information focuses on how individual users logically access information to meet their own particular business needs.
logical
Data __________ are logical data sructures that detail relationships among data elements using graphics or pictures
models
While a database has only _____ physical view, it can easily support multiple _________ views that provides for flexiblity.
one; logical
Primary goal of a database is to eliminate infomation redundancy by recording each piece of information in ________ place in the database
only one
a collection of related data elements; Occupies one row in its respective table.
record
A ________ query language asks users to write lines of code to answer questions against a datbase.
structured