Enterprise Resource Planning Systems Are a Sophisticated Form of Relational

question 32

Essay

Enterprise resource planning systems are a sophisticated form of relational database technology; one common ERP system module is customer relationship management.Create database specifications (table names and field names) for three tables you would expect to find in an ERP system's customer relationship management module.At least one of the tables must be a junction table.Indicate primary keys by underlining and foreign keys with brackets; ensure that each table is in 3NF.

---

Definitions:

Diminishing Returns

An economic principle stating that as investment in a particular area increases, the rate of profit from that investment, after a certain point, cannot continue to increase if other variables remain at a constant.

Average Total Cost (ATC)

ATC refers to the per-unit cost of production, calculated by dividing the total costs by the quantity of output produced.

Diseconomies of Scale

Increases in the firm’s per-unit costs associated with increases in firm size due to inefficiencies and monitoring problems.

Anti-Employment Discrimination Legislation

Laws designed to prevent discrimination in hiring, promotion, job assignment, termination, and compensation based on certain specified characteristics.