11-15-2017, 01:39 PM
Project scope:
to develop a data base system which records books inventory along with sales information.
the database will contain :
1. user interfaces
1.1.book registration form: which helps to register book information including; book name, book genre (type), quantity, author, publisher, published year, translated by, etc...
1.2 sales registration form: which helps to register book sale inventory including: book name, quantity, unit price, total price, date of purchase, date of sale, quantity of sold, remaining, total value of sale, profit, credit, loose, stock amount, etc
2. data base interfaces
2.1 tables used to store book inventories and means to retrieve or search from the category
2.2 tables used to store sales inventories and means to retrieve or search from the category
3. user control panel: form helps to assign admin and user privileges
to develop a data base system which records books inventory along with sales information.
the database will contain :
1. user interfaces
1.1.book registration form: which helps to register book information including; book name, book genre (type), quantity, author, publisher, published year, translated by, etc...
1.2 sales registration form: which helps to register book sale inventory including: book name, quantity, unit price, total price, date of purchase, date of sale, quantity of sold, remaining, total value of sale, profit, credit, loose, stock amount, etc
2. data base interfaces
2.1 tables used to store book inventories and means to retrieve or search from the category
2.2 tables used to store sales inventories and means to retrieve or search from the category
3. user control panel: form helps to assign admin and user privileges