logo

Database Creation and SQL Assignment

30 Pages4222 Words377 Views
   

Added on  2019-09-20

Database Creation and SQL Assignment

   Added on 2019-09-20

ShareRelated Documents
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
Database Creation and SQL Assignment_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
Database Creation and SQL Assignment_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
Database Creation and SQL Assignment_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
Database Creation and SQL Assignment_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
Database Creation and SQL Assignment_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
Database Creation and SQL Assignment_6

End of preview

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

Related Documents
Event Management System SQL Tables and Commands
|7
|553
|254

Rationale & Assumption
|11
|1212
|460

Sql Join Columns of Two Tables on Unique Key
|10
|981
|431

Database Implementation Assignment Report
|10
|1642
|12

Database Design and Implementation PDF
|9
|1080
|11

KC7013 DATABASE MODELLING | SQL
|26
|3569
|10