RELATIONAL DATABASE FUNDAMENTALS
- Information is everywhere in an
organization
- Information is
stored in databases

- Database models include;






ENTITIES AND ATTRIBUTES
- Entity – a
person, place, thing, transaction, or event about which information is stored

- Attributes
(fields, columns) – characteristics or properties of an entity class

KEYS AND RELATIONSHIPS
- Primary keys and
foreign keys identity the various entity classes (tables) in the database



RELATIONAL DATABASE ADVANTAGES
- Database
advantages from a business perspective include;





INCREASED FLEXIBILITY
- A well-designed
database should;






INCREASED SCALABILITY AND PERFORMANCE
- A database must
scale to meet increased demand, while maintaining acceptable performance levels


REDUCED INFORMATION REDUNDANCY
- Databases
reduce information redundancy

- Inconsistency is
one of the primary problems with redundant information
INCREASED INFORMATION SECURITY
- Information is
an organization asset and must be protected
- Databases offer several security features
including;



DATABASE MANAGEMENT SYSTEMS
- Database
management systems (DBMS) – software through which users and application
programs interact with a database

DATA-DRIVEN WEB SITES
- Data-driven
Web sites – an interactive Web site kept constantly updated and relevant to the
needs of its customers through the use
of database

DATA-DRIVEN WEB SITE BUSINESS ADVANTAGES
- Development
- Content
Management
- Future
Expandability
- Minimizing
Human Error
- Cutting
Production and Update Costs
- More
Efficient
- Improved
Stability
DATA-DRIVEN BUSINESS INTELLIGENT
- BI in a
data-driven Web site

INTEGRATING INFORMATION AMONG MULTIPLE DATABASES
- Integration –
allows separate systems to communicate directly with each other
- Forward integration – takes information entered into a given system and sends it automatically to all downstream systems and processes

- Backward integration – takes information entered into a given system and sends it automatically to all upstream systems and processes

- Building a central repository
specifically for integrated information

No comments:
Post a Comment