Description

Description

Please follow the instructions

College of Computing and Informatics

Assignment 2
Deadline: 16/04/2025 @ 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 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.

Restricted – ‫مقيد‬

Question One

Pg. 01
Learning
Outcome(s):

Question One

3 Marks

CLO 3,4
The Saudi Electronic University (SEU) plans to build a database to manage its academic

Design a
database starting
from the
conceptual design
to the
implementation of
database
schemas.

Create EntityRelationship

departments and their staff. Each department employs different types of employees, including
full-time professors, part-time lecturers, administrative staff, and student assistants. While all
employees share common attributes (such as ID, Name, and Email), each subclass has its
own specific attributes:



Full-Time Professors: Office Number
Part-Time Lecturers: Weekly Hours
Administrative Staff: Assigned Tasks
Student Assistants: GPA Requirement

Without drawing a diagram, clearly specify the components of the Enhanced Entity–
Relationship (EER) model based on the above scenario. Your specification must include the
following:

model, Relational
model, and write
SQL queries.

Restricted – ‫مقيد‬

1. Entities and Attributes
o List all entities and their relevant attributes.
2. Specialization/Generalization
o Identify the superclass and subclasses.
o Specify whether the specialization is disjoint or overlapping.
o Specify whether the specialization is total or partial.
3. Relationships
o Include a ternary (or n-ary) relationship that is relevant to the context, such as
a project involving a full-time professor, a student assistant, and an external
sponsor.

Question Two

Pg. 02
Learning
Outcome(s):
CLO 3,4

Question Two

3 Marks

The Saudi Electronic University (SEU) wants to create a basic database to manage students
and the courses they register for. Each student has a unique student ID, and each course has
a unique course code.

Design a
database starting
from the
conceptual design
to the
implementation of
database
schemas.

Create EntityRelationship
model, Relational
model, and write
SQL queries.

Restricted – ‫مقيد‬

Task:
1. Create the SQL Data Definition Language (DDL) statements for the following tables:
o STUDENT
o COURSE
o REGISTRATION (associative table showing which student registered for which
course)
2. Apply the following rules:
o Each student and course must exist before a registration can be recorded.
o If a student or course is deleted or updated, the change should cascade to
the registration table to maintain consistency.
o Include one CHECK constraint to ensure that credit_hours for a course is
between 1 and 5.

Question Three

Pg. 03
Learning
Outcome(s):

Question Three

2 Marks

Consider the following two tables:

CLO4 – Design a
database starting

Employees Table:

from the
conceptual design
to the
implementation of
database
schemas

EmployeeID

FirstName

LastName

DepartmentID

Salary

HireDate

1

Salah

Tariq

101

55000

15.03.2020

2

Ahmed

Muath

102

60000

22.07.2018

3

Fadhel

Mohammed

103

65000

10.05.2021

4

Saad

Nasser

101

70000

25.08.2019

5

Khaled

Ahmed

102

75000

11.01.2020

Department Table:

DepartmentID

DepartmentName

101

HR

102

IT

103

Marketing

Task:
o
o
o

o

Restricted – ‫مقيد‬

Write a SQL query to retrieve the names of employees who were hired after January 1,
2020, and earn more than 60,000.
Write a SQL query to list the department names and the highest salary in each
department.
Write a SQL query to update the salary of the employee with EmployeeID = 2 to
65,000.
Write a SQL query to find the number of employees in each department and order the
results by the number of employees in descending order.

Purchase answer to see full
attachment

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Description

Description see College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name Maternal and Child Health Course number PHC 373 CRN – Branch name XXXXX Assignment title or task: ( write and questions) Discuss the methods, advantages, and criticisms of evidence-based practice in maternal and child health

Description

Description RISK MANAGEMENT IN MULTI-SECTOR PARTNERSHIPS IN SAUDI ARABIA: A GOVERNANCE PERSPECTIVE Thesis Submitted in Partial Fulfillment of the Requirements for the Award of the Degree of MASTER OF BUSINESS ADMINISTRATION BY DINA MANSOUR ALSHEHRI Under Supervision Dr. Asra Inkesar COLLEGE OF ADMINISTRATIVE AND FINANCIAL SCIENCES SAUDI ELECTRONIC UNIVERSITY 2024-2025

