In this project we are going to be working with the database storing the information about venture capital funds and investments in start-up companies. The database is based on Startup Investments dataset published on Kaggle.
The databased is composed of the following seven interlinked tables:
This table contains information about the acquisitions of companies:
| Key | Field | Description |
|---|---|---|
| PK | id |
Unique acquisition number |
| FK | acquiring_company_id |
Identifier of an acquiring company |
| FK | acquired_company_id |
Identifier of an acquired company |
term_code |
Acquisition payment method | |
price_amount |
Acquisition amount (USD) | |
created_at |
Date and time of creating a table entry | |
updated_at |
Date and time of updating a table entry |
acquisitiontable is linked tocompanytable (idfield) viaacquiring_company_idandacquired_company_id.
Some fields have a limited number of categories, for instance:
term_codecash- in cashstock- in company stockcash_and_stock- mixed payment method: cash/stocks
The table stores information about the start-up companies:
| Key | Field | Description |
|---|---|---|
| PK | id |
Company identifier |
name |
Company name | |
category_code |
Company activity category | |
status |
Company status | |
founded_at |
Date of founding a company | |
closed_at |
Date of a company closure (if a company does not exist anymore) | |
domain |
Domain of a company website | |
network_username |
Fund profile in a corporate stock exchange network | |
country_code |
Country code (USA, GBR or others) |
|
investment_rounds |
Number of rounds where a company participated in as an investor | |
funding_rounds |
Number of rounds in which a company was raising funds | |
funding_total |
Amount raised (USD) | |
milestones |
Number of important stages in a company history | |
created_at |
Date and time of creating a table entry | |
updated_at |
Date and time of updating a table entry |
companytable is linked toacquisitions,funding_round,investmentandpeopletables via a Primary Key.
The following fields have a limited number of values:
-
category_codenews- engages in working with newssocial- engages in social work
-
statusacquired- an acquired companyoperating- a functioning companyipo- a company launching an IPOclosed- a closed company
The table contains information about the education of companies employees:
| Key | Field | Description |
|---|---|---|
| PK | id |
Education information identifier |
| FK | person_id |
Identifier of a person |
degree_type |
Degree of a person | |
instituition |
Name of a university | |
graduated_at |
Date of graduation | |
created_at |
Date and time of creating a table entry | |
updated_at |
Date and time of updating a table entry |
educationtable is linked topeopletable (idfield) viaperson_id.
degree_typeBA- Bachelor of ArtsMS- Master of Science
The table stores information about the venture funds:
| Key | Field | Description |
|---|---|---|
| PK | id |
Venture fund identifier |
name |
Venture fund name | |
founded_at |
Date of founding a fund | |
domain |
Domain of a venture fund website | |
network_username |
Fund profile in a corporate stock exchange network | |
country_code |
Country code of a fund | |
investment_rounds |
Number of rounds where a fund participated in as an investor | |
invested_companies |
Number of companies in which a fund made an investment | |
milestones |
Number of important stages in a fund history | |
created_at |
Date and time of creating a table entry | |
updated_at |
Date and time of updating a table entry |
fundtable is linked toinvestmenttable via a Primary Key.
The table includes information about the investment rounds:
| Key | Field | Description |
|---|---|---|
| PK | id |
Investment round identifier |
| FK | company_id |
Unique company identifier |
funded_at |
Date of an investment round | |
funding_round_type |
Investment round type | |
raised_amount |
Investment raised in a particular round (USD) | |
pre_money_valuation |
Preliminary company valuation | |
participants |
Number of people participating in an investment round | |
is_first_round |
Identifier of whether a round is the first for a company | |
is_last_round |
Identifier of whether a round is the last for a company | |
created_at |
Date and time of creating a table entry | |
updated_at |
Date and time of updating a table entry |
funding_roundtable is linked tocompanytable (idfield) viacompany_idand toinvestmentvia a Primary Key.
funding_round_typeventure- venture roundangel- angel roundseries_a- Series A round
The table has information about the investments of venture funds in start-up companies:
| Key | Field | Description |
|---|---|---|
| PK | id |
Unique investment identifier |
| FK | funding_round_id |
Investment round identifier |
| FK | company_id |
Unique company identifier |
| FK | fund_id |
Unique fund identifier |
created_at |
Date and time of creating a table entry | |
updated_at |
Date and time of updating a table entry |
investmenttable is linked tofunding_roundtable (idfield) viafunding_round_id. The table is also linked tocompanytable (idfield) viacompany_idand tofundtable (idfield) viafund_id.
The table stores information about the employees of companies:
| Key | Field | Description |
|---|---|---|
| PK | id |
Unique employee identifier |
first_name |
Employee name | |
last_name |
Employee surname | |
| FK | company_id |
Unique company identifier |
network_username |
Fund profile in a corporate stock exchange network | |
created_at |
Date and time of creating a table entry | |
updated_at |
Date and time of updating a table entry |
peopletable is linked tocompanytable (idfield) viacompany_idand toeducationvia a Primary Key.