Description
College of Computing and Informatics
Assignment 1
Deadline: Day 02/10/2024 @ 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):
CLO 1 Explain the
concepts and
architectures
involved in the
database
development.
Restricted – مقيد
Question One
2 Marks
Using your own world, differentiate between database schema and database
state with examples.
Question Two
Pg. 02
Learning
Outcome(s):
CLO3
Create EntityRelationship
model, Relational
Question Two
2 Marks
The advent of online shopping has revolutionized the traditional shopping experience, offering
convenience to consumers worldwide. However, have you ever pondered the intricate
processes that unfold once you confirm your purchase? Beyond the seamless transaction lies
a sophisticated infrastructure comprising databases, servers, and applications working in
unison.
Provide the relational database schema for an online shopping system where customers place
model, and write
orders. An order may consist of multiple products, with products categorized for easy
SQL queries
organization and search. The Customer table identifies the customers placing orders with their
personal information, while the Category table specifies the product categories and
description. The Product table lists the available items for purchase and their prices, each
linked to a category through the Category ID. Orders, recorded in the Order table with date of
order and the total amount, and they are associated with customers through the Customer ID.
The Order Detail table captures the intricate relationship between orders and products,
detailing the products included in an order along with their respective quantities.
Restricted – مقيد
Question Three
Pg. 03
Learning
Outcome(s):
CLO3: Create
EntityRelationship
model, Relational
model, and write
SQL queries.
Restricted – مقيد
Question Three
2 Marks
Compare and contrast the effects of specialization and generalization on the hierarchy
of Enhanced Entity-Relationship (EER) diagrams. Give examples to illustrate how
generalization and specialization differ.
Question Four
Pg. 04
Learning
Outcome(s):
CLO 3
Instructors:
Create EntityRelationship
model, Relational
model, and write
SQL queries
Restricted – مقيد
Question Four
2 Marks
Draw an ER diagram for the following SPL Saudi Post system.
SPL application relies on a company-wide information system. In SPL Saudi Post
system, shipped items are the main component of the SPL product tracking
information system. Shipped items can be characterized by item number (unique),
weight, dimensions, insurance amount, destination, and final delivery date. Shipped
items are received into the SPL system at a single retail center. Retail centers are
characterized by their type, unique ID, and address. Shipped items make their way to
their destination via one or more standard SPL transportation events (flights, truck
deliveries). These transportation events are characterized by a unique schedule
Number, a type (flight, truck), and a delivery Route.
Assignment 1
Deadline: Day 02/10/2024 @ 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):
CLO 1 Explain the
concepts and
architectures
involved in the
database
development.
Restricted – مقيد
Question One
2 Marks
Using your own world, differentiate between database schema and database
state with examples.
Question Two
Pg. 02
Learning
Outcome(s):
CLO3
Create EntityRelationship
model, Relational
Question Two
2 Marks
The advent of online shopping has revolutionized the traditional shopping experience, offering
convenience to consumers worldwide. However, have you ever pondered the intricate
processes that unfold once you confirm your purchase? Beyond the seamless transaction lies
a sophisticated infrastructure comprising databases, servers, and applications working in
unison.
Provide the relational database schema for an online shopping system where customers place
model, and write
orders. An order may consist of multiple products, with products categorized for easy
SQL queries
organization and search. The Customer table identifies the customers placing orders with their
personal information, while the Category table specifies the product categories and
description. The Product table lists the available items for purchase and their prices, each
linked to a category through the Category ID. Orders, recorded in the Order table with date of
order and the total amount, and they are associated with customers through the Customer ID.
The Order Detail table captures the intricate relationship between orders and products,
detailing the products included in an order along with their respective quantities.
Restricted – مقيد
Question Three
Pg. 03
Learning
Outcome(s):
CLO3: Create
EntityRelationship
model, Relational
model, and write
SQL queries.
Restricted – مقيد
Question Three
2 Marks
Compare and contrast the effects of specialization and generalization on the hierarchy
of Enhanced Entity-Relationship (EER) diagrams. Give examples to illustrate how
generalization and specialization differ.
Question Four
Pg. 04
Learning
Outcome(s):
CLO 3
Instructors:
Create EntityRelationship
model, Relational
model, and write
SQL queries
Restricted – مقيد
Question Four
2 Marks
Draw an ER diagram for the following SPL Saudi Post system.
SPL application relies on a company-wide information system. In SPL Saudi Post
system, shipped items are the main component of the SPL product tracking
information system. Shipped items can be characterized by item number (unique),
weight, dimensions, insurance amount, destination, and final delivery date. Shipped
items are received into the SPL system at a single retail center. Retail centers are
characterized by their type, unique ID, and address. Shipped items make their way to
their destination via one or more standard SPL transportation events (flights, truck
deliveries). These transportation events are characterized by a unique schedule
Number, a type (flight, truck), and a delivery Route.
Purchase answer to see full
attachment
