Page 1
BC2402
Week 3 Class Exercises – Basic SQL
ER diagram for employee database
Required: Using the information provided above, specify the SQL syntax for the following:
1. Show a list of all the tables in the database.
[see something unexpected?]
2. Display the names (first name, last name) and gender of all employees.
