BMGT 402 Lecture Notes - Lecture 7: Data Manipulation Language, Ibm System R, Data Definition Language

• School: University of Maryland
• Department: Business and Management
• Course: BMGT 402
• Professor: Woei- Jyh Lee

Document Summary

Bmgt402 lecture 7 - chapter 6: data manipulation continued: objectives of sql a. Ideally, database language should allow user to: a. i. Perform insertion, modification, and deletion of data a. iii. Perform simple and complex queries: must perform these tasks with minimal user effort, command structure/syntax must be easy to learn d. It must be portable: sql is a transform-oriented language with two major components e. i. A data definition language (ddl) for defining database structure e. ii. A data manipulation language (dml) for retrieving and updating data f. It is non-procedural you specify what information you require, rather than how to get it f. ii. It is essentially free-format: consists of standard english words g. i. Create table staff ( g. i. 1. g. i. 2. g. i. 3. staffno varchar(5), lname varchar(15), salary decimal(7,2) ); g. ii. Insert into staff values ( sg16", brown", 8300); g. iii. These had to be implemented using a programming or job-control language, or interactively by the decisions of user k.