Tutor profile: James A.

What is the difference between DDL and DML?

DDL stands for Data Definition Language and refers to the part of the SQL Language is used to define database objects. It includes statements like CREATE, ALTER and DROP. DML on the other hand, stands for Data Manipulation Language and involves SQL statements used to make changes to the stored data. It includes SELECT, INSERT, DELETE and Update statements.

How does one create relationships in Microsoft Access?

To view and define relationships between tables in Microsoft Access: 1. Open the Relationships window. On the Database Tools tab, in the Relationships group, click the Relationships button. 2. To create a new relationship, click the primary key field name in the primary table and drag to the related field name in the secondary table. 3. Review the relationship in the Edit Relationships dialog, and then click the Create button.

What is Relational Modeling?

Relational Modeling is the process of observing collections of data, breaking those into smaller groups and finally reassembling them in a logical way. It's the first step in constructing a database. It provides a simple and flexible way to describe data.