i need answer for question no 2

ISDS 3110: Data and Information Management LAB #3: 1:M Data Modeling Create the ER Diagram and Relational Data Model for the following: 1. Design the database with an ER diagram and a relational data model for Southwest Airlines. Southwest needs a database to support the following facts: An aircraft can fly many different flights, and a passenger can be on only one flight at a time. Furthermore, Southwest needs to track the call sign, make, model, and year of each aircraft. Southwest also needs to track the first name, last name, rewards number, driver's license number, and gender of each passenger. For each flight, the flight number, origin, destination, date, departure time, and arrive time must be recorded. 2. Netflix needs you to design a database application system using an ER diagram and a relational data model. The requirements collection and analysis phase has provided the following requirements for the database: The data stored on the shows they have included the show ID number, title, year of release, lead actor, purchase price, and daily rental rate. The show ID number uniquely identifies each show. The Netflix's shows each fall into one of the following categories: comedy, drama, horror, musical, science fiction, children and adults only. A category can have zero to many shows in it, and a show must belong to one and only one category The catalog number uniquely identifies each of these categories. Data on content providers should also be stored, such as provider number, name, street, city, state, zip code, and telephone number. The content provider is the company who sold the content rights of a show to Netflix A content provider can provide zero or more shows to Netflix, but a certain show can only be purchased from one content provider (who owns the rights). Submit your ER Diagrams and Relational Data Models in a SINGLE (MS Word) DOCUMENT to Moodle. Name your submission as "LAB3_Firstname_Lastname