Assignment on what is Data Design?

i only need as per question but i dont need reference thank u

Running head: DATA DESIGN
DATA DESIGN
Enter the name of the Student:
Enter the name of the University:
Author note:

1DATA DESIGN
Table of Contents
1. Complete practice of SQL statements and the commands.....................................................2
2. Progress the understanding of SQL statements......................................................................2
3. Various valuable readings......................................................................................................3

2DATA DESIGN
1. Complete practice of SQL statements and the commands
Beginning from the statements of the DDL, this are executed effortlessly according to
the requirements. All data types, the sizes of them also the main limitations are perfectly
described. There are three tables are present which are Department, Employee and Salary.
The department_id that is present in the Department table is the parent table of the table
Employee. The use of the statement SELECT is done on the preferable places. The process of
inserting the data in the table Department is done first. Some of the task is perfectly executed
such as in the Task 2, the query no 5 and 7. On the other hand, some of query is not done
properly like the Task no 11. The total use of the statements of the SQL is mediocre.
Although, the entire concept is required to be perfect.
2. Progress the understanding of SQL statements
The understanding of the statements of SQL is improved by the huge practice of this.
The practice stands for the dissimilar varieties of the scenarios also the dissimilar varieties of
the queries that are complex. The several example are present of this complex queries that
can create a thought of the writing SQL perfect which are having, alias, sub queries, joins,
group by and many more that are very helpful. There are many areas are present that are very
good as using the LIKE, WHERE, UPDATE and many more. There is a most significant
feature is existing in the database that is the naming convention. This naming convention is
followed Table_Name or the TableName hencel. This is helped to determine the dissimilarity
between the table name and the column name in the period of performing any of the query.
Also there is not present the alphabet cases in the consistency. Some of the names in the table
of Employee are in the Uppercase and some of them are in the case of Sentence. For avoiding
any type of case sensitive code or query, storing of the data with the consistency of the case is
so much significant. Some of the queries are missing the group by statements or the max and

3DATA DESIGN
the min concept on nay numeric value. In the query of the Task 10, it does not provide
employee name with the maximum and the minimum salaries. This can be completed by the
help of the sub query or the syntax of UNION. Also, in the Task 17, the DESC syntax is
missed after the ORDER BY Salary for showing the list in the descending order.
3. Various valuable readings
The Structured Query Language or SQL is used to enable the storing also the
retrieving from any database. According to the name of the database, the single statement
should have to be always structured. By performing the ERD that is Entity Relationship
Diagram also the conceptual schema alongside with the several dissimilar case studies can
help. There are many books are available, among them the book named ‘Fundamentals of
Database System’ is the perfect one for the beginners for starting the learning the database
from the basic level. This book is delivered several types of the case studies also the
scenarios of the business for developing the ERD, the genuine database and the relational
schema.