Database Module

[mohamed-taman]

Create Database design and its implementation and should be n memory database.

• Every user has a first name, last name, username, password, and salt.
• For each city, the name, country, and description must be provided.
• Each city could have a comment added by the user. Besides the comment's description, each comment should have created and modified date.
• Import the data for the airports and routes from the datasets given in an attachment.
  • Note: Each airport contains a city and country name. Don’t import airports and routes if the city doesn’t
    exist.

Route dataset description:

Field	Description
Airline	2-letter (IATA) or 3-letter (ICAO) code of the airline.
Airline ID	Identifier for an airline.
Source airport	3-letter (IATA) or 4-letter (ICAO) code of the source airport.
Source airport ID	An identifier for source airport.
Destination airport	3-letter (IATA) or 4-letter (ICAO) code of the destination
airport.
Destination airport ID	Unique OpenFlights identifier for the destination airport.
Codeshare	"Y" if this flight is a codeshare, empty otherwise.
Stops	Number of stops on this flight ("0" for direct).
Equipment	3-letter codes for plane type(s) generally used on this flight, separated by spaces.
Price	Flight cost.

Airport dataset description:

Field	Description
Airport ID	Identifier for this airport.
Name	Name of the airport.
City	Main city, served by the airport.
Country	Country or territory where the airport is located.
IATA	3-letter IATA code. Null if not assigned/unknown.
ICAO	4-letter ICAO code. Null if not assigned.
Latitude	Decimal degrees, usually to six significant digits.
Longitude	Decimal degrees, usually to six significant digits.
Altitude	In feet.
Timezone	Hours offset from UTC.
DST	Daylight savings time. One of E (Europe), A (US/Canada), S (South America), O (Australia), Z (New Zealand), N (None), or U (Unknown).
Tz database time zone	The timezone in "tz" (Olson) format, e.g. "America/Los_Angeles."
Type	Type of the airport.
Source	Source of this data.