ACCT 307 Lecture Notes - Lecture 14: Database, Data Modeling, Management System
Document Summary
What is a database: a large collection of related data, used by many different computer applications, manipulated by specialized software packages, called database management systems. Users: create tables, create forms, create query, create reports. Database management systems: from a technical standpoint, dbmss can differ widely, the terms hierarchical, network, relational, and object-oriented all refer to the way a. Dbms organizes information internally: the internal organization can affect how quickly and flexibly you can extract information. Relational databases: a relational database is a collection of tables, a relation is a collection of data (a table) representing multiple occurrences of an object, event, or agent, example: figure 3-11, pg. *rows are tuples or records: open the northwind database in access. Storing data in databases: data must be stored and organized systematically, three important concepts, data hierarchy, record structures, database keys. Data hierarchy: data organization in ascending order, data field, record, file, database.