Please enable JavaScript.
Coggle requires JavaScript to display documents.
DATABASE - Coggle Diagram
DATABASE
COLLECTION OF DATA
ORGANIZED
TO SERVES
MANY APPLICATIONS
BY
CENTRALIZING DATA
CONTROLLING REDUNDANT DATA
DATABASE MANAGEMENT SYSTEM (DBMS)
SOFTWARE THAT PERMITS AN ORGANIZATION TO
CENTRALIZE DATA
MANAGE DATA
BY APPLICATION PROGRAM
PROVIDE ACCESS TO THE STORED DATA
INTERFACES BETWEEN
APPLICATIONS
PHYSICAL DATA FILES
SEPARATES
LOGICAL
PHYSICAL VIEWS OF DATA
SOLVES PROBLEMS OF TRADITIONAL FILE ENVIRONMENT
CONTROL REDUNDANCY
ELIMINATES INCONSISTENCY
UNCOUPLES PROGRAMS AND DATA
ENABLES ORGANIZATION TO
CENTRAL MANAGE DATA
DATA SECURITY
EXAMPLE
A SINGLE HUMAN RESOURCE DATABASE
PROVIDES
MANY DIFFERENT VIEWS OF DATA
DEPENDING ON THE
INFORMATION REQUIREMENT OF THE USER
EXAMPLE OF DBMS OF HR DATABASE
EMPLOYEE ID
NAME
SSN
POSITION
DATE HIRED
DATA MANAGEMENT SYSTEM
2 more items...
GROSS PAY
PENSION BENEFIT
NET PAY
LIFE INSURANCE
HEALTH CARE
PROVIDE MORE THAN ONE VIEWS WITH A SINGLE DATABASE
RELATIONAL DBMS
REPRESENT DATA AS TWO-DIMENSONAL TABLES
EACH TABLE CONTAINS DATA ON
ENTITY
ATTRIBUTES
EXAMPLES
TABLE : GRID OF COLUMNS AND ROWS
ROWS (TUPLES)
RECORDS FOR DIFFERENT ENTITIES
FIELDS (COLUMNS)
REPRESENTS ATTRIBUTE FOR ENTITY
KEY FIELD
FIELDS USE TO UNIQUELY IDENTIFY EACH RECORD
PRIMARY KEY
FIELD IN TABLE USED FOR KEY FIELDS
FOREIGN KEY
PRIMARY KEY USED IN SECOND TABLES AS LOOK-UP FIELD TO IDENTIFY RECORDS FROM ORIGINAL TABLE
OPERATIONAL OF RELATIONAL DBMS
3 BASICS OPERATIONS USED TO DEVELOP USEFUL SETS OF DATA
SELECT
CREATES SUBSET OF DATA OF ALL RECORDS THAT MEET STATED CRITERIA
JOIN
COMBINES RELATIONAL TABLES TO PROVIDE USER WITH MORE INFORMATION THAN AVAILABLE IN INDIVIDUAL TABLES
PROJECT
CREATES SUBSET OF COLUMNS IN TABLE
CREATING TABLES WITH ONLY THE INFORMATION SPECIFIED
NON-RELATIONAL DATABASE
"NO SQL" STRUCTURE QUERY LANGUAGE
MORE FLEXIBLE DATA MODEL
DATA SETS STORED ACROSS DISTRIBUTED MACHINES
EASIER TO SCALE
HANDLE LARGE VOLUMES OF
UNSTRUCTED
STRUCTED DATA
WEB
GRAPHICS
SOCIAL MEDIA
DATABASED IN THE CLOUD
LESS FUNTIONALTY THAN ON PREMISES DBS
AMAZON RELATIONA DATABASE SERVICE, MICROSOFT SQL AZURE
PRIVATE CLOUDS