The magazine distributor company has several branches throughout Malaysia. The data identifying each branch address, telephone number
Question:
The magazine distributor company has several branches throughout Malaysia. The data identifying each branch address, telephone number (maximum up to 2 telephone numbers), and fax number. Each branch is given a branch number which is unique throughout the company. Each branch has staff and the data identifying on each staff is the name, position, salary, and the data a staff joined. Each member of staff is given staff number, which is unique throughout the company. The company distributes a variety of magazines, which are identified by the magazine code. Data identifying each magazine are number of issues per year, price of each issue, and nature of language. When a customer orders a magazine, order duration, total payment, and payment method are recorded. Each customer is given a unique number throughout the company. The data accorded to each customer is the name, adders, and contact number. Number of orders from each branch varies each month; therefore, month and year (as single attribute), and number of copies are recorded for each branch one each magazine title.
Question
Describe the following with examples when tables are designed and created (use the scenario):
i. Data Manipulation Language (DML)
ii. Data Definition Language (DDL)
iii. Data Control Language (DCL)
Database Systems A Practical Approach to Design Implementation and Management
ISBN: 978-0132943260
6th Edition Global
Authors: Thomas Connolly, Carolyn Begg