Please enable JavaScript.
Coggle requires JavaScript to display documents.
UNIT -I - Coggle Diagram
UNIT -I
FILE VS DATABASE SYSTEM
security constraints
complexity
cost
data independence
consistency
user access
query processing
sharing
backup and redundancy
data abstraction
data redundancy
integrity constraints
structure
ON THE BASIS OF
APPLICATION OF DBMS
banking
credit card exchange
library management system
education sector
railway reservation system
social media sites
human resource management
broadcast communications
account
online shopping
airline reservation
manufacture
ADVANTAGE OF DBMS
minimized data inconsistency
faster data access
better data integration
better decision making
better data security
increased end user productivity
better data transaction
data abstraction
reduction of data redundancy
simple
CHRACTERISTICS
stores any kind of structured data
sql and no sql
concurrent access without anomalies
ease of access
self explaining nature
secutity
real time entity
reduced redundancy
integrity
atomicity of operations
DIFFERENT TYPES OF DATABASE USERS
application programmers
database designer
sophisticated user
system analyst
naive end user
database administrator(dba)
DIFFERENT MODELS IN DBMS
er model
relation model
network model
object oriented model
hierarchical model
DIFFERENT ARCHICTURES IN DBMS
centralized architecture
client server architecture
2-tier architecture
3-tier architecture
1-tier architecture
SCHEMA
physical schema
logical schema