Question

SQL commans For this assignment, submit a text file with the commands that you entered into your MySQL database on burrow to do the following: 1. (25 points) Create a table called Singer, when described it should have the following values: | Field I Type I Null Key Default l Extra | SingerID int (11) | FirstName | varchar (30) YESI I LastName varchar (30) YES I | Label | Salary I Style I YES I UNI I NULL I NULL I NULL I NULL I NULL I NULL | varchar (30)YES I | int (11) I varchar (30) I YES I YES I 6 rows in set (0.00 sec) 2. (25 points) Create a table called Tour, when described it should have the following values: | Field ITourID | Begin I Type | int (11) I date I Null I Key I Default I Extra I I YES I UN 1 I NULL I YES I TourName varchar (30) YESI NULLI I NULL YES I YES I End I date NULLI I NULL | Headliner int (11) 5 rows in set (0.01 sec) 3. (25 points) Write a statement that will add an individual to the Singer table 4. (25 points) Write a statement that will show all the singers who have a salary greater than 250000 on the Sony Label

please write a file with the commands attached

Answer 1

//first question

CREATE TABLE IF NOT EXISTS `singer` (
`Singer ID` int(11) DEFAULT NULL,
`FirstName` varchar(30) DEFAULT NULL,
`LastName` varchar(30) DEFAULT NULL,
`Label` varchar(30) DEFAULT NULL,
`Salary` int(11) DEFAULT NULL,
`Style` varchar(30) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

//second question
CREATE TABLE IF NOT EXISTS `tour` (
`TourID` int(11) DEFAULT NULL,
`TourName` varchar(30) DEFAULT NULL,
`Begin` date DEFAULT NULL,
`End` date DEFAULT NULL,
`Headliner` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

//third question
insert into singer (SingerID,FirstName,LastName,Label,Salary,Style)values(1,'Srinu','Kanchi','Sony',25000,'style');

//fourth question
SELECT * FROM `singer` WHERE Salary>250000 and Label='Sony';