file system

• importance of database design - avoid redundant data
• managing data with file system is obsolete - awareness of problems with file system helps prevent same problem in DBMS, make database design easier to understand
• manual file system - keep file folders in file cabinet, while growing of file folders, finding and using data become time consuming
• convert manual file system to computer system - technically complex, require hiring DP(data processing) specialists
• file system database management problems - time consuming, make changes in file structures is difficult, more time to debug
• data redundancy - results in data inconsistency, data anomalies occur when changes in redundant data are unsuccessful
• types of data anomalies - insertion anomalies, deletion anomalies, update anomalies
• five main parts of DBMS - hardware, software, people, procedures, data
• DBMS functions - data dictionary management(define data elements and relationship), data storage management, security management, multiuser access control, backup and recovery management, database communication interfaces