Computer Science 1032A/B Study Guide - Unified Modeling Language, Query Language, Affinity Analysis

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Diane Goldstein

Document Summary

Database= tables or files + relationships among rows in tables + metadata (data that describes data) Database -> dbms -> database application -> user. Database = collection of tables, relationships, and metadata. Database application = a collection of forms, reports, queries, and application programs that process a database. Forms are used to read, insert, modify, or delete data. Sql = structured query language international standard for processing database. Application programs process logic on a business level (use the internet) Multi user processing is common, but poses the lost update problem counting wrong inventories. Some locking must be used to coordinate activities of multiple users. Dbms fall into two categories: enterprise dbms = process large organizational & workgroup databases (sql, personal dbms = designed for smaller, simpler databases (fewer than 100 users) like access, dbase. Data model = description of both the data and the relationships among the data.