Member Avatar for duliduli556

I am trying to create a database for a simple key loan and return System. Basically, a key to a specific door is loaned to somebody and then returned. So far I have 3 tables. Not sure if it should be normalized further, since only one key will be issued and returned per transaction.

tblKeys
KeyID
Location
DoorNum

tblKeyMaster
KeyMasterID
KeyMasterName

tblKeyTrans
IDKeyTrans
KeyID_in
Date_in
KeyMaster_in
KeyID_out
Date_out
KeyMaster_out

  • 2 Contributors
  • 1 Reply
  • 61 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

What exactly is the nature of transaction that you are going to execute on this data base ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.