Class Notes (1,100,000)
CA (650,000)
SFU (10,000)
BUS (1,000)
BUS 237 (100)
Lecture 8

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


Department
Business Administration
Course Code
BUS 237
Professor
Zorana Svedic
Lecture
8

This preview shows half of the first page. to view the full 1 pages of the document.
CHAPTER 5
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
o 2 types of DBMS:
Enterprise process large org databases
Personal for smaller databases
Presentation of content= use CMS which enables company to standardize the look and feel of a site,
control info available to customers/employees
o Increased organization
Spreadsheet = list involving single important thing
Database = multiple lists of related things
o 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
Primary key = most unique category
Foreign key = key in a table derived from another table
Types of relationships = 1:1, 1:many, many:many
Metadata
Data that describes data, makes databases more useful & easier to use
Data hierarchy:
o Database collection of related objects
o Table (file) classified by application/use, pertain to a thing/event
o Record (row) logically related fields
Master = status of an activity (e.g. customer account)
Transaction = an event in the business (e.g. transaction date)
o Field group of characters that represent an attribute
Character strings, numeric, logical, special
o Byte
o Bit
Database application = process a database to make it more useful
Made up of:
o Forms read, insert, modify, delete data
o Reports show data in structured context
o Queries gets answers from database
Transaction processing = entity/event (thing that relates to org, status of entity)
find more resources at oneclass.com
find more resources at oneclass.com
You're Reading a Preview

Unlock to view full version