Computer Science 1032A/B Lecture Notes - Lecture 2: Database, Big Data, Management System

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B
• Professor: Louis Magguilli

Document Summary

Lecture 2 - introduction to business database structures. How? (ac) database: definition: a collection of data: storing and grouping, relational database: groups of data are related to each other in a meaningful. A database way: self-describing collection of integrated records. Components of a database: tables or files + relationships among rows in tables + metadata (description of the structure of database) = database. Metadata: databases are self-describing, contain description of its content, metadata, data that describes data, makes databases more useful, makes databases easier to use. How: build the database, create, tables, fields, populate, data. Table views: datasheet view, add records, edit records, delete records, design view, create fields, modify fields. How: create a (cid:858)(cid:373)odel(cid:859) of the database. Reality and models: what is a model, representation of reality that retains only selected details, models are a, powerful tool for validating necessary details and eliminating irrelevant details.