Database Design and Manipulation

Individual Report Database
Development
1

INTRODUCTION
A database is based on the collection of data or information that mainly organised
effectively and efficiently. This will provide the facility to access, manage and update large
amount of data within system. Usually database may consider as an important for aggregations
of information records, files and also containing the appropriate data about the transaction or
interactions with consumer.
The report is based on the database whereas company will use to collect or gather large
amount of information. in order to establish the coordination between one or two department
respectively. It will describe about the data manipulation language that usually contain the
different statement which mainly used in the database table design, creation as well as
modification. Furthermore, it will identify the transaction in the database for controlling and
managing the overall processes.
TASK 1
Discuss about the data Manipulation language statements such as delete, update with using
correct syntax with example.
Data manipulation language is based on the computer language that mainly include
various command which permitting user to manipulate data into database system. in this way, it
involved the manipulation for inserting data into database table. Furthermore, it also retrieve the
existing data or information, deleting from existing tables (Roy-Hubara and Sturm, 2020).
Generally, DML is commonly incorporated in the structure query language database.
Data manipulation is resemble with the English language so that it become easier for user
to access information (Chiusano, 2020). In order to enhance the efficient user interaction with
database system. it also used the different kind of commands within database such as select,
insert, update and delete.
Select: this type of command is basically used to retrieve rows from database table.
Syntax
 Select column_name
 From table
 Where condition
2

Update: this type of command is used for modifying the data of one or more records. In this way,
it can be used this type of command
Syntax
 Update table name
 Set column name = value
 Where condition
Insert: this command is basically used for adding one or more record within database table. In
order to insert the information through commands.
Syntax
 Insert into table name
 Colum value
Describe the transaction in the database with example.
A database transaction is a type of symbolizes unit of performed the different action in
the database management system (Roy-Hubara and Sturm, 2020). it can be performed the
activities against the database and also treated as coherent as well as reliable way to perform the
transaction process. The primary purpose of transaction in database is to provide the reliable unit
of work in which allow better recovery from failure (Komarov and et.al., 2020). In this way, it
keep maintain the consistent at the time of failure situation.
Furthermore, there large number of calculation because database contain numerical value
to perform the different tasks. Therefore, Transaction process will help to handle logical
operation in step by step manner.
For Example-
The database is used to store large amount of data or information require by real life
application such as healthcare, finance company. All the money stored in the database so as
require to protect information and keep maintain consistency (Roy-Hubara and Sturm, 2020). On
the other hand, transaction database contain acid properties to manage or organise the
information effectively.
3

TASK 2
List all employees who are working within HR department and Name start with “A”
Output
Listing all titles (software engineer) of employees who are getting more than £20000 salary.
Output
Listing full names and gender who belong to the marketing department.
Output
List the all department names and their department’s managers.
4