Answered>Order 205

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)