Study Guides (248,019)
Canada (121,233)
Administration (1,201)
ADM2372 (45)
All (20)

MIS Final Exam Condensed.docx

28 Pages
Unlock Document

All Professors

Chapter 7Databases and data warehouses are the centre of all information systems Databases Store the information necessary for day to day transactions Operational levelData Warehouses Store information for analysis and decision making Management and strategic levels Bit Smallest unit of data binary digit01Byte Group of bits representing a single character Field or column group of characters representing an attribute or characteristic or propertyRecord or row group of related fields describes and entity eg person event place about which information is stored Database group of related filesData Are raw facts that describe the characteristics of an event Information is data converted into a meaningful and useful contextInformation granularity refers to the extent of detail within the information fine and detailed or coarse and abstract Levels Formats Granularities Data redundancy same data stored in more than one locationProgram Data Dependence changes in programs required changes to the dataLack of Flexibility only routine reports hard to obtain adhoc reportsPoor security little knowledge of who is accessing or making changes to the data Lack of data sharing no sharing of data between different applications or parts of the organizationTransactional data encompasses all of the data contained within a single business process or unit of work and its primary purpose is to support the performing of daily operational tasksAnalytical information encompasses all organizational information and its primary purpose is to support the performing of higherlevel analysis tasksThings that form low quality informationMissing informationIncomplete informationInaccurate informationDuplicate informationPotential wrong informationIncomplete informationHigh Quality InformationAccurate is the name spelled correctlyComplete is the address complete Consistent does the total field equal the total of the individual fieldsUnique are there any duplicate customersTimely is information updated weekly daily or hourlyA database Maintains information about various types of objectsinventory eventstransactions people employees and places warehouses A database isA collection of data organized to serve several applications efficiently Database models includeHierchical database model information is organized into a treelike structure using parent child relationships in such a way that it cannot have too many relationships Network database model a flexible way of representing objects and their relationships Relational database model Stores information in the form of logically related twodimensional tables Entity A person place thing transaction or event about which information is storedThe row in each table contain entitiesEntity Classtable a collection of similar entities Attributesfields columnscharacteristics or properties of an entity class The columns in each table contain the attributes Customer ID Customer name
More Less

Related notes for ADM2372

Log In


Join OneClass

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

Sign up

Join to view


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.