University Data Design Assessment: SQL Statement Analysis Report

This report provides a detailed critique of a student's SQL assignment, focusing on their data design and database implementation. The student demonstrated a basic understanding of SQL, successfully creating tables (Employee, Department, and Salary) with appropriate keys and inserting data. However, the analysis highlights areas for improvement, such as the inconsistent use of SQL statements, particularly in complex queries involving joins, subqueries, and the `GROUP BY` clause. The report also points out the importance of consistent naming conventions and case sensitivity to avoid potential errors. Furthermore, it suggests the student explores resources like the book 'Fundamentals of Database System' for a deeper understanding of database design, ER diagrams, and relational schemas. The critique offers constructive feedback on the student's SQL skills and provides recommendations for enhancing their grasp of database concepts and query optimization. The student is advised to practice complex queries including the use of `WHERE`, `UPDATE`, `LIKE`, `UNION`, `MAX`, `MIN` and also the `ORDER BY` clause to improve their understanding of SQL statements.

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.