Logical Database Design for Desklib

This document provides the logical database design for Desklib - an online library for study material with solved assignments, essays, dissertation etc. It includes the tables P17244547_AQ, P17244547_StaffApproval, P17244547_EE, P17244547_Paperpublications, P17244547_publications, P17244547_TeachingStaff, P17244547_AdminStaff and P17244547_TeachingExperience along with their columns and constraints. It also includes the indexes created on some of the tables and sample insert statements.