Enforcement of Partial Referential Integrity in a Database System | Critique

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