EECS 1520 Chapter Notes - Chapter 12: Relational Model, Pattern Matching, Sql

• School: York University
• Department: Electrical Engineering and Computer Science
• Course: EECS 1520
• Professor: John Hofbauer

Document Summary

Information data that has been organized to help answer questions and solve problems. Information system software that helps organize and analyze data. Flexible application software tools that allow user to dictate and manage organization of data; have basic processing capabilities to analyze data in various ways. E. g. electronic spreadsheets, database management systems, e-commerce. Spreadsheet software application that allows user to organize and analyze data using grid of labeled cells. Can be text, numbers or special data e. g. dates. Characters and texts referred to as labels in excel. Text cannot be used for calculations; can also include numbers, date values, logic values. Contain data or formula used to calculate value. Referenced by (column, row) e. g. a1, c7, g45 and so on after 26th column, beings to use 2 letters for column e. g. aa1. An example of a spread sheet containing raw data and processed data (information) *note that the titles do not only for human readability contribute to calculations;