Critique of Database Design and Programming in MIS602

This report presents a critique of a database design project, focusing on the creation of three tables (Department, Employee, and Salary) and the insertion of employee records. The critique highlights the successful implementation of primary keys but identifies the absence of foreign keys and referential integrity as a major drawback. The report evaluates a provided SQL query for retrieving staff numbers and salaries per department, suggesting improvements using foreign keys and JOIN operations. The author also acknowledges the limitations due to the provided link, and suggests the use of high-end database platforms. The report emphasizes the importance of database functions such as COUNT, MIN, and MAX and provides suggestions for improvement. The report concludes by highlighting the strengths of the work in terms of table creation and data entry while pointing out areas where the design could be improved.

Running head: CRITIQUE
Critique
Name of the Student:
Name of the University:
Author Note
Page 0 of 4

Running head: CRITIQUE
CRITIQUE
This paper is being developed to create a critique for the work submitted by my friend
Amit. My friend has developed is work in https://www.w3schools.com/sql/. The work completed
by friend includes the three tables as per the instructions provided to us. In addition to this, my
friend Amit has successfully created the primary keys for each of the table which is very
essential part of any database, as the primary keys develop the uniqueness of the data which are
required to be stored in the database. In addition to this, my friend has also successfully entered
the values in the database. However, the reference has not been established in this database and
an absence of the foreign has been identified here. As per the requirement we were required to
create a reference in between the department table and the employee table, where a certain
number of employees are working under a certain department. Therefore, the developed of the
database can be criticized on the basis of the referential integrity. Additionally, the link provide
my friend Amit does not provide any data and hence, the further evaluation of the queries
developed by my friend were difficult. Additionally, it can be suggested that database be
developed in high end platforms such as PHP MyAdmin database. This would be provided an
easier chance for the evaluation of the records and the queries developed by my friend.
The assignment also provided the requirement of “Write a query to find the number of
staff working in each department and the sum of their salaries”. To this my friend has responded
with the query Select department.deptname, count(employee.employee_id) as
Total_no_of_staffs, sum(employee.salary) as sum_of_their_salaries from department , employee
where employee.Department_id=department.Department_id GROUP by
(department.Deptname);
Page 1 of 4

Running head: CRITIQUE
Although this was great effort by my friend Amit and he has been able to fetch results from the
query, the query might show some errors on the high end database application as my friend has
decided to create the refrence with the help of from department, employee where
employee.Department_id=department.Department_id query. However, it is advisable that my
friend uses a foreign key in the employee table and make use of the inner join syntaxes with the
keys. Additionally, I would like to point out that the rest of queries developed are quite flawless
and has obtained very effective results for the reader.
This assignment would be helpful for the readers to get a very effective knowledge for
table creation and entering data. In addition to this, they would also be provided with the
information about the different type of queries that can be handled within a database. There are
different type of database functions such as COUNT, MIN, MAX which has been used in the
assignment so that the reader would be able to get an insight on these type of function which can
be used in a database system. However, the major drawback has been absence of foreign key and
Join command.
Page 2 of 4

Running head: CRITIQUE
Bibliography
Jaja, A. I., & Bennett, E. O. (2018). Enforcement of Partial Referential Integrity in a Database
System. INTERNATIONAL JOURNAL OF COMPUTER SCIENCE AND
MATHEMATICAL THEORY, 4(2), 27-33.
Page 3 of 4