For this assignment we will use the database world in the MySQL installation.

To access the database:

1. Launch the MySQL Command Line Client executable
2. Login in using the password set during installation

Tasks Activity Physical schema What database schemas are in the MySQL DBMS? Use command "show databases" Select to use database "world" Use command "use world;" What feedback is provided in the command line window? How many tables are in the database? What are the table names? Use command "show tables;" How many fields are in table city? What are the field names? Use command "describe city;" Or Use command "select columns from city;" What is the data type of the following fields in table country? 1. Name 2. Continent 3. SurfaceArea 4. Indep Year 5. Capital What are the column names of the fields that are a primary key or foreign key in table countrylanguage? Use command: show create table countrylanguage;" | View Level How many records are in table city? Use command "select count(*) from city;" How many records are in table country? How many records are in table countrylanguage? What is the name and population of the city in district Nebraska? Use command "select name, population from where district = "Nebraska";" What are the five largest populations in table city? Use command "select name, population from city order by population desc limit 5;" What are the 5 largest populations in table city starting at record 11? Use command "select name, population from city order by population desc limit 5 offset 10;" Activity Physical schema Select to use database "sakila" What feedback is provided in the command line window? How many tables are in the database sakila? What are the table names? How many fields are in table rental? What are the field names? What is the data type of the following fields in table city? 1. city_id 2. city 3. country id 4. last update What are the column names of the fields that are a primary key or foreign key in table film? Use command: "show create table film;" View Level How many records are in table category? How many records are in table actor? How many records are in table film? What is the name, city and country of each person in the staff_list table? What is the actor id for actor Lisa Monroe? How many films in table film_actor is actor Lisa Monroe in