DBMS | DDL Commands | Exp -1

Database Management System

Database is a collection of inter-related data which helps in efficient retrieval, insertion and deletion of data from database and organizes the data in the form of tables, views, schema's, reports etc.

DDL | Data Definition Language

DDL is short name of Data Definition Language, which deals with database schemas and descriptions, of how the data should reside in the database.

• CREATE - to create a database and its objects like (table, index, views, store procedure, function, and triggers)
• ALTER - alters the structure of the existing database
• DROP - delete objects from the database
• TRUNCATE - remove all records from a table, including all spaces allocated for the records are removed
• COMMENT - add comments to the data dictionary
• RENAME - rename an object

Problem Statement

Company want to maintain the Order with following information such as order no, amount and date of all orders.Customer to maintain following information such as customer id, customer name, order no, salesman no and Salesman to maintain the following information such as salesman no, salesmen name, commission, order no.

File: Download here