Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

Project Fundamental of Database IT-403

Description

  • 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.
  • Project Instructions

    • You can work on this project as a group (minimum 3 and maximum 4 students). Only the group leader must submit the project with all group member names.
    • This project worth 14 marks and will be distributed as in the following:
      • Identify the entity types, attributes, keys. (2 marks)
      • Identify relationships and cardinalities. (2 marks)
      • Draw the ERD. (2 marks)
      • Schemas before Normalization. (1.5 marks)
      • Schemas after Normalization. (1.5 marks)
      • Create the tables. (1.5 marks)
      • Populate your tables with at least 5 rows. (1.5 marks)
      • Execute the requested sample queries. (2 marks)
    • Each group must submit one report about their chosen project via the Blackboard (Email submission will not be accepted which will be awarded ZERO marks)
    • Screenshots for answering SQL questions (f, g, and h).
    • You are advised to make your work clear and well presented; marks may be reduced for poor presentation. This includes filling your information on the cover page.
    • 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 marks being awarded.
    • The work should be your own, copying from students or other resources will result in ZERO marks.

    E-Commerce Inventory and Order Management System

    Background: An emerging online retail company specializing in artisanal products wants to develop a database system to manage its inventory, customer orders, and shipping operations. The system should facilitate real-time inventory updates, order processing, and customer management to enhance operational efficiency and customer satisfaction.Project Objective: Design and implement a database system for the e-commerce platform that supports inventory tracking, order processing, and customer relationship management. The system should be scalable, reliable, and secure, ensuring smooth operations as the business grows.Requirements:

    • Data Storage:
      • Product information: Includes product ID, name, description, price, and stock level.
      • Customer information: Includes customer ID, name, contact details, and order history.
      • Orders: Details about customer orders, including order ID, product(s) ordered, quantities, prices, and status.
      • Shipping: Information on shipping logistics, such as tracking numbers, shipping status, and delivery dates.
    • Project Deliverables:
      • An Entity-Relationship (ER) diagram representing the database structure.
      • A fully normalized database schema.
      • Implementation of the database in a suitable DBMS.

    By implementing a robust database system for the E-Commerce Inventory and Order, the management can efficiently handle the operations from managing product inventory to processing customer orders and handling shipping logistics.

    E-Commerce Inventory and Order Management System

    • Fill the table below with all the Entities based on the given requirements:
    • Fill the table below with all the relationship types based on the given requirements.
    • Draw the ER Diagram
    • Schemas before the normalization
    • Schemas after the normalization
    • Create the normalized tables, write the necessary SQL statements to create the tables.
    • Insert at least five rows into each table.
    • Write SQL queries to find the following:
    Entity Type Attributes of the Entity Key

    Relationship Type Entity types participating in the relationship type. Cardinality Relationship attribute(if any)

    • List all products currently out of stock to check for products that need restocking, helping manage inventory efficiently.
    • Find total sales per product to help analyze which products are generating the most revenue, aiding in strategic business decisions.
    • Identify orders that are delayed to proactively address delays and communicate with affected customers.
    • List Customers who have placed more than three orders to identify top customers, which can be targeted for special offers or loyalty programs.
    • Calculate Inventory Value to provide the total value of all items currently in stock, this is crucial for financial reporting and inventory management.
    • Show Detailed Information for all orders placed today to provide a snapshot of the day’s business activities.

College of Computing and Informatics

Project
Deadline: Tuesday 04/22/2025@ 23:59
[Total Mark for this Project is 14]
Student Details:
Name:
Name:
Name:
Name:

ID:
ID:
ID:
ID:

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.
Restricted – ‫مقيد‬

Project Instructions
• You can work on this project as a group (minimum 3 and maximum 4 students).
Only the group leader must submit the project with all group member names.

• This project worth 14 marks and will be distributed as in the following:
a) Identify the entity types, attributes, keys.
b) Identify relationships and cardinalities.
c) Draw the ERD.
d) Schemas before Normalization.
e) Schemas after Normalization.
f) Create the tables.
g) Populate your tables with at least 5 rows.
h) Execute the requested sample queries.

(2 marks)
(2 marks)
(2 marks)
(1.5 marks)
(1.5 marks)
(1.5 marks)
(1.5 marks)
(2 marks)

• Each group must submit one report about their chosen project via the Blackboard
(Email submission will not be accepted which will be awarded ZERO marks)

• Screenshots for answering SQL questions (f, g, and h).
• You are advised to make your work clear and well presented; marks may be reduced
for poor presentation. This includes filling your information on the cover page.

• You MUST show all your work, and text must not be converted into an image, unless
specified otherwise by the question.
A) Late submission will result in ZERO marks being awarded.
B) The work should be your own, copying from students or other resources will
result in ZERO marks.

Restricted – ‫مقيد‬

Learning
Outcome(s):

LO 4

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

LO 3

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

