screen shots

Screen Shots

 

Project relations

 


Through this relation make the easy to find any medicine , and fine the employ data etc.

Project ERD.

 

  Form of Tables

Arrangment

 

Row

 

Colums

 

These tables is making for finding the medicine and its company.
You type the medicine name and its power or type computer tell the name of company and its location in which rank in the store.

 

Profit.

Retail

Cost


 

These table is making for finding the profit.

Medidicines and Company

 

Medicine

 

Company

 

 These table use for finding the mdicine company. You tell the medicine name and computer tell the the company name.

Employs

 

Employ’s Pay

 

Employ Attendence

 

These tables use for finding the data of emloys and it pay.
Through these table you also find the attendence of employs.

Queries

Query of arrangement in rows and colums





Parameter 

Query of profit by retail and sale


Query of employers 

Parameter

Reports

Arrangement

Rows

colums

Profit

Retail 

Cost

Medicine and company

Medicines


Company


Employ


Employ pay

Employ attendence

 

 

No comments:

Post a Comment