Database Reference
In-Depth Information
INSERT INTO CLASS(ClassID, CourseID, Credit, TimeID, DayID,
SemesterID)
VALUES(2001, 'ISC3321', 3, 2, 4, 2)
3. As shown in Figure 4.17, rows are added to the tables in the database Class_Registration.
Now, you have both the Computer_Store and Class_Registration databases ready for
operation on Windows Azure. In later chapters, you will learn how to retrieve information
from these databases and develop database applications.
Figure 4.17
Populate Class_Registration database with SQL statements.
4.6 Summary
In this chapter, SQL has been used to implement relational databases. You have learned how to
use Data Deinition Language (DDL) to create, alter, and delete database objects such as data-
bases, tables, and schemas. You also learned to use Data Control Language (DCL) and Data
Manipulation Language (DML) statements to manage database objects. After tables are created,
you can enter data into the tables with SQL statements.
