Abdalla Elawad

Abdalla Elawad

  • NA
  • 1k
  • 203.8k

how to design database with relationship

Nov 28 2017 2:09 AM
Hello Guys
 
Please Help Me
 
Firstly I know is this scenario for IT Inventory is right or wrong ? then I will design new system and database for IT Inventory, I designed 3 tables as below:
 
Employees TBL: EmpNo. , EmpID , EmpName , Telephone , Dept. , Mobile ,Email , City , Branch.
New Item TBL : ItemID , ItemBarcode , Model , ItemDesc. , PartNo.
Custody TBL: Connect item With Employee : EmpNo. , ItemBarcode , Model , ItemDesc. , PartNo.
 
I want to define the relationship between three tables above.
 
Thanks.

Answers (8)