ITM 207 Midterm: 1-5

4 Pages
Unlock Document

Ryerson University
Information Technology Management
ITM 207
Joseph Lee

Information system -software that helps the user organize and analyze data Electronic spreadsheets and database management systems -Software tools that allow the user to organize, manage and analyze data in various ways. Spreadsheet -A software application that allows the user to organize and analyze data using a grid of labelled cells. —A cell can contain data or a formula that is used to calculate value. — Data stored in a cell can be text, numbers, or “special” data such as dates. — Spreadsheet cells are referenced by their row and column designation. Circular references. - A set of formulas that ultimately rely on each other Spreadsheets are useful because we are able to instal what-if analysis Data Management Systems -Database — A structured set of data - Database management system (DBMS) — A combination of software and data, made up of a 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 the database contents Database schema — A specification of the logical structure of the data stored in the database Database query — A request to retrieve data from database. Relational DBMS — data items and the relationships among them are organized into tables Tables — A collection of records. Records (object, entity) — A collection of related fields that make up a single database entry. Relational DBMS — data items and the relationship among them are organized into tables. Tables — A collection of records. Records (object, entity) — A collection of related fields that make up a single database entry. Fields (attributes) — A single value in the database. Key —One or more fields of a database record that uniquely identifies it among all other records in a table. Structured Query Language (SQL) - A comprehensive relational database language for data manipulation and queries Database Design -Entity-relationship (ER) modelling. — A popular technique for designing relational databases. ER diagram — A graphical representation of an ER model Cardinality constraint— The number of relationship that may exist at one time Amon g entities in an ER diagram. E-Commerce The process of selling and buying products online. The Web — An
More Less

Related notes for ITM 207

Log In


Don't have an account?

Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.