AFM341 Chapter Notes - Chapter 4: Database Administrator, Unique Key, Foreign Key

• School: University of Waterloo
• Department: Accounting & Financial Management
• Course: AFM341
• Professor: Adeel Mahmood

Document Summary

Database: a collection of related data for various uses. Databases used in a business setting often maintain information about various types of objects, events, people, and places. Hierarchical data model: organizes data into a tree-like structure that allows repeating information using parent/child relationships. Network data model: a flexible model representing objects and their relationships. The network model allows each record t o have multiple parent and child records. Relational data model: stores informati on in the form of related two -dimensional tables. Allows designers and users to identify relationships t o the time the database is created or much later. Relation al data models have three main advantages: flexibility and scalability, simplicity, reduced information redundancy. Database management system (dbms): a computer program that creates, modifies, and queries the database. The dbms is designed to manage a database"s storage and retrieval of information.