create table employee_master
(
emp_id uniqueidentifier primary key,
emp_name nvarchar(50)
);
create table project_master
(
project_id uniqueidentifier primary key,
project_emp_id uniqueidentifier not null,
project_name varchar(200) not null,
budget decimal,
foreign key(project_emp_id) references employee_master(emp_id)
);