ITM 309 Lecture Notes - Lecture 12: Microsoft Access, Access Control, Business Intelligence

• School: MSU
• Department: Information Technology Mgmt
• Course: ITM 309
• Professor: Rodammer

Document Summary

Building blocks: character: lowest level; letter, number, symbol, field: student name, pid, records: student name; pid; course section , files: all students in itm 209, database: business students (all majors), itm 209 students. Information quality: accurate, complete, consistent, unique, timely. Sorting information in a relational database: microsoft access is an example of a relational database. Database: maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses) Advantages of a relational database: increased flexibility. Physical view: deals with the physical storage of information on a storage device. Logical view: focuses on how individual users logically access information to meet their own particular business needs: increased scalability and performance. Scalability: refers to how well a system can adapt to increased demands. Performance: measures how quickly a system performs a certain process or transaction: reduced information redundancy. Information redundancy: the duplication of data or storing the same information in multiple places: increased information integrity (quality)