ITM 207 Lecture Notes - Lecture 1: Sql, Uniform Resource Locator, Database Engine
19 Jan 2017
School
Department
Course
Professor
Document Summary
Information system: software that helps the user organize and analyze data. Electronic spreadsheets and database management systems: software tools that allow user to organize, manage and analyze data in various ways. Spreadsheets: a software application that allows users to organize and analyze data using a grid labeled cells. Cells: contain data or formula that is used to calculate a value. Data stored can be text, numbers or special" data (dates) Spreadsheet cells are referenced by their row and column designation. Set of formulas that ultimately rely on each other. Spreadsheets useful due to their dynamic nature (provides the powerful ability to do what-if analysis) Database management system (dbms): a combination of software and data, made up of physical database, a database engine and a database schema. Physical database: a collection of files that contain the data. Database engine: software that supports access to and modification of database contents.
