Question

Create a database and perform a query using SQLite.

Include screen shots to show the database and at least one table you created.

Answer 1

//Here is the database creation, using, table creation, insert values into table, and show the values of table and show databases​​​​​​​​​​​​​​​​ by using SQL commands. 

//I have attached screen shots which are included the data. 
​​​​​​​
mysql>create database company;
Query Ok,1 row affected (0.02 sec)
mysql> use company;
Database changed
mysql> create table emp(fname char(20),lname char(20),ssn int primary key,salary
 real,gender char(10));
Query OK, 0 rows affected (0.45 sec)

mysql> desc emp;
+--------+----------+------+-----+---------+-------+
| Field  | Type     | Null | Key | Default | Extra |
+--------+----------+------+-----+---------+-------+
| fname  | char(20) | YES  |     | NULL    |       |
| lname  | char(20) | YES  |     | NULL    |       |
| ssn    | int(11)  | NO   | PRI | NULL    |       |
| salary | double   | YES  |     | NULL    |       |
| gender | char(10) | YES  |     | NULL    |       |
+--------+----------+------+-----+---------+-------+
5 rows in set (0.13 sec)

mysql> insert into emp(fname,lname,ssn,salary,gender)values("Rama","Krishna",145
67,50000,"M"),("Rajesh","Kumar",15678,30000,"M"),("Jiya","Singh",15876,35000,"F"
),("Kalpana","Kumari",17894,45000,"F"),("John","Charles",18934,50000,"M");
Query OK, 5 rows affected (0.09 sec)
Records: 5  Duplicates: 0  Warnings: 0

mysql> select *from emp;
+---------+---------+-------+--------+--------+
| fname   | lname   | ssn   | salary | gender |
+---------+---------+-------+--------+--------+
| Rama    | Krishna | 14567 |  50000 | M      |
| Rajesh  | Kumar   | 15678 |  30000 | M      |
| Jiya    | Singh   | 15876 |  35000 | F      |
| Kalpana | Kumari  | 17894 |  45000 | F      |
| John    | Charles | 18934 |  50000 | M      |
+---------+---------+-------+--------+--------+
5 rows in set (0.05 sec)

mysql> select fname,ssn,salary from emp where gender="M";
+--------+-------+--------+
| fname  | ssn   | salary |
+--------+-------+--------+
| Rama   | 14567 |  50000 |
| Rajesh | 15678 |  30000 |
| John   | 18934 |  50000 |
+--------+-------+--------+
3 rows in set (0.00 sec)

mysql> select fname,lname,salary from emp where ssn="14567";
+-------+---------+--------+
| fname | lname   | salary |
+-------+---------+--------+
| Rama  | Krishna |  50000 |
+-------+---------+--------+
1 row in set (0.06 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| books              |
| company            |
| krish              |
| mysql              |
| performance_schema |
| sakila             |
| test               |
| world              |
+--------------------+
9 rows in set (0.00 sec)

mysql>