السلام عليكم
ارجو المساعدة من اهل الخبرة في حل هدا الواجب
Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints
1- Design a database for a world-wide package delivery company (e.g., DHL or
FedEX). The database must be able to keep track of sales (who ship items) and
customers (who receive items); one customers may do both. Each package must be
identifiable and trackable, so the database must be able to store the location of the
package and its history of locations, namely when is this package arrived somewhere.
Locations include trucks, planes, airports, and warehouses. For each customer, this
company wants to keep the information of their name, gender, and the social security
number
2- Design a database for an airline. The database must keep track of customers and their reservations, flights and their status, seat assignments on individual flights, and the schedule and routing of future flights.