logo

Dance Program and Technofest

   

Added on  2019-09-20

30 Pages4222 Words377 Views
 | 
 | 
 | 
CREATE database UP654321db; //Create database with UP654321db nameParticipation//SQL query to create tableCreate table Participant ( partID integer PRIMARY KEY, partTitle varchar(30), partFName varchar(10), partLName varchar(10), partDOB Date, partAddress1 varchar(50), partCity varchar(30), partPhone integer(10), partEmail varchar(30), amountReleased decimal);This table contains all information of the participant of the event like their ID, address,city, phone number1
Dance Program and Technofest_1

// SQL Query to Insert dataINSERT INTO participant VALUES('12345',"DB","Margaret","Emily",'1992-05-12',"Acton","London",'8181818181',"xyz@gmail.com",2000);INSERT INTO participant VALUES('23456',"CO","Ann","Poppy",'1991-03-09',"Anerley","London",'8282828282',"abc@gmail.com",2100);INSERT INTO participant VALUES('34567',"OS","Jane","Ava",'1993-06-09',"Beckon","London",'8383838383',"pqr@gmail.com",2050);INSERT INTO participant VALUES('45678',"Server","Alice","Isabella",'1994-08-25',"White Field","Manchester",'8484848484',"bcd@gmail.com",2030);INSERT INTO participant VALUES('56789',"Network","Ellen","Jessica",'1993-05-26',"Prestwich","Manchester",'8585858585',"cde@gmail.com",2150);INSERT INTO participant VALUES('67890',"Algo","Annie","Lily",'1989-06-22',"Altrincham","Manchester",'8686868686',"def@gmail.com",2180);INSERT INTO participant VALUES('78901',"DS","Florence","Sophie",'1990-07-23',"Catford","London",'8787878787',"efg@gmail.com",2020);INSERT INTO participant VALUES('89012',"CP","Emma","Grace",'1991-09-27',"Charlton","London",'8888888888',"fgh@gmail.com",2190);INSERT INTO participant VALUES('90123',"Com","Robert","Thomas",'1991-10-27',"Barbon","London",'8989898989',"ghi@gmail.com",1900);INSERT INTO participant VALUES('01234',"gom","George","Jacob",'1990-11-28',"Fronzr","Manchester",'8080808080',"hij@gmail.com",2010);2
Dance Program and Technofest_2

Register//SQL Query to Create Register TableCREATE TABLE Register( PartID integer, eventID integer, regDate date, regDatePage date, PRIMARY KEY(PartID,eventID));This table contains all information about the registration of the participants like on which date they have registered for the event and on which date they have paid the fee for the event along with their ID3
Dance Program and Technofest_3

//SQL Query to insert data in TableINSERT INTO Register VALUES('1234','1234560','2017-02-12','2017-03-15');INSERT INTO Register VALUES('12345','1234567','2017-02-18','2017-03-16');INSERT INTO Register VALUES('23456','2345678','2017-02-20','2017-03-15');INSERT INTO Register VALUES('34567','3456789','2017-02-15','2017-03-17');INSERT INTO Register VALUES('45678','4567890','2017-02-16','2017-03-18');INSERT INTO Register VALUES('56789','5678901','2017-02-17','2017-03-16');INSERT INTO Register VALUES('67890','6789012','2017-02-11','2017-03-18');INSERT INTO Register VALUES('78901','7890123','2017-02-21','2017-03-20');INSERT INTO Register VALUES('89012','8901234','2017-02-06','2017-03-19');INSERT INTO Register VALUES('90123','9012345','2017-02-23','2017-03-21');4
Dance Program and Technofest_4

EventSupplier//SQL Query to create EventSupplier TableCREATE TABLE EventSupplier( supplierID integer(10), eventID integer(10), evSuppCost decimal, PRIMARY KEY(supplierID,eventID));This table contain all information about the supplier who provide all things at the event5
Dance Program and Technofest_5

//SQL Query to Insert the data in TableINSERT INTO EventSupplier VALUES('123456','1234567','22000');INSERT INTO EventSupplier VALUES('234567','2345678','21000');INSERT INTO EventSupplier VALUES('345678','3456789','21200');INSERT INTO EventSupplier VALUES('456789','4567890','20500');INSERT INTO EventSupplier VALUES('567890','5678901','20100');INSERT INTO EventSupplier VALUES('678901','6789012','20200');INSERT INTO EventSupplier VALUES('789012','7890123','20700');INSERT INTO EventSupplier VALUES('890123','8901234','22300');INSERT INTO EventSupplier VALUES('901234','9012345','22200');INSERT INTO EventSupplier VALUES('012345','0123456','22600');6
Dance Program and Technofest_6

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Create SQL Tables for Event Management System
|11
|1212
|460

Design Database for Event Management System
|7
|553
|254

Event Management System Database Design
|10
|981
|431

Database Implementation Assignment Report
|10
|1642
|12

KC7013 DATABASE MODELLING | SQL
|26
|3569
|10

Business Data Management and Analytics Assignment 2022
|10
|1141
|5