mysql> select *from employee;
+------+--------+---------+---------+------+
| enum | ename  | salary  | address | dept |
+------+--------+---------+---------+------+
| E7   | Amine  | 7500.00 | Fes     | D2   |
| E6   | Aziz   | 8500.00 | Casa    | D1   |
| E5   | Amina  | 8000.00 | Rabat   | D3   |
| E4   | Said   | 5000.00 | Agadir  | D3   |
| E3   | Fatima | 7000.00 | Tanger  | D2   |
| E2   | Ahmed  | 6000.00 | Casa    | D1   |
| E1   | Ali    | 8000.00 | Rabat   | D1   |
| E8   | Ahmed  | 4000.00 | Casa    | D4   |
+------+--------+---------+---------+------+
8 rows in set (0.00 sec)

mysql> select * from department;
+------+--------------+-------+-----+
| dnum | dname        | floor | mgr |
+------+--------------+-------+-----+
| D4   | HiFi         |     3 | E8  |
| D3   | Livres       |     2 | E5  |
| D2   | Alimentation |     3 | E3  |
| D1   | Jouets       |     1 | E1  |
| D5   | Bazar        |     2 | E1
 |
+------+--------------+-------+-----+
5 rows in set (0.00 sec)

mysql> select * from product;
+------+----------+--------+-------+---------+
| pnum | pname    | weight | price | address |
+------+----------+--------+-------+---------+
| P5   | Linux    |      3 |  5.00 | Fes     |
| P4   | Java     |      3 |  5.00 | Rabat   |
| P3   | Eclair   |      1 |  1.00 | Tetouan |
| P2   | Barbie   |      3 |  4.50 | Rabat   |
| P1   | ColdPlay |      2 |  2.00 | Casa    |
| P6   | Orangina |      2 |  3.50 | Agadir  |
+------+----------+--------+-------+---------+
6 rows in set (0.00 sec)

mysql> select * from sell;
+------+------+------+
| dnum | pnum | qty  |
+------+------+------+
| D1   | P2   |  100 |
| D2   | P3   |  200 |
| D2   | P6   |  300 |
| D3   | P4   |  100 |
| D5   | P6   |  100 |
| D5   | P5   |  200 |
| D5   | P4   |  400 |
| D5   | P3   |  300 |
| D5   | P2   |  100 |
| D3   | P5   |  300 |
| D5   | P1   |  200 |
+------+------+------+
11 rows in set (0.00 sec)

mysql>