JavaScript Example:

CREATE DATABASE IF NOT EXISTS companyDB;
                USE companyDB;
                
                -- Employee table
                CREATE TABLE employee (
                  emp_id INT AUTO_INCREMENT PRIMARY KEY,
                  name VARCHAR(100),
                  age INT,
                  department VARCHAR(50),
                  salary DECIMAL(10,2)
                );
                
                -- Student table (e.g., dependents or interns)
                CREATE TABLE student (
                  student_id INT AUTO_INCREMENT PRIMARY KEY,
                  name VARCHAR(100),
                  age INT,
                  course VARCHAR(100),
                  emp_id INT,  -- Foreign key to employee
                  FOREIGN KEY (emp_id) REFERENCES employee(emp_id)
                );
                
                INSERT INTO employee (name, age, department, salary)
                VALUES
                ('Alice', 30, 'IT', 70000),
                ('Bob', 25, 'HR', 50000);
                
                INSERT INTO student (name, age, course, emp_id)
                VALUES
                ('Charlie', 20, 'Computer Science', 1),
                ('David', 22, 'HR Management', 2);
                
                SELECT * FROM employee;
                SELECT * FROM student;