SQL Database: Structure, Commands, and Applications

This assignment provides a comprehensive introduction to SQL databases, covering essential concepts such as database structure, SQL commands, and practical applications. The assignment begins by defining SQL and its role in relational database management systems, highlighting the advantages of using SQL for database creation and manipulation. It details the process of creating a database using SQL statements, including the creation of tables and the definition of fields with primary keys and attributes. Furthermore, the assignment explores the advantages of SQL, such as its high functionality, ease of use, and portability. The content is supported by references to relevant research papers. This assignment is designed to give students a foundational understanding of SQL and its use in managing and querying databases. This assignment is available on Desklib, a platform offering past papers and other study resources for students.

SQL (Database app)

INTRODUCTION
• SQL is based on the standard language for manipulating, storing and retrieving data into
database.
• Structure query language is the standards for relational database system. there are
different types of RDBMS such as MS Access, MySQL, Postgres, MS Access and SQL
server.

Why use SQL in database
• SQL is the most popular and suitable for database creation because they provide various
facilities to user.
• It allow for user to access data in the relational database management system.
• It allow for user to define and manipulate data in proper manner.
• It useful for embedded with other standard language such as pre-complier, SQL modules
and other libraries.

Cont.
• It allow for user to create and drop database and multiple table by using SQL commands.
• It allow for user to set permissions on procedures, views and tables.
• It allow for user to perform different function in database and create, stored procedure
for further development.
• It useful for user to set up specific permission on table, views and procedures.

Structure Query Language process

Cont.
• When it will be executing the structure command for relational database management
system so that system identify the best way to carry out request where SQL engine figure
out how to interpret the task.

Cont.
There are different components in the process.
• Optimization Engines
• Classical Query engine
• Query dispatcher
• SQL query engine

How to create database by using SQL language
• A Database is mainly defined the structure set of data or information. In this way, SQL is
the important step to store the data in structured manner. It will create a database through
SQL statements.

Syntax
• Create database DB_name;
This statement will use to execute query for creating new database in SQL.
• For creating the database, it is important to store data in the form of table. While using
create table statement in SQL.

Cont.
For Example-
• Create table Employee
• (
• Enrollment_No int(10);
• Name Varchar(20),
• Subject Varchar (20),
• )

Advantage of SQL
• It can perform high functionality by using SQL queries. User can efficiently retrieve the
large amount of data from database system.
• There are no as such coding required because SQL help for managing database through
SQL statements.
• It is well defined standard, portable and interactive language.

Cont.
• By using SQL queries, every table is broken up into smaller entities called entities.. The
fields in any table consists of primary key and their multiple attributes. A field is a type
of column in database table where it is designed to maintain specific information in
proper manner.