COMM 1502 Lecture Notes - Lecture 8: Data Validation, Management System, Database
COMM 1502 verified notes
8/13View all
Document Summary
Data are raw facts such as, name, phone number, price and grades. Information can be accessed and updated quickly and efficiently: metadata is a special data that describes the structure of the database, database is most useful when, they are the most useful when data includes millions of records. E. g. when the data is unmanageable in spreadsheet forms and you want to maintain records for on-going use: the information is subject to many changes. E. g. change of address, pricing changes or real-time changes like account balance: when you want to generate reports based on the information. Database is a collection of tables and relationships among the tables. It is a program that creates, processes and administers a database. It defines and regulates the collection, storage, management and use of data. Dbms provides users and programmers with a systematic way to create, retrieve and manage data: a dbms is a software, they are usually licensed from vendors.