Database Reference
In-Depth Information
Chapter 9
Database Application
Development
Objectives
◾
Create forms
◾
Design user interfaces
9.1 Introduction
Once an SQL database is made available on Windows Azure, it is time to develop database
applications. hrough these applications, users can interact with the database to perform tasks
such as importing and exporting data, enforcing constraints and security, and implementing
business logic.
To assist users in dealing with the data stored in databases, various database applications are
created. Forms are used to enter, display, and update data stored in a database. Reports are used
to present information. Data stored in a database can also be used for data analysis and for deci-
sion making. A database application provides a GUI environment where controls and menus are
created for data manipulation.
Database applications can be created with programming languages such as VB.NET, C#.NET,
ASP.NET, Java, or scripting languages such as JavaScript, PHP, and Pearl, or enhanced SQL lan-
guages such as Transact-SQL. Microsoft Visual Studio is a commonly used database application
development package. It provides an integrated environment that supports multiple programming
languages. Microsoft Access is a DBMS mainly for small businesses or personal database use. It is
also a good application development tool for creating forms and reports.
Database applications can greatly beneit from the cloud computing platform. With the hard-
ware, network and license-related issues are taken care of by the cloud provider and the application
developers can focus on developing the database applications. hese database applications can be
deployed on the Internet so that they are available to anyone who has the permission to access them.
