COMM 190 Chapter Notes - Chapter 5: Microsoft Access, Sql, Mysql

• School: Queen's University
• Department: Commerce
• Course: COMM 190
• Professor: Yasmeen Mufti

Document Summary

Chapter 5: database and content management (q1 to q7) Intellectual property: form of creative endeavor that can be protected through a trademark, patent, copyright, industrial design or integrated circuit topography. Challenge: not collecting & distributing, but presenting it appropriately for various stakeholders inside and outside of organizations. Challenge: indexing or cataloguing the right information, processing & storing it, and then getting it to the right person in the right format at the right time. Separate management of content data from the presentation of content. Data management: efficiently and effectively store and process bytes through organizational database management systems (dbms) -> central. Lists for single theme: spreadsheet, lists for multiple themes: databases. Purpose of a database: to keep track of things that involve more than one theme. Hierarchy of data elements: byte: character of data, grouped into columns/fields, grouped into rows/records, grouped into tables/files.