Description

Description

I want to stress some very important instructions to you

First, plagiarism must be zero, any percentage will cause the teacher to cancel my homework

You must focus on the solution and put the requirements correctly and without any error, a correct and complete solution to all questions

References must be placed and placed in style APA.

Put the solution inside the file

There is no possibility of error, you must make sure of the solution well

If you are sure that you will solve it correctly, accept the work

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 HCM101-PAPER ASSIGNMENT Course name: Healthcare Management Course number: HCM101 CRN The textbook (Buchbinder & Shanks (2012), second edition, chapter 5) addresses an essential topic in health care, which is strategic planning. SWOT analysis is a significant tool that healthcare leaders

Description

Description Consumer Behavior Case Study: Nike and Maslow’s Hierarchy of Needs Introduction Nike is a global leader in athletic apparel and footwear. Its success can be partly explained by how it meets different levels of consumer needs based on Maslow’s Hierarchy of Needs, which include: 1.Physiological, 2.Safety, 3.Social, 4.Esteem, and

Description

Description Dis. one file. Discuss in detail the process that a researcher hypothetically would go through when they become aware of a population health problem that arises during the Hajj. What research would be needed to protect the population of the Kingdom? reply. Hi Sarah, Great discussion! I agree that

Description

Description The organizational behavior aspects (motivation – attuited – personality – emotion ..etc. ) helps the manger to understand their employees in the work environment In two essays answer the following questions: 1.How those aspects will be effect in the work performance and employee satisfaction? (5 grades) 2.What are some

Description

Description see College of Computing and Informatics Assignment 2 Deadline: Sunday 13/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

Description

Description I need help completing a discussion board post for my Management course (Managing Perform. for Results). Below are the exact requirements provided by my instructor: Description: In this module, you will examine how pay and reward structures support and facilitate performance management. You will also compare traditional and contingent

Description

Description Module 14: Discussion ForumModule 14: Dis one One file. Discussion Forum Think about a change you know of in a healthcare organization in Saudi Arabia. How was the change received and what was the outcome? What were the resistance points? Provide and discuss suggestions to deal with resistance to

Description

Description Academic Report Guideline(Co-op) (please do not include this text in the final report, just follow its guidelines and use the cover page above) The report should be submitted within two weeks after you finish your Co-op training Program. In addition, the report should be approximately 3000 – 4000, single

Description

Description hi the work you have done is great i need the PPT too Course Name: Student’s Name: Course Code: Student’s ID Number: Semester: CRN: 25492 Academic Year: 144 /144 H For Instructor’s Use only Instructor’s Name: Dr. Faisal Alhathal Students’ Grade: Level of Marks: Secondary address separator Secondary address

Description

Description Release Date: Sunday, February 16, 2025 Due Date: Sunday, March 16, 2025 (11:59 pm) Instructions for submission: Assignment must be submitted with properly filled cover sheet (Name, ID, CRN, Submission date) in word document, Pdf is not accepted. Word count between 500 to 600 Text size 12-Times New Roman

Description

Description Academic Report Guideline(Co-op) (please do not include this text in the final report, just follow its guidelines and use the cover page above) The report should be submitted within two weeks after you finish your Co-op training Program. In addition, the report should be approximately 3000 – 4000, single

Description

Description All fils hear are my reports weekly I want final report in Hadeed Company.. ACKNOWLEDGMENTS In this section, take the opportunity to thank the company in which you conducted your training and thank all the individuals who helped and supervised you during the training program. (Student Name)ii REPORT SUBMISSION

Description

Description Guidelines: Cover sheet should be attached with assignment Use the excel sheet for your calculations to answer the assignment questions Complete student’s information on the first page of the document. Font should be 12 Times New Roman Line spacing should be 1.5 The text color should be “Black” Maximum

Description

Description topic is Informatics for maternal and child health

Description

Description Classification: Internal Use Course Name: Student’s Name: Course Code: Student’s ID Number: Semester: CRN: Academic Year: 144 /144 H For Instructor’s Use only Instructor’s Name: Students’ Grade: Level of Marks: Classification: Internal Use Secondary address separator Classification: Internal Use Classification: Internal Use Secondary address Classification: Internal Use Text Text

Description

Description Please follow the instructions and do not copy from Ai. ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 1 Decision Making and Problem Solving (MGT 312) Due Date: End of week 6,

Description

Description see College of Health Sciences Department of Public Health ASSIGNMENT COVER SHEET Course name: Healthcare Research Methods Course number: PHC215 CRN Q1: Select a topic on any health-related condition of your interest and prepare research proposal under following points Assignment title or task: 1. Title of project – max.

Description

Description All information at ppt. I need like content, like objective, and, comparing, and the best, the best clinic, and the number, quarters, years of the King Salman Medical City. Virtual Clinics Annual Report In King salman medical city Executive Summary 2023 2024 2024 Q 1 2025 Q 1 Purchase