PostgreSQL

Given the following normalized Employee database with two tables (Employee and Employee Department), create database tables and load them appropriately, then write a User Defined Function (UDF) with a join statement that displays Employee Name and Department Number. Call your UDF using the data in the database below. You will first need to construct and load the database tables.

Employee Table Emp Num Emp LNameDept Num 1 OO654 100375 100164 Davis Miller Smits A55 A55 H64 D35 Violation: Mulitple Cell Values Employee Table Employee Department Table Emp_ Num* Emp LName 00654 100375 100164 Emp_Num* Davis Miller Smits 100654 100375 00375 Dept Num A55 A55 H64 D35 100164 *Denotes Primary/Foreign Key