AV intel definitions

Question 1

First Normal Form

Answer 1

• Eliminate duplicative columns

- Create separate tables for data and identify with Primary Key

Question 2

Normalisation

Answer 2

• Process of efficiently organizing data in a data base.
• Eliminate redundant Data
• useful data dependencies

Question 3

Second normal form

Answer 3

• Meet all the requirements of the first normal form.
• Remove subsets and place in separate
  tables.
• Create relationships between these new tables using
  foreign keys.
  -All non primary key fields are dependent on primary key

Question 4

Third Normal form

Answer 4

• Meet all the requirements of the second normal form.

- Remove columns that are not dependent upon the primary key.

Question 5

Designing a Database

Answer 5

• Using a DBMS (database management system) (e.g. SQL)  Determine purpose of database
• Determine size
• Identify primary key
• Determine relationship between tables
• Refine

Question 6

Information Systems

Answer 6

Signals -> Data -> Information

Question 7

clustering

Answer 7

Use specific intervals, to cluster those headings which refer to the intervals. Easily visualize the pattern to which direction flights depart.

Question 8

Importance of AI/BI

Answer 8

• Help a business understand its commercial context
• Convert raw data into useful data which can be interpreted
• create forecasts
• use data to make management decisions

Question 9

Aviation Intel consist of_

Answer 9

Data/Information gathering,processing, management and storing

Question 10

Syntactic level

Answer 10

Any form of signal

Question 11

Semantic level

Answer 11

Turning the signal into Data

Question 12

Pragmatic level

Answer 12

Turns the data into something we can work with

Question 13

Primary Key

Answer 13

The one thing we keep the same in our data (ID number, project code )

Question 14

Inner join

Answer 14

Data present in both sets is merged

Question 15

Left and Right outer joins

Answer 15

All data from one set as well as the data both have in common

Question 16

Full Join

Answer 16

All data is merged

Question 17

proc sql format

Answer 17

create table (name) as
select
(data set) 
  ,(variables)
  ,(variables) 
 from (name)
group by (variable , variable)
order by (variable , variable)
;
quit;

Question 18

DBMS

Answer 18

a program that lets one or more computer users create and access data in a database

Question 19

Required features of a DBMS

Answer 19

• Userfriendly
• Adhere to standards ( SQL )
• Multi User Operation
• Provide security features

Question 20

Information Management

Answer 20

How an organization plans, collects,organizes, uses and disposes of its information which ensures that the information value is identified and exploited.