How to split a big table into multiple related tables?

Am new to Postgres SQL. I have a big table that can be splitted to multiple table

ID_Student | Name_Student | Departement_Student | is_Student_works | job_title | Work_Departement | Location|
=============================================================================================================
1          | Rolf         | Software Eng        | Yes              | intern SE | data Studio  
| london |
2          | Silvya       | Accounting          | Yes              | Accounter | TORnivo  
| New York |

I want to split it into 3 tables ( student, departement, work) :

STUDENT TABLE

ID_Student | Name_Student | is_Student_works | Location|
========================================================
1          | Rolf         | yes              | london  |
2          | Silvya       | Yes              | New York|

DEPARTEMENT TABLE

ID_DEPARTEMENT | Name_DEPARTEMENT |
===================================
1          | Software Eng         |
2          | Accounting           |

WORK TABLE

ID_WORK | Name_WORK               |
===================================
1          | intern SE            |
2          | Accounter            |

I need Only the Query that Split the table into multiple tables, THE CREATION OF TABLES ARE NOT NEEDED.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum