BUS 237 Lecture Notes - Lecture 8: Transaction Processing, Database Application, Database

• School: Simon Fraser University
• Department: Business Administration
• Course: BUS 237
• Professor: Zorana Svedic

Document Summary

Challenge = processing/storing right content for right person in right format at the right time. Content management = use dbms which create, process, administer a database: 2 types of dbms: Presentation of content= use cms which enables company to standardize the look and feel of a site, control info available to customers/employees. Spreadsheet = list involving single important thing: database = multiple lists of related things, tables/files + relationships among tows in tables +metadata. Tables/files (made up of records/rows, fields/columns, bytes, bits: relationships among row in tables. Key = identifies a unique row in a table. Foreign key = key in a table derived from another table. Transaction = an event in the business (e. g. transaction date) Field group of characters that represent an attribute. Character strings, numeric, logical, special: byte, bit, database application = process a database to make it more useful, made up of: