Order from us for quality, customized work in due time of your choice.
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.Question One
Consider the following EMPLOYEE relation from a company database. Write SQL queries to answer the following questions:EmpIDNameSalaryGenderAddress
123Sarah50000FemaleJeddah
234Mohamed45000MaleRiyadh
376Ahmed70000MaleJeddah
498Maryam10000FemaleJeddah
555Muna30000FemaleRiyadh
1- Retrieve the count of Female Employees.2- Retrieve the average Salary of all Employees.3- Delete the record of the Employee named “Muna”.4- Insert a new employee into the table.Question Two
Answer the following questions by referring to the tables below: COURSECourse_nameCourse_numberCredit_hoursDepartment
Intro to Computer ScienceCS3104CS
System Analysis and DesignIT3534IT
Discrete MathematicsMATH4103MATH
Fundamentals of DatabaseIT4033IT
SECTIONSection_IDCourse_noSemesterYearInstructor
80MATH410Fall23Sara
95CS310Fall23Ali
103IT353Fall24Khaled
115MATH410Fall24Ahmed
120CS310Spring24Ali
140IT403Fall24Eman
a) Create a virtual table called (COURSE_ON_SEC) that summarize courses information along with its section and instructor, listed alphabetically by course name. b) Retrieve the section ID, course name, course number, department, and instructor of the courses taught by instructor “Ali” from COURSE_ON_SEC table.Question Three
You are given a table with unnormalized design. You are required to transform the provided table into First Normal Form (1NF), and Second Normal Form (2NF). For each step, provide the new table(s) and explain the changes made.Order_IDSupplier_NameProducts_InfoOrder_Date
001AmazonP1, product101, product10201-11-2024
002NoonP2, product201, product202, product20304-11-2024
003AlimP3, product30110-11-2024
Question Four
Using join:- write an SQL query to retrieve the names and addresses of all employees who work in Research departments.- Write an SQL query to retrieve the names of all employees who have a higher salary than their manager. Use a self-join to compare the salaries.
Order from us for quality, customized work in due time of your choice.