ITEC 1010 Study Guide - Final Guide: Data Manipulation Language, Data Definition Language, Virtual Private Network

• School: York University
• Department: Information Technology
• Course: ITEC 1010
• Professor: Marina Erechtchoukova

Document Summary

There are 3 ways to access data and this is 1. Problems with the file environment there are 5 this is 1. data redundancy 2. inconsistency etc Guam is transformed into information management system. Database architecture is centralized database and distributed database. To create a database you need 1. conceptual design: semantic data models. 2. logical design: model of database showing org based on dbms. 3. physical design: shows ways db is stored in secondary storage devices. Db components is key,primary key,entity,attribute, entity class. Entity relationship diagram is process of conceptual database design. Degree of a relationship is a set of numbers in the entity class. Data models is the way data is conceptually designed: 3 components to this: 1. hierarchial. Commonly used operations in a db are (rel db) are select, project, join. Dbms is software program that provides access to db"s. A schema is description of logical structure of all data in db.