COMMERCE 2KA3 Lecture Notes - Lecture 4: Data Manipulation Language, Data Dictionary, Database

• School: McMaster University
• Department: Commerce
• Course: COMMERCE 2KA3
• Professor: Montazemi Ghasemaghaei

Document Summary

How businesses store, organize, and manage their data has a tremendous impact on organizational effectiveness. Potential business effect resulting from low quality information include: Course is an e data and grad an entity here, student id, course, grade are attributes data and grad. Record: is a row file: a group of records. Entity: a person, place, thing, or event about which information is stored and maintained. Attribute: each characteristic of quality describing a particular entity. Inconsistency: when same attribute may have different values. Coupling of data stored in files and the specific programs so that changes in programs require changes to the data. Routing scheduled grade are attributes are attributes table describes is the entity. A collection of data organized to serve many application efficiently by centralizing the data and controlling redundant data. Software that permits an organization to centralize data, manage them efficiently, and provide access to the stored data by application programs.