السلام عليكم
اريد المساعدة يااخوان في هذا السؤال
Travel Agency Database
A specialist travel company wishes to computerize its operations. Each staff member services enquiries by many customers with customers possibly making an inquiry of different staff members at different times. Details of customer servicing are recorded even if booking does not result. An individual staff member may create a number of bookings with an individual booking being created by one staff member. Each customer who decides on a holiday makes a booking, with each booking being made by only one customer. The booking is associated with only one holiday type, and
more than one booking may be associated with each holiday type. (i.e. a booking is created by a staff member for a customer to go on a holiday type). Each holiday type has a single destination, with each destination having only one holiday type, except for an occasional destination for which no holiday type is offered during a particular year. Staff details held include staff number, name, salary and grade. Customer details recorded include customer number, name, address, phone number, date of inquiry and inquiry type. Booking details include booking number and booking date. Holiday type details include holiday code, description, hotel name and duration. Destination details include destination name, country, continent and inoculation code.
1. Draw an ER model for the database , showing all entity types and their
primary keys , relationship details including cardinality ratios and
participation.
2. Use the mapping rules to create a suitable relational schema for the database.
التصميم يكون على وورد 2007
ولكم خالص الشكر والتقدير