How to create the database for Personal Inventory System

[Thekkiniath Antony Joseph]

How to Create table for Personal Inventory System?


My concern is Central Electrochemical Research Institute. In this Institute

there are 700 employee are working. They will indent any items for there

work. As per the indent Purchase Section will rise order. After sending Order

Stores will receive the item, that time. Store people will enter the item into

DRR (Daily Receipt Register) to produce the CRV (Certified Register Voucher).

This is for confirmation from indentor, to check whether it is working fine

or not. If it is failure item will return supplier otherwise Store people

will taken into stock.


We have two types of items there are Consumables and

Non-Consumables. At the time of taking stock if it is Non-Consumble items.

We will taken into Personal Inventory Register (PIR).


What are the activities in PIR we are doing is as follows:


1. Issue to indentor

2. Transfer to somebody (at the time of tranfer to other section or

retirement)

3. Return to Stores as Servicable Item

4. Return to Stores as Unservicable Item

5. Loss


What are the reports we want is:


1. Issue report for employee wise and date wise

2. Transfer report for employee wise and date wise

3. Serviceable items report

4. Unserviceable items employee wise and date wise

5. Loss statements

6. Existing items report for each employee


Our key field is only Employee ID Number.


These are the columns we are using in Daily Receipt Register.


Daily Receipt Register Table:



Daily Receipt Number (Primary Key)

Daily Receipt Date

Mode of Delivery

Name of the Supplier (i.e. supplier code, it is linked with Supplier Table)

Name of the Indentor (i.e. employee ID, it is linked with employee table)

Order Number (it is linked with Order table)

.

.

.


Daily Receipt Register Item table:


Daily Receipt Number (Secondary Key)

Material Code (it is linked with Material table)

Quantity Received

Quantity Accepted

Quantity Rejected

Remarks


But we don't know how to create table for Personal Inventory Register.


Kindly give idea with example table.


With Love,

Joseph


E-mail to : 1. [email protected] 2. [email protected]

[Dave Lorde]

This sounds remarkably like a course assignment!


What kind of database is your system using?


How is it you've got such a detailed database spec, but your people don't know how to create a table?


What have you got so far?


Dave

Where is this Central Electrochemical Research Institute located?