ITEC 1010 Lecture Notes - Lecture 2: Data Manipulation Language, Data Definition Language, Data Dictionary

• School: York University
• Department: Information Technology
• Course: ITEC 1010
• Professor: Colin Coates

Document Summary

Dbms includes tools for organizing, managing, and accessing the data in the database. Data definition: specify the structure of the content of the database. Be used to create database tables and to define the characteristics of the fields in each table. Information about the database would be documented in a data dictionary. Data dictionary: an automated or manual file that stores definitions of data elements and their characteristics. Microsoft access has a rudimentary data dictionary capability that displays information about the name, description, size, type, format and other properties of each field in a table. Data dictionaries for large corporate databases may capture additional information, such as: ownership who in the organization is responsible for maintaining the data, usage, authorization, security. Individuals, business functions, programs and reports that use each data element. Dbms include tools for accessing and manipulating information in databases. Most have a specialized language called data manipulation.