Textbook Notes (368,107)
Canada (161,650)
Commerce (1,690)
Chapter 7

Commerce 2KA3 - Chapter 7 Summary

13 Pages
140 Views
Unlock Document

Department
Commerce
Course
COMMERCE 2KA3
Professor
A L I R M O N T A Z E M I
Semester
Winter

Description
Chapter 7 Database Fundamentals IntroductionData Raw facts that describe the characteristics of an eventInformation data converted into a meaningful useful context Understanding InformationThe incredible growth in sales of the Enterprise Search Appliance tool is a strong indicator that businesses desire technologies that help organize and provide access to informationInformational Granularity refers to the extent of detail within the information fine and detailed or coarse and abstract information Employees must be able to correlate the different levels formats and granularities of information when making decisions Range Examples Individual Sales expenses budgets etcDepartment can be conceptualized at Enterprise each of these levels Range Examples Document Letters memos faxes emails reports marketing materials training materials ie MS WordPresentation Product strategy process financial customer competitor ie MS PowerPoint Spreadsheet Sales marketing industry financial competitor customer order ie MS Excel Database Customer employee sales order supplier manufacturer ie MS Access Range Examples Detail How many Honda Civics did Joe Smith Fine sell Summary How many units of each Honda model were sold by each sales person in Ontario Aggregate How many units were sold by each Course automaker in North America Information QualityBusiness Decisions are only as good as the quality of the information used to make the decisionsCharacteristics of high quality information oAccuracyAre all the values correct For example is the name spelled correctly Is the dollar amount recorded properlyoCompleteness Are any of the values missing For example is the address complete including street city province and postal codeoConsistency Is aggregate or summary information in agreement with detailed information For example do all total fields equal the true total of the individual fieldsoUniqueness Is each transaction entity and event represented only once in the information For example are there duplicate customers
More Less

Related notes for COMMERCE 2KA3

Log In


OR

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


OR

By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.


Submit