Category: Databases

Q1: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.
Q2:Show the schema mapping of the following Payment EER schema diagram, using Option 8A: Multiple relations-Superclass and subclasses.
Q3: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 three common SQL constraints.
Q4: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.

·You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
·It is your responsibility to check and make sure that you have uploaded both the correct files.
·Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different 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 filling your information on the cover page.
·You must use this template, failing which will result in zero mark.
·You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
·Late submission will result in ZERO mark.
·The work should be your own, copying from students or other resources will result in ZERO mark.
·Use Times New Roman font for all your answers.

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
Retrieve the names and salary of employees who work on every project,

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

Based on your understanding of specialization and generalization constraints, use your own words to define and discuss the two primary constraints: Disjointness Constraint and Co
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 what has been studied, what is the benefit of using constraints in DB. Also, explain three common SQL constraints Using the relational algebra operations, write the following queries on the COMPANY relational database schema shown in the figure below.
Retrieve the address of employees in department 2 who work less than 5 hours per week on the ‘ProductX’ project.
Retrieve the names and salary of employees who work on every project.

– PLEASE READ THE Instructions CAREFULLY
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different 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 filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
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.
you can check the other questions in the file / please Read the instructions carefully / No plagiarism

Hello, I want a solution free of similarity and cheating, and an ideal solution through which I can get the full grade as I want the file to be pdf and word

Hello, I want a solution free of similarity and cheating, and an ideal solution through which I can get the full grade as I want the file to be pdf and word

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g. misspell words, remove spaces between words, hide characters, use different 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 filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.

You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero mark will be given if you try to bypass the SafeAssign (e.g., misspell words, remove spaces between words, hide characters, use different 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 filling your information on the cover page.
You must use this template, failing which will result in zero mark.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.
Late submission will result in ZERO mark.
The work should be your own, copying from students or other resources will result in ZERO mark.
Use Times New Roman font for all your answers.
· This project worth 14 marks and will be distributed as in the following:a) Identify the entity types, attributes, keys. (2 marks)b) Identify the relationship and cardinalities. (2 marks)c) Draw the ERD. (2 marks)d) Schemas before Normalization. (1.5 marks)e) Schemas after Normalization. (1.5 marks)f) Create the tables. (1.5 marks) g) Populate your tables with at least 5 rows. (1.5 marks)h) Execute the requested sample queries. (2 marks)· Each student must submit one report about his/her chosen Project via the Blackboard (Email submission will not be accepted which will be awarded ZERO marks)· Screenshots for answering SQL questions (f, g, and h).· You are advised to make your work clear and well presented; marks may be reduced for poor presentation. This includes filling your information on the cover page.· You MUST show all your work, and text must not be converted into an image, unless specified otherwise by the question.A) Late submission will result in ZERO marks being awarded.B) The work should be your own, copying from students or other resources will result in ZERO marks.I
I hope everything is clear at the end add tow names in the names space 1- ABDULRAHMAN ABDULLAH AHMED 2- MOHAMMED ALMUTAIRI
You should avoid pilgrims and write by your own