Database Reference
In-Depth Information
a cardinality constraint. You will learn how to create this type of constraint in the chapters that
discuss SQL procedures and triggers.
A database should be built to accommodate business policies and regulations. Most business
rules are application dependent. herefore, they are often implemented in database applications.
In later chapters, triggers and stored procedures will be used to implement business rules in the
chapter activities.
ACTIVITY 3.1 DATABASE IMPLEMENTATION
WITH WINDOWS AZURE SQL DATABASE
In this activity, by following the step-by-step instructions, you will learn how to use Windows
Azure SQL Database to create a database that consists of tables, relationships, and constraints.
For this activity, let us create a database based on the data model displayed in Figure 3.24.
To use Windows Azure SQL Database to implement the database designed in Figure 3.24,
you need to irst create a Windows Azure account, a database server, and a connection to
Windows Azure SQL Database. If you have not done so, refer to Activity 2.2 in Chapter 2 to
complete these steps.
TASK 1: CREATING DATABASE TABLES
1. Log on to the
Windows Azure Management Portal
. Click the
SQL DATABASE
link on the left-hand side of your screen. hen, select the database
Class_Registration
and click
MANAGE
as shown in Figure 3.25.
Figure 3.25
Database DASHBOARD.
