ADM 2372 Final: ADM2372 Final review.docx

• School: University of Ottawa
• Department: Administration
• Course: ADM 2372
• Professor: Nour El- Kadri

Document Summary

Data are raw facts that describe the characteristics of an event. Information is data converted into a meaningful and useful context. Information granularity refers to the extent of detail within the information (fine and detailed or coarse and abstract) The value of transactional data and analytical information. Transactional data: sales receipts, airline tickets, packing slips. Analytical information: product statistics, sales projections, future growth, product trends. The value of quality data and information metrics. The value of quality data and information: missing information (no first name, probable duplicate data (similar names, same address, same phone number, potential wrong data (are the phone and fax number the same or is it an error?) Information is store in databases: database: maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Entity: a person, place, thing, transaction, or event about which information is stored: the rows in each table contain the entities.