Computer Science Question

Based on your understanding of specialization and generalization constraints,use your own words to define and discuss the two primary constraints:Disjointness Constraint and Completeness Constraint. Show the schema mapping of the following Payment EER schema diagram,using Option 8A: Multiple relations-Superclass and subclasses.SQL constraints are used to specify rules for the data in a table. From whathas been studied, what is the benefit of using constraints in DB. Also, explainthree common SQL constraints.Using the relational algebra operations, write the following queries on theCOMPANY relational database schema shown in the figure below.(a) Retrieve the address of employees in department 2 who work less than5 hours per week on the ‘ProductX’ project.(b) Retrieve the names and salary of employees who work on every project College of Computing and Informatics
Assignment 2
Deadline: Tuesday 28/11/2023 @ 23:59
[Total Mark for this Assignment is 8]
Student Details:
Name: ###
ID: ###
CRN: ###
Instructions:
• You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated f older. These f iles must not be in compressed format.
• It is your responsibility to check and make sure that you have uploaded both the correct f iles.
• Zero mark will be given if you try to bypass the Saf eAssign (e.g. misspell words, remove spaces between
words, hide characters, use dif ferent character sets, convert text into image or languages other than English
or any kind of manipulation).
• Email submission will not be accepted.
• You are advised to make your work clear and well-presented. This includes f illing your inf ormation on the cover
page.
• You must use this template, f ailing which will result in zero mark.
• You MUST show all your work, and text must not be converted into an image, unless specif ied otherwise by
the question.
• Late submission will result in ZERO mark.
• The work should be your own, copying f rom students or other resources will result in ZERO mark.
• Use Times New Roman f ont f or all your answers.
Question One
Pg. 01
Learning
Outcome(3):
Create EntityRelationship
model, Relational
Question One
Based on your understanding of specialization and generalization constraints,
use your own words to define and discuss the two primary constraints:
Disjointness Constraint and Completeness Constraint.
model, and write
SQL queries.
2 Marks
Answer:
Question Two
Pg. 02
Learning
Outcome(3):
Create Entity-
Question Two
2 Marks

Show the schema mapping of the following Payment EER schema diagram,
using Option 8A: Multiple relations-Superclass and subclasses.

Relationship
model, Relational
model, and write
SQL queries.
Answer:
Question Three
Pg. 03
Learning
Outcome(3):
Question Three
2 Marks
Create Entity-
SQL constraints are used to specify rules for the data in a table. From what
has been studied, what is the benefit of using constraints in DB. Also, explain
Relationship
three common SQL constraints.
model, Relational
model, and write
SQL queries.
Question Four
Pg. 04
Learning
Outcome(3):
Create EntityRelationship
model, Relational
model, and write
SQL queries.
Question Four
2 Marks

Using the relational algebra operations, write the following queries on the
COMPANY relational database schema shown in the figure below.
(a) Retrieve the address of employees in department 2 who work less than
5 hours per week on the ‘ProductX’ project.
(b) Retrieve the names and salary of employees who work on every project

.
Answer