Computer Science 1032A/B Study Guide - Final Guide: Enterprise Application Integration, Sql, Database

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

Document Summary

Content: something of value and considered an asset just like other properties related to intellectual property. Intellectual property: a form of creative endeavour that can be protected through a trademark, patent, copyright, industrial design, or integrated circuit topography. Content management systems information system that tracks organizational documents, webpages, graphics, and related materials. Purpose of a database: keep track of things that involve more than one theme or entry. Database: self-describing collection of integrated records database contains, within itself, a description of its contents. Byte: a character of data grouped into columns, which are also called fields grouped into rows, which are called records. Database is a collection of tables plus relationships among the rows in those tables, plus special data called metadata that describe the structure of the database. Key: a column or group of columns that identifies a unique row in a table. Foreign keys: a column or group of columns used to represent relationships.