CIS Ch. 7

Created by popper2400 

Upgrade to
remove ads

21 terms

Database

Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses).

Hierarchical Database Model

Information is organized into a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships

Network Database Model

Flexible way of representing objects & their relationships. Allows multiple parent & child records, forming lattice structure

Relational Database Model

Type of database that stores information in the form of logically related 2-dimentional tables

Attributes

Characteristics or properties of an entity class

Primary Key

Field that uniquely identifies a given entity in a table. It provides a way of distinguishing each entity in a table

Foreign Key

Primary key of one table that appears as an attribute in another table. Acts to provide a logical relationship between the 2 tables

Physical View

Physical storage of info on storage device (hard disk)

Logical View

How users logically access info to meet their particular business needs

Scalability

How well a system can adapt to increased demands

Performance

How quickly a system performs a certain process/transaction

Redundancy

Duplication of information, storing some info in multiple places

Information Integrity

Measure of the quality of information

Integrity Constraints

Rules that help ensure quality of info. Can be defined and built into database design

Relational Integrity Constraints

Rules that enforce basic and fundamental info-based constraints

Business-Critical Integrity Constraints

Rules that Enforce business rules vital to an organization's success and often requires more insight and knowledge

Database Management System (DBMS)

Software through which users and application programs interact with a database

Data-Driven Website

Interactive website kept constantly updated and relevant to the needs of its customers through use of a database

Integration

Allows separate systems to communicate directly with each other

Forward Integration

Takes info entered, sends it to downstream system & processes

Backward Integration

Takes info entered into a given system and sends it automatically to all upstream systems and processes

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set