-
Database normalization
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|