Description

Description Comparison In terms of only 1/ The educational objective 2/ The teaching style 3/ The methodology and tools used no Plagiarism 5-6 pages no Plagiarism No AI INTERNATIONAL JOURNAL OF SPECIAL EDUCATION Vol.33, No.2, 2018 Twice-Exceptionality in the Kingdom of Saudi Arabia: Policy Recommendations for Advances in Special Education

Description

Description Hello, you can continue the research while I get the remaining of data from survey so we can get use of time.

Description

Description I do it but I am not sure. Please make short answer The Impact of Remote Work on Employee Productivity: A Study on Government Sector Employees in Saudi Arabia in the Post-Pandemic Era Thesis Submitted in Partial Fulfillment of the Requirements for the Award of the Degree of MASTER

Description

Description please kindly no AI or Chat gbt. Write about 200-250 for each subject. I have 4 subjects which are: 1- Write a descriptive essay about the best holiday you greatly enjoyed in the past. 2- In your opinion what is the most important element of happiness ? 3- In

Description

Description see College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Advanced Epidemiology Course number: PHC 332 CRN: XXXX Assignment title or task: (You can write a question) Using Causal Criteria show that smoking causes lung cancer. Student Name: XXX Student ID: XXX Submission Date: XXX

Description

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Business Ethics and Organization Social Responsibility (MGT 422) Due Date: 01/03//2025 @ 23:59 Course Name: Business Ethics and Organization Social Responsibility Course Code:

Description

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Business Ethics and Organization Social Responsibility (MGT 422) Due Date: 22/03//2025 @ 23:59 Course Name: Business Ethics and Organization Social Responsibility Course Code:

Description

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 3 Business Ethics and Organization Social Responsibility (MGT 422) Due Date: 26/04/2025 @ 23:59 Course Name: Business Ethics and Organization Social Responsibility Course Code:

Description

Description Revise the word file according to the instructor’s comments, and after making the necessary changes, organize it based on the requirements outlined in the attached PDF. 1 Digital Currencies Student’s Name University Course Title Professor’s Name Date 2 Digital Currencies 1. Research Approach The research design of this study

Description

Description The Impact of AI-Driven Workflow Optimization on Employee Satisfaction in Radiology: The Mediating Role of Job Stress Reduction Thesis Submitted in Partial Fulfillment of the Requirements for the Award of the Degree of MASTER OF BUSINESS ADMINISTRATION BY Liyan Abdumohsen Almayouf Under Supervision Dr .Asra inkesar COLLEGE OF ADMINISTRATIVE

Description

Description the document with the required information on PRISMA and JBI. Both should come in the results section. In Methodology, you should mention them, but give the table/figure in the results section. Also, the total number of references is still less. You can try to cite more relevant articles in

Description

Description SEE College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Applied Biostatistics Course number: PHC321 CRN: 22884 Paper Assignment-1 Answer the following questions in a Word document using the provided datasheet (you may use SPSS or MS Excel for your analysis). The datasheet contains national

Description

Description Chapter 1: Description of the company This section should answer the following questions: What is the full title of the company/institution? Give a brief history of the company, full mailing address and relevant weblinks What is the type of ownership of the company/institution? State the main shareholders and their

Description

Description Revise the word file according to the instructor’s comments, and after making the necessary changes, organize it based on the requirements outlined in the attached PDF. Due 8th May 2025 by 11:59 pm. Research Methods and Quantitative Analysis 2nd Semester, 2025 EMBA – Section JA The proposal is worth

Description

Description see ASSIGNMENT COVER SHEET Course name: Health and Environmental Risk Assessment Course number: PHC 351 CRN: Assignment title or task: (You can write a question) Discuss the steps and methods of risk communication and community engagement and support your answer with examples. Student name: xxxx Student ID: xxxx Submission

Description

Description see College of Health Sciences Department of Public Health PAPER ASSIGNMENT Course name: Introduction to Mental Health Course number: PHC-273 Go through the research articles in the link below and answer any one of the following questions in at least 350 words. • • Assignment task Q1. Discuss about