SEU IT244 & IT241

College of Computing and InformaticsAssignment 1
Deadline: Sunday 09/04/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 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.
Question One
Pg. 01
Learning
Outcome(s):
Explain the
concepts and
architectures
involved in the
database
development.
Question One
2 Marks
Use your own words to discuss the following:
“Using spreadsheets or typical computer-based filing systems looks a reasonable choice
for organizing personal data. However, it is not sufficient to use such systems when the
amount of data becomes huge. In such case, it may be time to implement a database.”
Answer:
Question Two
Pg. 02
Learning
Outcome(s):
Explain the
concepts and
architectures
involved in the
database
development.
Question Two
2 Marks
Define five mini-world Entities and five Relationships for a hospital database
system.
Answer:
Question Three
Pg. 03
Learning
Outcome(s):
Create EntityRelationship
model, Relational
model, and write
SQL queries.
Question Three
2 Marks
Draw an ER diagram for the following car sharing system:
In the car sharing system, a CarMatch application has record of anyone who would like
to share his/her car, known as a CarSharer. An Administrator registers all the potential
CarSharers and with their first name, last name, home address, and date of birth. Each
CarSharer is also assigned a unique id. A CarSharer can take policies issued by the
Insurance Company. Each policy has a number, premium, and a start date. A CarSharer
needs to know the start and destination address of each Journey.
Answer:
Question Four
Pg. 04
Learning
Outcome(s):
Question Four
2 Marks
Consider the following ER Diagram and fill the table by identifying the ER constructs in the
Create Entity-
diagram.
Relationship
model, Relational
model, and write
SQL queries.
Answer:
Constructs
Strong Entities
Weak Entities
Relationships
Key Attributes
Names
College of Computing and Informatics
Assignment 1
Deadline: Tuesday 11/04/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 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.
Question One
Pg. 01
Learning
Outcome(s):
Describe the OS
mechanism for
process
management,
threads, memory,
storage
management, I/O,
file and
concurrency
management.
Question One
2 Marks
What is the difference between multiprogramming and multicore, and how do
they relate to each other?
Question Two
Pg. 02
Learning
Outcome(s):
Recognize the
services and
system calls of
modern operating
systems
Question Two
2 Marks
Discuss basic advantages and disadvantages of using message passing as a
mechanism for Inter-Process Communication (IPC) in modern operating
systems?
Question Three
Pg. 03
Learning
Outcome(s):
Describe the OS
mechanism for
process
management,
threads, memory,
storage
management, I/O,
file and
concurrency
management.
Question Three
2 Marks
Each process is represented in the operating system by a process control
block (PCB). What pieces of information does it contain? Why is it important?
Question Four
Pg. 04
Learning
Outcome(s):
Describe the OS
mechanism for
process
management,
threads, memory,
storage
management, I/O,
file and
concurrency
management.
Question Four
2 Marks
Consider the following processes P1, P2, P3, and P4 arriving in different orders and
having CPU burst times in milliseconds as shown in the table below. Show how these
processes are scheduled according to Shortest-remaining-time-first scheduling
algorithm. Calculate the waiting time for each process and average waiting time.
Process
Arrival time
Burst Time
P1
0
8
P2
2
3
P3
6
2
P4
9
10