Question

Identify the columns and data types of a table: Airlines. Mention at least four columns with data type. ​

Answer 1

Answer:

Identify the columns and data types of a table: Airlines. Mention at least four columns with data type.

...

1 Answer.

Columns Data type

Arrival Time Date/Time

Departure Time Date/Time

Fares Float

Answer 2

Answer:

There are three basic data types: numeric, alphabetic, and alphanumeric. Numeric Data is made up entirely of numbers.

Explanation:

The nature of the data that can be stored in a database table is represented by data types. For example, if we want to store string data in a specific column of a table, we must declare a string data type for this column. A column's data type determines what values it can store: integer, character, money, date and time, binary, and so on.

• Airlines four columns with data type:

• Columns                     Data type
• Flight No                         Text
• No.of Passengers           Integer
• Airlines                            Text
• Arrival Time                     Date/Time
• Departure Time               Date/Time
• Fares                                Float