CMPSC 431W Lecture 1:
Document Summary
It maintains a very large, integrated collection of data. A database models a real-world enterprise by using two components. Database management system (dbms) software package designed to store and manage databases. Human resources: storing employee records like salaries, taxes and deductions. File system: collection of individual files accessed by application programs. Data duplication can result in wasted space and inconsistencies. Efficient access: easier to query data compared to a file system. Data integrity: uses something called integrity constraint. Security: easier to set privileges to various people. Concurrent access: ability to check if more than one person is booked on the same seat. Data model: collection of high-level constructs for describing stored data that hides low-level storage details.