Scribd
Upload
11 views3 pages

Immigration and Demographics Data Tables

The document describes the columns for three database tables: an immigration fact table with details on immigration events, an airports dimension table with details on airports, and a cities_dem dimension table with demographic details on cities. It provides the column names and descriptions for each table, including primary keys and foreign keys that link the tables.

Uploaded by

Karin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
11 views3 pages

Immigration and Demographics Data Tables

The document describes the columns for three database tables: an immigration fact table with details on immigration events, an airports dimension table with details on airports, and a cities_dem dimension table with demographic details on cities. It provides the column names and descriptions for each table, including primary keys and foreign keys that link the tables.

Uploaded by

Karin
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

immigration fact table

column_name
cicid
airports_id
cities_dem_id
arrival_date
departure_date
i94port
i94addr
biryear

airports dimension table


column_name
id
airport_name
iso_region
municipality
iata_code

cities_dem dimension table


column_name
id
city
state
state_code
median_age
male_population
female_population
total_population
foreign_born
race
count
origin
immigration dataset column "cicid"
airports dataset column "ident"
created as a serial primary key
immigration dataset column "arrdate"
immigration dataset column "depdate"
immigration dataset column "i94port"
immigration dataset column "i94addr"
immigration dataset column "biryear"

mension table
origin
airports dataset column "ident"
airports dataset column "name"
airports dataset column "iso_region"
airports dataset column "municipality"
airports dataset column "iata_code"

dimension table
origin
generated as serial primary key
cities demographics dataset column "City"
cities demographics dataset column "State"
cities demographics dataset column "State Code"
cities demographics dataset column "Median Age"
cities demographics dataset column "Male Population"
cities demographics dataset column "Female Population"
cities demographics dataset column "Total Population"
cities demographics dataset column "Foreign-born"
cities demographics dataset column "Race"
cities demographics dataset column "Count"
description
primary key for immigration event
foreign key that links to the primary key "id" in the airports table
foreign key that links to the primary key "id" in the cities_dem table
describes the arrival date
describes the departure date
corresponds to the iata_code for airports
describes the state code
describes the birthyear of the traveller

description
primary key of airports table
the full name of the airport
the iso code for the region where the airport is located
the municipality of the airport
the iata code for the airport

description
primary key of the cities_dem table
full city name
full state name
state in state code format
median age for the city
count of the male population, as an integer number
count of the female population, as an integer number
count of the total population, as an integer number
count of the population with a foreign origin
denomination of the race in full letters, for example "Hispanic or Latino"
count of the individuals that can be attributed to the race named in the column "race"

You might also like