each of the following questions and upload answers to the FEeLS as a pdf​ document naming it with your registration number​ (E_17_XXX.pdf).​
Perform the following tasks using MySQL.
- Display all the existing databases in MySQL server host.
- Create a database called “BookShop”.
- Select or access the “BookShop” database.
- 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 |
- Display the structure of the “Book” table.
- 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
- Display the structure of the “Publisher” table.
- Display all the tables in the “BookShop” database.
- Remove the table “Book”.
- Remove the database “BookShop”.
2
