“An airliner can be assigned to fly many flights, but each flight is flown by only one airliner.” a.) Model this statement using the crow’s foot modelling technique.  [5 marks] Create your diagram in draw.io (or equivalent), save it as either a JPG or PNG file format, and upload your image using the "Files" area below. b.) Write the SQL code to create the Tables from the entities you modelled in the previous part.

Task 1:Create a database Entity and Relationship Diagram (ERD) for the following application:Please include answer with detailed explanationKhair Application: The Application idea: It is a mobile application called (Khair) to help people. This assistance is moral, material. This assistance is also provided by good people in our community.   Example to understand the Application idea more: For example, a person urgently needs a medical chair or bed and does not have the ability to purchase what he needs. The medical chair or bed is requested through the application, and whoever has what he requests initiates the request through the application’s messages and determines the meeting place. Application models (page): Login included: login registration login included: user name password New registration included: name E-mail Password phone number date National Identification Number Home page included: Request - applicant name - address - send message Messages list form included: list of…

I NEED HELP WITH THIS QUESTION FOR MY DATABASE MANAGEMENT CLASS FOR SQL DEVELOPER 5. Now compute Average GPA in each class. Display class_code, Class_GPA. Assume all courses are 3 credit courses. A general formula for GPA would be sum(gradepoints x Hrs)/sum(Hrs). Here you can just take an average of gradepoints as the credit hours are same for all courses.

Consider the scenario described by the following statement: “Kangaroos, wombats and koalas are all kinds of marsupials.” a.) Model this statement using the crow’s foot modelling technique.  Create your diagram in draw.io (or equivalent), save it as either a JPG or PNG file format, and upload your image using the "Files" area below. b.) Write the SQL code to create the Tables from the entities you modelled in the previous part.   Write your code in the text area (above the "Files" area).