Database Enterprise Management System | Project Title with Abstract For Computer Science Students - TamilYoungsters
DATABASE ENTERPRISE MANAGEMENT SYSTEM
ABSTRACT
The proposed Database Enterprise Manager is a windows
application tool for Microsoft SQL Server 2000 and provides a user
interface
that allows users to:
Ø Create and administer
all SQL Server databases in each registered server.
Ø Define and execute all
SQL Server administrative tasks on each registered server.
Ø Using the Database
Enterprise Manager, any user can easily create and manage databases in SQL
server.
Ø Tables, Stored
Procedures and Views can be created in each database.
A database in
Microsoft SQL Server 2000 consists of a collection of tables that contain data
and other objects, such as views, stored procedures etc, defined to support
activities performed with the data. SQL Server can support many databases where
the user can store the data in the relational model. The database enterprise
manager facilitates the creation and manipulation of databases.
Tables are database objects that
contain all the data in a database. A table definition is a collection of
columns. Using the database enterprise manager the users can create the tables
in Microsoft SQL Server. The user can give the table name and set the other
properties of tables like table columns, table rows etc.
A view is a virtual table whose contents are defined by a query. The rows
and columns of data come from tables referenced in the query defining the view
and are produced dynamically when the view is referenced.
Stored procedures in SQL Server can
accept input parameters and return multiple values in the form of output
parameters to the calling procedure or batch. It can contain programming
statements that perform operations in the database, including calling other
procedures and it returns a status value to a calling procedure or batch to indicate
success or failure (and the reason for failure).
