1) The existing database (the core of MIS) contains the following elements of subsistems:

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)