1. Display all the existing databases in MySQL server host.
2. Create a database called “BookShop”.
3. Select or access the “BookShop” database.
4. Within that database, create a table called “Book” with the following fields.
Field Name
Type
Field Size
BookID
Text
5
Title
Text
50
Author
Text
30
Category
Number
Price
Currency
8,2
PubID
Text
6
5. Display the structure of the “Book” table.
6. Create another table called “Publisher” with the following fields.
Field Name
Type
Field Size
PubID
Text
6
PublisherName
Text
30
RegisteredDate
Date
Country
Text
15
1
7. Display the structure of the “Publisher” table.
8. Display all the tables in the “BookShop” database.
9. Remove the table “Book”.
10. Remove the database “BookShop”.
