XXX company try to design the new AIS, and for that the following requirements of the data were given:

Database	Data components	Notes
GL	- Account code - Account name - Account category code - Account category name - FS code - FS Title - Currency code - Currency name - Currency Exchange rate - Debit side - Credit side - Balance	Determine both the primary and the foreign Keys

Database	Data components	Notes
Production lines	- Production line code - Production line name - Supervisor code - Supervisor name - Item code - Item name - Employee name - Employee code - Labor card code - labor code - labor description - amounts of hours	Determine both the primary and the foreign Keys

Database	Data components	Notes
Cost estimate data base	- Product code - Product code - Item code - Item name - Item unit cost - Production line code - Production line name - Employee code - Employee name - Labor card code - Labor card name - Rate per labor hour - Amounts of labor hours - Account code - Account name - Allocation base code - Allocation base title - Allocation base amounts	Determine both the primary and the foreign Keys

Database	Data components	Notes
Inventory	- Item code - Item name - Item measurement unit - Item unit cost - Warehouse code - Warehouse name - Finished product item code - Finished product item name - Finished product item measurement unit	Determine both the primary and the foreign Keys

Database	Data components	Notes
HR , Human resources	- Employee code - Employee name - Employee title code - Employee title description - Employee classification code - Employee classification description	Determine both the primary and the foreign Keys

Database	Data components	Notes
Allocation bases	- Allocation base code - Allocation base title - Allocation base amounts	Determine both the primary and the foreign Keys

Database	Data components	Notes
Machines data allocation	- Machine code - Machine description - Machine Cost - Useful life - Annual depreciation - Department code - Department title - Production line code - Production line name - Supervisor code - Supervisor name - Finished product item code - Finished product item name	Determine both the primary and the foreign Keys

Database

Data components

Notes

Machines data allocation

- Machine code

- Machine description

- Machine Cost

- Useful life

- Annual depreciation

- Department code

- Department title

- Production line code

- Production line name

- Supervisor code

- Supervisor name

- Finished product item code

- Finished product item name

complete the following

Database

Key

Filed

Ref

this is the question

and you should complete the following based in the information you have

Database. Key. Filed Ref