Exam Midterm

Exam:

1. Create a simple library system that will cater adding record, deleting record transaction
2. Database name: Library
3. Table: Student, Faculty, Book
   

Students Table:

Stud_ID

Stud_Fname

Stud_Lname

Stud_Course

Stud_Year

Date_Borrowed

Date_Returned

Book_Description

Book_Author

Faculty Table

Fuc_ID

Fuc_Fname

Fuc_Lname

Fuc_Subject

Fuc_status

Date_Borrowed

Date_Returned

Book_Description

Book_Author

Book Table

ISBN_no

Book_title

Book_Des

Book_Author

Your system is compose of a Main Menu that contains 3 buttons the students and Faculty and book. Design a Form for students, faculty and books with add,delete,clear and exit buttons. and display the current date and current time