-the purpose of a database is to keep track of things
-a database is a self describing collection of integrated records
-databases are made up of columns, rows, tables, files
-databases are self-describing collection of integrated records (recrods are integrated because relationships among rows are represented in the database)
-databases are self-describing because they not only contain data, bu also data about the data in the database (called metadata)
-database management system is a program used to create, process, and administer a database
-developers use the DBMS to create tables, relationships, and other structures in a database
-DMBS functions to process a database. Applications use the DBMS for four operations (read, insert, modify, or delete)
-DMBS are also used to provide tools to assist in the administration of the database (set up security)
database application is a collection of forms, reports, queries, and application programs that process a database
-data entry forms are used to read, insert, modify, and delete data
-DBMS programs provide comprehensive and robust features for querying database data
-application programs process logic that is specific to a given business need. It enables database processing over the internet
-enterprise DBMS products process large organizational and workgroup databases while personal DBMS products are designed for smaller, simpler database applications. Today the only remaining personal DBMS is probably Microsoft Office
-because the design of the database depends entirely on how users view their business environment, user involvement is critical for database development
-database must require the data necessary for the users to perform their jobs, it contains that amount of data and no more. During database development the developers must rely on the users to ell them what to include in the database
-Before building the database the developers construct a logical representation of database data called a data model. Data models describe the data and relationships that will be stored in the database
-Entity-relationship data models define entities that will be stored in the database that has a relationship among other entities.
-database design is the process of converting a data model into tables, relationships, and data constraignts. Database design team transforms entities into tables and expresses relationships by defining foreign keys
-tables that are not normalized are subject to data integrity problems
-database is a model of how the users view their business world. Users are the final judges as to what data the database should contain and how the records in that datbase should be related to one another
No comments:
Post a Comment