Please enable JavaScript.
Coggle requires JavaScript to display documents.
Databases and Information Systems (Database Advantages (collection of…
Databases and Information Systems
Database Advantages
meaningful and useful
collection of data
Stored
Sorted
Organized
Queried
turn data into information
needs
Database Advantages
Using
Manage , large , efficiently
share , possible
Database types
Object-oriented
Contain
Store more types
Store in objects
Access, faster
Multidimensional
fields and records
cube format
dimensions
Relational Databases
(most common )
Relation
Link
Organizes
Types of relationships
One-to-many
One-to-one
Many-to-many
Database Basics
Storing and Defining Data
Records
Tables
Fields
Building Blocks
Inputting ,Managing
Viewing , Sorting , allows ,display , reord
valid data , entered
Outputting
Extracting , Querying
Database Components and Functions
primary keys
Foreign key
Referential integrity
Primary key field
Warehousing and Storage
Warehouses and Marts
Multiple databases
Consolidates
Contains and organizes
Presents
Large-scale
Data mining
Process , great amounts
Spot significant
Business Decisions
Intelligence Systems
MIS
Directs
Enable
Provide
Organize
Include
generate various reports
DSS
Develop solutions
Information
Type , System
Add experiences
Information Technologies
Similar functions
Batch processing
Software-based solutions
Integral , functional information