Create a Database Called "ABC"

Create a Database Called "ABC"

Then Create 3 Table. 

1. Department 2. Employee 3. Managers

Create Table Called Department

Dept_Id Text (6) - PK

Dept_Name --> Lookup Wizard --> 

Department Names

1. Account  2. Finance  3. Marketing  4. Sales  5. IT  6. HR 

Location --> Lookup Wizard --> 

Dubai / Berlin / Frankfurt / Manama / Colombo / Mumbai / London / New York

After Create Table Please Enter Data into the Table

Create Table Called Employee

Emp_ID Text (6) - PK

First_Name Text (30)

Last_Name Text (30)

Gender --> Lookup Wizard  --> Male / Female

Job --> Lookup Wizard -- > 

Network Administrator / Oracle DBA / Web Designer / Hardware Engineer / IT Professional

Hire_Date Date/Time

Salary Currency / Number

Dept_Id Text(6) - FK

Manager_Id Text(6) - FK

After Create Table Please Enter Data into the Table

Create Table Called Managers

Manager_Id Text(6) --PK

Manager_Name  Text(3)

Dept_Id Text (6) - FK

After Create Table Please Enter Data into the Table

Useful Queries Find the Employee Who's Gender is Male 

Useful Queries Find the Employee Who's are getting Greater than 30,000 Salary.

Main 3 Tables Relationship