In my system I have two users:
- Request sender
- Users receive the requests
I want to create my database tables
1-requestTable
__________
requestid
createdat
2-usersTable
__________
userid
name
answer(yes/no)
If I have 100 user and I send only three request only will be like this
RequestID || UserID || Answer ||
________ || _____ || ______ ||
req1 || user1 || yes ||
req1 || user2 || No ||
req1 || user3 || No ||
req1 || user4 || Yes ||
req1 || user5 || Yes ||
this will insert 300 record for 100 user for 3 request only and this is not optimal.
What is the optimal way to create the database in the optimal way?