I am planning to analysis parliamentary questions. For this reason, I designed a database. My wanting from this database to know the frequencies of questions asks by a MP with question's subject, nature and focus according to questions types as well as effectiveness and relevancy of answers provided by ministry and or Division with the questions among the four types of questions(Starred, Unstarred, Short Notice, Prime Minister's). If questions & answers are shifted/transferred, I want to know the reasons. Certainly, MPs asks questions and relevant minister answer on it. Therefore above information needs to be displayed with the questioner name(MPs name and Constituency name) and relevant ministry and or division name along with question no, Parliament's session no, and question's date.
When question types are 'Starred' or 'Prime Minister's' it may have supplementary questions and answers. Supplementary may ask MPs in addition to the original questioner. Conventionally, first supplementary question asked by original questioner. Subsequently, minister gives reply. Then other MPs may ask additional supplementary until Speaker moves on next question. Therefore, in supplementary questions, I want to know the supplementary questioner's name & his/her constituency name, supplementary no, question's focus, subject, nature, and relevancy with the original question. Similarly, every supplementary question must answered by minister. So effectiveness and relevancy of supplementary answers also need to know. Information of supplementary questions and answers should be displayed on under the respective original question number.
In my database, main table are tblMain, tblOrgQuestion, tblOrgQuesAnswer, tblSupplAnswer, and tblSupplQuestion. All other tables will be linked these tables via combo boxes on respective fields. By the way, MPs details (education, age, term of office, etc) also need to know for analysis of questions asking criteria.
My database and 5 main tables' relationships are shown in attached file. Please check it.
I am not sure whether my table structures and relationships are correct or not. Please advise me how to correct this or modified my version so that I can get expected output from this database. Therefore I requested you please help me to design my database properly. Need any other clarifications please ask?
Thanks in advance.
ozaman
When question types are 'Starred' or 'Prime Minister's' it may have supplementary questions and answers. Supplementary may ask MPs in addition to the original questioner. Conventionally, first supplementary question asked by original questioner. Subsequently, minister gives reply. Then other MPs may ask additional supplementary until Speaker moves on next question. Therefore, in supplementary questions, I want to know the supplementary questioner's name & his/her constituency name, supplementary no, question's focus, subject, nature, and relevancy with the original question. Similarly, every supplementary question must answered by minister. So effectiveness and relevancy of supplementary answers also need to know. Information of supplementary questions and answers should be displayed on under the respective original question number.
In my database, main table are tblMain, tblOrgQuestion, tblOrgQuesAnswer, tblSupplAnswer, and tblSupplQuestion. All other tables will be linked these tables via combo boxes on respective fields. By the way, MPs details (education, age, term of office, etc) also need to know for analysis of questions asking criteria.
My database and 5 main tables' relationships are shown in attached file. Please check it.
I am not sure whether my table structures and relationships are correct or not. Please advise me how to correct this or modified my version so that I can get expected output from this database. Therefore I requested you please help me to design my database properly. Need any other clarifications please ask?
Thanks in advance.
ozaman
