Happy Diwali!!

Wish all of you a very happy and safe diwali!!

Library Documentation

Sorry for the delay, it can be found here. Please call me if you have any doubts! Thank you!

Lab Exam is on the 25th of OCTOBER!

And not on the 24rth of this month as was originally announced! Please make note!

Visual Basic - Library Management System

Please use the following images and code for completing the record tomorrow. I'll add the whole module and the code with comments that explain what is happening in the code by Sunday, so that you can easily understand the application and the code and implement it if you get it in the exam.

I'm using an OLE ActiveX Data Reference which is very similar to the Data Control which you are accustomed to. I will include a short tutorial on that later(by sunday I hope!) Please bear with me.

For the time being, just take prints, complete your record and submit it!! Code will follow at the bottom.

T0 save the images,

1. First Click on the Image
2. In the window that opens Right Click on the Image
3. Select "Save" (or) "Save Image As" depending on your browser.
4. You're Done!
5. Close that window to return to this page! You can now print the image!
   

FORM - Issuing a book (Click on image to open)

FORM - Return / Renew / View (Click to open)

SQL Commands for creating the required tables

---

STUDENT_MASTER TABLE

Creation :

create table student_master(s_no varchar2(10) primary key check(s_no like 'S%'),

s_name varchar2(15),s_age number(3),s_sex varchar2(6),s_address varchar2(20),

s_city varchar2(15),s_state varchar2(15),s_pincode number(7),s_dept
varchar2(15),

s_books_max number(2),s_books_count number(2));



Insertion :

insert into student_master values('&no','&name',&age,'&sex',

'&address','&city','&state',&pincode,'&dept',&max,&count);

---

BOOK_MASTER TABLE

Creation :

create table book_master(b_no varchar2(6) primary key check(b_no like B%'),

 b_namevarchar2(25),b_publisher varchar2(15),b_edition varchar2(15),

b_author varchar2(15),b_category varchar2(15),b_isbn varchar2(15),

b_price varchar2(15),b_status varchar2(12) check(b_status
IN('Stack','Circulation')));



Insertion :

insert into book_master values('&no','&name','&publisher', '&edition',

'&author','&category','&ISBN','&price','&status');

---

STUDENT_ACCOUNT TABLE

Creation :



create table student_account(s_no varchar2(6) references student_master(s_no),

b_no varchar2(6) references book_master(b_no),issue_date date, return_date
date);

Insertion for student_account table will be taken care of by the program
;-)

---

Actual VB Code is found color coded in the following links, Please click and open the file, then save or print it!

1. VB Code for Issue
2. VB Code for Renew / Return / View

Will give help file later on! Hope you found it useful! Have fun!

Byes for now! :-)

CST Quiz tomorrow

The Client/Server Quiz will be conducted tomorrow. Venue to be decided later on. Think it would be good if all of you finished lunch as soon as you finish your EDC exam.

Topics for the Quiz will be general not excluding Computer Technologies :-P

Hoping to catch you there soon!