CO226 Lab 4-Introduction to MySQL Solved

35.00 $ 17.50 $

Category:
Click Category Button to View Your Next Assignment | Homework

You'll get a download link with a: . zip solution files instantly, after Payment

Description

Rate this product

 

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.

 

  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

 

  1. Display the structure of the “Book” table.
  2. 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

  1. Display the structure of the “Publisher” table.
  2. Display all the tables in the “BookShop” database.
  3. Remove the table “Book”.
  4. Remove the database “BookShop”.

2