Databases Design a dalabase for becking flights. Below are you need to follow. L. Tafocasthon abet all Cliphts This informalion should inclusle ID, flightninSer, place of departure, place of arrival , date and time. the requicoments 2. Joformation about the should include of ID, name, address date of birh email, freguent fyer card mumber and telephone number. the ID S naturally unigue (the for other IDs, perhaps auto increment might be useful?) 5. Infor mation about the booking. This information should inelude an DO, dane tickef number, date of purchase price at purchase and slatus of the payment. Keep in mind that a child cannof travel aldne, i.e. one plane ticleet number can 4. Ioformation about the flight crcw. this information should include ID, name, telephone umber, tile, certificate number and role on Please talce info account , thet yarious types ef crew members can be assigned to the flight. 5. Tor cach flighrt, a plane must be allocaled and a bacle-up airplane nerds to be decided on. This in formation should include JD, regtsfration number of the plane, name and numbers ef passengers allowed on boarol. person flying. This information goes same apply for both children and parents n this specific fight. of the airplane, make-year cntily-relstionship Based on the above, draw an aliagram with Khe, entefies, relstionships ,attribules, cardinalitres and leays. show mandatory participdtion double lines aftod remember to olecise it is tit, using 1:M(M slands for many) plationchip. for or MiH Meo , romember tHhet 14 Some things. H Mso , remember that it Cmight be gooo to use IsA Then create the corresponding tables in Excel. Oin actual and Keep in mind that you're not building database ( then would not mix the crew you so fthis reguirement might be ladeing some information that we would otherwise store, if this was a real case -but this is flyers) merely ficfional