1
First Assignment DDL (Lab 1) (Submission should be a single Word document with
embedded screen shots of tasks)
1. Load the provided employees database into your Workbench. (NOTE: If you
are using remote login to the labs, you can still perform this step!).
2. Provide a screenshot that demonstrates that the database is loaded.
3. Create three saved SQL script files using basic Select-From-Where
statements.
4. Create three “snippets” from the scripts created in Workbench.
5. Run a simple SQL Select statement (Select * is fine) from the dept_emp table.
6. How many rows were returned? If your screenshot is inclusive enough, that
answer will be included.
7. Perform a Select * from the employee table. How many rows were returned?
2.
3.
