Homework SourseHW 3 1 Create 2 tables Table 1 Employee EmpID Name JobCode P
HW #3 1. Create 2 tables: Table 1: Employee (Emp_ID, Name, Job_Code) Primary key is Emp_ID Table 2: Job (Job_Code, Job_Function) Primary Key is Job_Code 2. Identify which table has foreign key 3. Use Relationship screen to create relationshiop between table 1 and 2 4. enter data on both tables 5. Create a query called \"Employee with job_Function\" Display only Name and Job_Function
Solution
1. Employee Table :-
CREATE TABLE Employee ( Emp_ID int PRIMARY KEY, Name varchar(10), Job_Code int ) ;
* Job Table :-
CREATE TABLE Job ( Job_Code int PRIMARY KEY, Job_Function varchar(10) ) ;
2. Job Table has the foreign key as Job_Code.
