Question

Your are to create a database with 10 different related tables each of which will have a minimum of 10 records.

Answer 1

1
1
CREATE TABLE `Chegg`.`Persons` ( `Name` VARCHAR(30) NOT NULL , `Age` INT(5) NOT NULL , `City` VARCHAR(30) NOT NULL , `Country` VARCHAR(30) NOT NULL );
INSERT INTO `Persons` (`Name`, `Age`, `City`, `Country`) VALUES ('Mani', '22', 'Vizag', 'India'),VALUES ('Hari', '23', 'Southampton', 'England'),VALUES ('Harsha', '24', 'Sydney', 'Australia'), ('Vijay', '20', 'Delhi', 'India'), ('Harry', '25', 'California', 'USA'), ('Nicholas', '21', 'Gurugaon', 'India'), ('Tom', '26', 'Isthanbul', 'Turkey'), ('Liam', '25', 'Chennai', 'India'), ('Sandeep', '25', 'London', 'England'), ('Rabada', '30', 'Zambia', 'South Africa');

2
CREATE TABLE `HomeworkLib`.`Library` ( `BookName` VARCHAR(20) NOT NULL , `Cost` INT(5) NOT NULL );
INSERT INTO `Library` (`BookName`, `Cost`) VALUES ('Half Girlfriend', '200'), ('The girl next door', '400'), ('My first Love', '250'), ('The LOC', '550'), ('Live your life', '1000'), ('Real Robinhood', '450'), ('Aladdin', '640'), ('Fight Club', '400'), ('Radio Station', '300'), ('Mowgli', '300');

3
CREATE TABLE `Chegg`.`Products` ( `Name` VARCHAR(20) NOT NULL , `Price` INT(5) NOT NULL );
INSERT INTO `Products` (`Name`, `Price`) VALUES ('Vicks', '20'), ('Oreo', '35'), ('Santoor', '45'), ('MilkBikis', '10'), ('Lays', '30'), ('Bingo', '30'), ('Kurkure', '20'), ('Maggie', '50'), ('GoodDay', '15'), ('Dairy Milk Silk', '70');

4
CREATE TABLE `HomeworkLib`.`Employye` (
`Name` varchar(20) NOT NULL,
`EmpId` int(11) NOT NULL,
`Age` int(3) NOT NULL
);
INSERT INTO `Employye` (`Name`, `EmpId`, `Age`) VALUES
('Alex', 1426175, 32),
('Bob', 1427153, 23),
('Trump', 1427678, 45),
('Remo', 152796, 45),
('Zaved', 134629, 54),
('Rahul', 147368, 22),
('Rohit', 135848, 56),
('Uday', 137926, 45),
('Raheem', 136926, 35),
('Ajay', 170529, 29);

5

CREATE TABLE `HomeworkLib`.`Chocolate` (
`Chocolate Name` varchar(20) NOT NULL,
`Price` int(5) NOT NULL
)
INSERT INTO `Chocolate` (`Chocolate Name`, `Price`) VALUES
('Dairymilk', 100),
('Ferro Rocher', 299),
('5star', 200),
('Kitkat', 199),
('Munch', 399),
('Kisses', 699),
('Snikkers', 477),
('Perk', 199),
('Fuse', 122),
('Mahachoco', 132);

6
CREATE TABLE `Chegg`.`Movies` ( `Name` VARCHAR(30) NOT NULL , `Release Date` DATE NOT NULL );
INSERT INTO `Movies` (`Name`, `Release Date`) VALUES ('Super 30', '2019-06-19'), ('Agent 21', '2019-06-15'), ('Avengers END GAME', '2019-04-25'), ('Maharshi', '2019-05-09'), ('Game Over', '2019-06-14'), ('Udna', '2019-06-07'), ('Kabir Singh', '2019-06-21'), ('Air Bender', '2019-06-21'), ('Aladdin', '2019-06-04'), ('Dumbo', '2019-05-16')

7
CREATE TABLE `HomeworkLib`.`Company` (
`CompanyName` varchar(20) NOT NULL,
`Turnover` int(12) NOT NULL
);
INSERT INTO `Company` (`CompanyName`, `Turnover`) VALUES
('Google', 1000),
('Facebook', 1001),
('Instagram', 10002),
('Infosys', 10003),
('Cognigent', 10005),
('Dell', 10004),
('Accenture', 10006),
('Hcl', 5001),
('Behrouz', 1008);

8
CREATE TABLE `HomeworkLib`.`Courses` (
`CourseId` int(3) NOT NULL,
`CourseName` varchar(20) NOT NULL,
`Cost` int(9) NOT NULL
);
INSERT INTO `Courses` (`CourseId`, `CourseName`, `Cost`) VALUES
(1, 'Java', 1000),
(2, 'Cpp', 599),
(3, 'Html', 499),
(4, 'Javascript', 999),
(5, 'Flutter', 699),
(6, 'Dart', 400),
(7, 'Python', 999),
(8, 'Oracle', 999),
(9, 'R', 677),
(10, 'Go', 588);

9
CREATE TABLE `HomeworkLib`.`AppsAndNumberofDownloads` (
`Appname` varchar(20) NOT NULL,
`Downloads` int(11) NOT NULL
);
INSERT INTO `AppsAndNumberofDownloads` (`Appname`, `Downloads`) VALUES
('Whatsapp', 200000),
('Facebook', 2000001),
('Instagram', 200003),
('Hike', 20005),
('Uber', 20004),
('Ola', 200004),
('Picasa', 200008),
('Chrome', 30002),
('Pubg', 40003),
('Swiggy', 50002);

10
CREATE TABLE `Ipl` (
`Teamname` varchar(20) NOT NULL,
`Numberofwins` int(10) NOT NULL
);
INSERT INTO `Ipl` (`Teamname`, `Numberofwins`) VALUES
('RCB', 5),
('CSK', 8),
('MI', 5),
('RPS', 2),
('KKR', 4),
('KXIP', 6),
('RR', 3),
('SS', 5),
('GL', 4),
('RI', 7);