mysql> create database ouda;
Query OK, 1 row affected (0,18 sec)

mysql> use ouda;
Database changed
mysql> create table student(
    -> student_id INT AUTO_INCREMENT PRIMARY KEY,
    -> name VARCHAR(255) NOT NULL,
    -> mail_address VARCHAR(255) NOT NULL,
    -> gender ENUM('M','F')
    -> );
Query OK, 0 rows affected (0,04 sec)

mysql> CREATE TABLE languages_level(
    -> student_id INT,
    -> language_name VARCHAR(50),
    -> level ENUM('basic', 'intermediate', 'advanced', 'native'));
Query OK, 0 rows affected (0,03 sec)

mysql> INSERT INTO student (name, mail_address, gender) VALUES ('ouda', 'ouda@ouda.com', 'M');
Query OK, 1 row affected (0,03 sec)

mysql> select * from student where name='ouda';
+------------+------+---------------+--------+
| student_id | name | mail_address  | gender |
+------------+------+---------------+--------+
|          1 | ouda | ouda@ouda.com | M      |
+------------+------+---------------+--------+
1 row in set (0,01 sec)

mysql> INSERT INTO languages_level values (1, 'english', 'advanced');
Query OK, 1 row affected (0,00 sec)

mysql> INSERT INTO languages_level values (1, 'arabic', 'native');
Query OK, 1 row affected (0,00 sec)


mysql> SELECT student.name, languages_level.language_name , languages_level.level from languages_level RIGHT JOIN student on languages_level.student_id = student.student_id;
+------+---------------+----------+
| name | language_name | level    |
+------+---------------+----------+
| ouda | arabic        | native   |
| ouda | english       | advanced |
+------+---------------+----------+
2 rows in set (0,01 sec)