BMGT 301 Lecture Notes - Lecture 10: Data Manipulation Language, Data Definition Language, Microsoft Access
Document Summary
Data definition language: specifics structure of database content, used to create tables and define characteristics of fields. Data dictionary: automated or manual file storing definitions of data elements and their characteristics. Data manipulation language: use to add, change, delete, retrieve data from database. Many dbms have report generation capabilities for creating polished reports. Microsoft access has a data dictionary that displays information about the size, format, and other characteristics of each field in a database. Displayed here is the information maintained in the supplier table. The small key icon to the left of supplier_number indicates that it is a key field. Illustrated here is how a query would be constructed using microsoft access query building tools. It shows the tables, fields, and selection criteria used for the query. Used by database designers to document the data model. An entity is a person, place, object, event or concept for which data has to be collected.