2 - Data Organization

Transaction record vs transaction record record

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: : record • A group of logically related fields such group of logically related fields such as a person's name, birth date, phone no., and address no., and address – A record representing the status of a business entity – Example: An customer record, an inventory item record • Transaction record: Please note that these fields together describe the characteristics of a person, a thing or an event. BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo – A record representing an event in the business business – Example: Shipment records, Invoice records 9 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 10 Database File Table File / Table • A collection of related files / tables collection of related files tables • A collection of related records that are collection of related records that are stored together. • Examples: – customer file, order file, product file BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo These files / tables may not be physically linked but logically related. 11 BUSI 335 Copyright © 2009-10 Y.M. Cheung, William Tan and Carson Woo 12 Basic Operations on Data Basic Operations on Data Two Steps in Data Operations Steps in Data Operations RETRIEVE: Locate and obtain required data. • Step 1: Locate the necessary data 1: Locate the necessa...
View Full Document

This document was uploaded on 03/04/2014 for the course COMM 335 at UBC.

Ask a homework question - tutors are online