E-Commerce Inventory and Order Management System
Background: An emerging online retail company specializing in artisanal products
wants to develop a database system to manage its inventory, customer orders, and
shipping operations. The system should facilitate real-time inventory updates, order
processing, and customer management to enhance operational efficiency and customer
satisfaction.
Project Objective: Design and implement a database system for the e-commerce
platform that supports inventory tracking, order processing, and customer relationship
management. The system should be scalable, reliable, and secure, ensuring smooth
operations as the business grows.
Requirements:
1. Data Storage:
o Product information: Includes product ID, name, description, price, and
stock level.
o Customer information: Includes customer ID, name, contact details, and
order history.
o Orders: Details about customer orders, including order ID, product(s)
ordered, quantities, prices, and status.
o Shipping: Information on shipping logistics, such as tracking numbers,
shipping status, and delivery dates.

2. Project Deliverables:
o An Entity-Relationship (ER) diagram representing the database structure.
o A fully normalized database schema.
o Implementation of the database in a suitable DBMS.

By implementing a robust database system for the E-Commerce Inventory and Order,
the management can efficiently handle the operations from managing product inventory
to processing customer orders and handling shipping logistics.

Restricted – ‫مقيد‬

E-Commerce Inventory and Order Management System
a) Fill the table below with all the Entities based on the given requirements:

Entity Type

Restricted – ‫مقيد‬

Attributes of the Entity

Key

b) Fill the table below with all the relationship types based on the given requirements.

Relationship
Type

Entity types
participating in
the relationship
type.

c) Draw the ER Diagram
d) Schemas before the normalization

Restricted – ‫مقيد‬

Relationship attribute
Cardinality

(if any)

e) Schemas after the normalization
f) Create the normalized tables, write the necessary SQL statements to create the
tables.
g) Insert at least five rows into each table.
h) Write SQL queries to find the following:
1. List all products currently out of stock to check for products that need
restocking, helping manage inventory efficiently.
2. Find total sales per product to help analyze which products are generating
the most revenue, aiding in strategic business decisions.
3. Identify orders that are delayed to proactively address delays and
communicate with affected customers.
4. List Customers who have placed more than three orders to identify top
customers, which can be targeted for special offers or loyalty programs.
5. Calculate Inventory Value to provide the total value of all items currently
in stock, this is crucial for financial reporting and inventory management.
6. Show Detailed Information for all orders placed today to provide a
snapshot of the day’s business activities.

Restricted – ‫مقيد‬

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

Management Question

Description Hi, please find the attached assignment two. Please do as per the cover page instructions. As of the assignment two is complete to assignment one. You will find assignment one attached for your reference. ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education

Management Question

Description Hi please find the attached knowledge management assignment two. Do as requested on the cover page. ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Knowledge Management (MGT 403) Due Date: 22/03/2025

Management Question

Description Hey please find attached quality management assignment two. Do as requested on cover page instructions. ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Quality Management (MGT 424) Due Date: 22/03/2025 @

Management Question

Description I don’t want a solution copied from another student’s paper. ‫كلية العلوم الادارية والمالية‬ | Saudi Electronic University College of Administrative and Financial Sciences E-Commerce Department Assignment-2 Student Name: Student ID: Course Title: E-Supply Chain Management Course Code: ECOM402 Academic Year/ Semester: 2nd 2024/2025 CRN: Instructor Name: Student Grade:

Internship Presentation Acct430

Description Presentation College of Administration and Finance Sciences Internship Report: Saudi Aramco Student`s name: MUNAHI TURKI ALROQE Student`s ID #: 170063504 Training Organization: Trainee Department: SAUDI ARAMCO Accounting Field Instructor Name: Field Instructor Signature: SAMI MANSOUR ALOTAIBI Course Title: ACCT-430 CRN: Internship Start Date: Internship End Date: 1/9/2024 1/3/2025 Academic

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented; marks may be reduced for poor presentation. This includes filling your information on the cover page. Students

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page. Students

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via the allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well-presented; marks may be reduced for poor presentation. This includes filling in your information on the cover page.

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling in your information on the cover page.

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page. Students

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page. Students

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page. Students

Management Question

Description The Assignment must be submitted on Blackboard (WORD format only) via allocated folder. Assignments submitted through email will not be accepted. Students are advised to make their work clear and well presented; marks may be reduced for poor presentation. This includes filling your information on the cover page. Students

Management Question

Description ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Organization Design and Development (MGT 404) Due Date: 22/03/2025 @ 23:59 Course Name: Student’s Name: Course Code: MGT404 Student’s ID Number: Semester: Second

Management Question

Description NO COPING 🙏 ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Strategic Management (MGT 401) Due Date: 22/03/2025 @ 23:59 Course Name: Strategic Management Student’s Name: Course Code: MGT 401 Student’s

Management Question

Description NOCOPING 🙏 ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Human Resources Management (MGT 211) Due Date: 22/03/2025 @ 23:59 Course Name: HR Management Student’s Name: Course Code: MGT211 Student’s ID

Management Question

Description NO COPING 🙏 ‫المملكة العربية السعودية‬ ‫وزارة التعليم‬ ‫الجامعة السعودية اإللكترونية‬ Kingdom of Saudi Arabia Ministry of Education Saudi Electronic University College of Administrative and Financial Sciences Assignment 2 Human Resources Management (MGT 211) Due Date: 22/03/2025 @ 23:59 Course Name: HR Management Student’s Name: Course Code: MGT211 Student’s