First of I created every tables by query languages, you can identify it bellow

After the creates tables it shows on “VideoLibrary database” like

All Structured Query Languages that I had used on my database.

In my program I had table call “loginfrm” Here I had create only 2 columns those are

      I.        Username

    II.        Log-password

I have connected this table for a log in system. On that case I had used bellow codes to get the value of log in table.

1.  select username,logpassword from loginfrm

Next I have connected all other tables with query languages. Those query language (codes) and outputs are…

All query languages for Reservation table

Figure 6 - 4.1 - Reservation Table

select * from reservation

2  SELECT MAX(reservationNo)+1  from reservation

3.  insert into reservation values ('10003','10001','VL-TM-002','06/10/2012','Thandavam','TM Tdvm1')

All query languages for member table

1.  select * from memberReg

It will continue up to Bank Account Table. No space to add others.

select MAX (mem_ID)+1 from memberReg

3.  insert into memberReg values ('10001','mixlife','Saz','No 12, Kandy Road','Matale','Male','1.1.1991','Student','123456789v','sazmixlife@gmail.com','2.10.2012','2.10.2013','HNB','1234567890')

                                                       

4.  update memberReg  set mem_LastName = 'HND21', mem_FirstName ='Unknown',mem_Address ='Peradeniya Road', mem_City = 'Kandy', mem_Gender = 'Other', mem_Age ='12.10.2000', mem_Professional ='College',NIC ='121212121v',mem_Email ='bcas@gmail.com',mem_RegistrationDate ='1.10.2012',mem_ExpiredDate ='1.10.2013', mem_Bank ='HSBC', mem_AccNumber ='1231231234' where mem_ID ='10001'

Before updating the row 2 of member registration database and member ID = 10001

After the updating

Delete from memberReg where mem_ID ='10001'

All query languages for borrowing table

1.       select * from borrowing

2.       select MAX (borrowingID)+1 from borrowing

3.       insert into borrowing values('10004','10001','VL-M-100','TM-Advn1','31.10.2012','1.11.2012')

All query languages for Return video table

1.       select * from returnVdo

2.       select MAX (returnNo) +1 from returnVdo

3.       insert into returnVdo values ('10002','10001','VL-M-1001','Thandavam','TM-Tdvm1','Monday, October 01, 2012')

All query languages for Add video table

1.       select * from videoAdd

2.       select MAX (videoID)from videoAdd

3.       insert into videoAdd values ('VL-M-1002','HD','2011','Adukallam','TM-Aklm1','2')

4.       Delete from videoAdd where videoID ='VL/M/1001'

These query languages are I had used in my program. All details are created by myself. Further information please refers all detail that I have provided.

Thank you, by © Admin