This Is The Home Workabout Making A Diagram And Databaseplease Read C This is The home work about : Making a diagram and database please 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.
Paper For Above instruction The provided homework involves creating diagrams and databases encompassing three different scenarios: airplanes, a travel agency, and a hotel chain. Each scenario requires careful analysis to design Entity-Relationship (ER) diagrams or relational database structures to effectively manage and represent the relevant data entities and their relationships. ER Diagram for Airplanes The first task is to draw an ER diagram representing information about airplanes. The key attributes of the airplane entity include registration number, type, number of economy class seats, number of business class seats, and year of production. The registration number uniquely identifies each airplane and serves as the primary key. The type attribute categorizes airplanes (e.g., Boeing 737, Airbus A320). The seats information specifies capacity in each class, which helps in booking and operational planning. The ER diagram can include an 'Airplane' entity with the aforementioned attributes. Depending on the scope, additional relationships may be added if airplanes are linked to flights or maintenance records, but based solely on the prompt, the diagram primarily shows the 'Airplane' entity with its attributes.