
270 ◾ Cloud Database Development and Management
information such as student names, classes that the students are enrolled in, the students’ advi-
sors, and so on. ese views can be created by selecting the data from the tables STUDENT,
CLASS, FACULTY, and STUDENT_CLASS as shown in the following tasks.
TASK 1: CREATING VIEW USING SQL DATABASE
Let us create a view called STUDENT_ADVISOR_VIEW.
1. On your local computer, log on to Windows Azure through the URL
https://yourserver.database.windows.net
where yourserver is your SQL Database server name.
2. Enter the database name Class_Registration. en, enter your user name and pass-
word to log on ...