Database design is not scalable :
why are tables BookScience,BookHistory,BookLiterature created ?
Instead create inventory table which is as follows:
Following tables will be correct implementation of library managment
book_type_mstr: book_type_mstr_seq, book_type_name,book_type_cd
book_mstr : book_mstr_seq,book_type_mstr(FK), book_name, inventory_count
book_transactions : book_mstr , user_profile_seq , count_books,type_of_transaction,date_of_issue,date_of_return
all the tables above must have audit columns
status - defines if record is active/inactive
createddate
updateddate
createdby - system default 0
updatedby - system default 0
Database design is not scalable :
why are tables BookScience,BookHistory,BookLiterature created ?
Instead create inventory table which is as follows:
Following tables will be correct implementation of library managment
book_type_mstr: book_type_mstr_seq, book_type_name,book_type_cd
book_mstr : book_mstr_seq,book_type_mstr(FK), book_name, inventory_count
book_transactions : book_mstr , user_profile_seq , count_books,type_of_transaction,date_of_issue,date_of_return
all the tables above must have audit columns
status - defines if record is active/inactive
createddate
updateddate
createdby - system default 0
updatedby - system default 0