Question

Gmail Maps © Hanson College BC... Dashboard Go to Help Search ID Year Price 1 Author Richie Karen 2 4 Title C JAVA Script Java C++ prolog 1955 1958 1959 1959 1972 10 20 10 Schwartz Ross Maria 5 6 20 10 7 Per Wall 1987 20 The above relation has information about different books. The table information is already saved as txt format in Moodle under the name Quiz2Data.txt. Using MySql on your computer do: Create a database • Create a table with name book, then load Quiz2Data.txt (check file DataLoad in Moodle for the steps to load the file) Then answer the following questions: 1. Write the definition you used to create the table 2. Provide a screen shot of all the data in the table (Load the screen shot into the question) 3. List the books' titles and years only. DataLoad.pptx W

Database Management

Answer 1

Create a database in MySql:

using MySql phpMyAdmin

SQL command to create a database in MySql.

create DATABASE BOOKDB;

Databases $7 SQL Status User accounts Export Import 3 Settings Replication 1 Variables Charsets More - Run SQL query/queries on server "localhost": 1 create DATABASE BOOKDB; Get auto-saved query Clear Format Bind parameters [Delimiter; i Show this query here again Retain query box Rollback when finished Enable foreign key checks Go

use database to create a table into that database using the sql command. or select from the database which is display in the left menu list.

Databases $22 SQL Status User accounts -Run SQL query/queries on server "localhost": 0 1 use BOOKDB:| Get auto-saved query Clear Format Bind parameters [Delimiter; ] Show this query here again Ret

1. Now create a table using the sql command:

CREATE TABLE IF NOT EXISTS Book (
    ID INT NOT NULL PRIMARY KEY,
    Title VARCHAR(50),
    Author VARCHAR(50),
    Year INT(10),
    Price INT(10)
);

2. Insert the data into database:

INSERT INTO Book VALUES(1, 'C','Riche',1955,10);
INSERT INTO Book VALUES(2, 'JAVA Script','Karen',1958,20);
INSERT INTO Book VALUES(4, 'Java','Schwartz',1959,10);
INSERT INTO Book VALUES(5, 'C++','Ross',1959,20);
INSERT INTO Book VALUES(6, 'Prolog','Maria',1972,10);
INSERT INTO Book VALUES(7, 'Perl','Wall',1987,20);

3. List the books title and years only.

SELECT Title, Year from Book;

Title Year с 1955 JAVA Script 1958 Java 1959 C++ 1959 Prolog 1972 Perl 1987