Assignment: Making a diagram and database
Read carefully the all 3 questions
1. Draw an ER diagram to represent information about airplanes. An airplane has a registration number, type, number of economy class seats, number of business class seats and the year of production.
2. Design a database that will hold information for a small travel agency to conduct its business. The agency exclusively offers trips. Each trip is identified by a number. For each trip, the name, the price per person and duration of the trip (in days) are stored. A trip is offered every week on the same day. A trip on a certain date can be booked by a customer. Each customer gets a unique number, and the database should also store the customer's name, address, phone number and email. A customer can book different trips on different dates.
3. Design a database for a hotel chain. Each hotel has a name, code, address and a category (the number of stars). The total number of beds is known. Each hotel has many rooms, and each room has a number (unique within the hotel). Rooms may be of two types (single or double). Some rooms have TVs. For each employee, his/her employee number should be stored, as well as the name, address, home phone number, job position and salary. Each employee works for just one hotel. An employee manages at most one hotel, but not all employees are managers.