CHP. 5 Flashcards
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 (CMSs)
An information system that tracks organizational documents, webpages, graphics, and related materials.
Database
A self-describing collection of integrated records.
Columns, Fields, Groups of bytes
A database table has multiple columns that are used to represent the attributes of an entity. Examples are PartNumber, EmployeeName, and SalesDate.
Rows or Records
groups of columns in a database table.
Table or File
a group of similar rows or records in a database.
Key
(1) A column or group of columns that identifies a unique row in a table. (2) A number used to encrypt data. The encryption algorithm applies the key to the original message to produce the coded message. Decoding (decrypting) a message is similar; a key is applied to the coded message to recover the original text.
Foreign keys
A column or group of columns used to represent relationships. Values of the foreign key match values of the primary key in a different (foreign) table.
Relational databases
Databases that carry their data in the form of tables and that represent relationships using foreign keys.
Relation
The more formal name for a database table.
Metadata
Data that describe data.
Database application system
Applications with the standard five components that make database data more accessible and useful. Users employ a database application that consists of forms, formatted reports, queries, and application programs. Each of these, in turn, calls on the database management system (DBMS) to process the database tables.
Database management system (DBMS)
A program used to create, process, and administer a database.
DB2
A popular, enterprise-class DBMS product from IBM.
Access
A popular personal and small workgroup DBMS product from Microsoft.