I am developing an application for Android platform. And I am stuck at one point.This question is not about android specific therefore I am asking it here.
At the start of application I a showing a list of rooms (i.e list containing room names) to the user. User select one room name from this list. Now I want to store this selected item to database. For that I had created one table name as RoomTable. which has 3 columns as - RoomID (primary key), RoomName, and RoomSuffix.
So let suppose user selected room name as Hall then inside database entry becomes as