CSCI 326 American University of Ras AlKhaimah database Questions

American University of Ras Al KhaimahFaculty of Engineering
Computer Science and Engineering Department
Course Title:
Database Systems
Course Code:
CSCI 326
Semester:
Fall 2024-2025
Date:
Sep 28, 2024
Homework 1
Instructions:
1. You must do this homework alone.
2. Please hand in ONE copy of the homework listing your full name and the
university ID.
3. The deadline to submit the answers is the 11:59 pm Oct 6th 2024
Question 1: (2.5 marks)
E-Commerce Order Management Database
The e-commerce order management system stores details about products, customers, and
orders. This simplified version models how an online store might manage its core operations.
Consider the following requirements list:
•
•
•
•
•
•
•
The system manages one or more products.
Each product has a unique product ID, a name, a description, a price, and a stock
quantity.
A customer has a unique customer ID, a first name, last name, email address, and
shipping address.
A customer can place multiple orders. Each order has a unique order ID, a date, and a
total amount.
Each order contains one or more products. The system needs to track the quantity of
each product ordered.
A product can be part of multiple orders.
Each product’s stock quantity should be updated after an order is placed to reflect the
new availability.
Task
Draw the entity-relationship model. Describe your modeling choices in detail, including
entities, attributes, relationships, and cardinalities.
Question 2: (2.5 marks)
University Course Management Database
•
•
•
•
•
•
•
•
The database stores details about a university’s courses, instructors, students, and
enrollments. It’s a simplified version of what a real university might use, but it follows
the same core principles.
Consider the following requirements list:
The university offers one or more courses.
A course has a unique course code, a name, and a number of credits.
Each course is taught by one or more instructors. An instructor has a unique instructor
ID, a name, and a department.
A student can enroll in one or more courses. A student has a unique student ID, a name,
and an email address.
Each enrollment links a student to a specific course and records the date of enrollment.
An instructor can teach multiple courses, and a course can have multiple students.
Task
Draw the entity-relationship model. Describe your modeling choices, including entities,
attributes, relationships, and cardinalities.