The project assignment:
1) The existing database (the core of MIS) contains the following elements of subsistems:
a) Inventory (part of ERP) – tblBooks, tblAuthors;
b) List of Suppliers (part of SCM) – tblPublishersh;
2) You should create the new parts of MIS (as tables, queries and forms):
a) CRM – records of customers
b) Human Resource (part of ERP) – records of employees and positions
c) Transaction Management – records of transaction (what is sold, how many is sold, who sold, to whom is sold)