alwayshouston
MIS
Hi All!
I have been given an assignment by local church to create a small database application to to track and report daily clinic visit information. I have design the tables to capture visit information of patients. But I am having problems with the designing of the database to include clinic daily information (such as clinic daily expenses, clinic daily revenues) in a table based on visit date. How would I create a relational design that would incorporate patient visit by date and clinical daily information only on DAY basis? What should be ideal design for clinic daily information table and how should I relate it to visit table? Let me explain the scenario with an example. Let say patients come to the clinic for their blood pressure check up. This information is inserted into tblVisit table. At the end of the day, if the clinic administrator wants to store information based on clinic (revenue, expenses etc...), how can you store this information in a table that relates to the visits by patients? Do you really have to relate it or you can create a table mutually exclusive of tblVisit to store daily clinic information.
Please Advise!
Thanks!
I have been given an assignment by local church to create a small database application to to track and report daily clinic visit information. I have design the tables to capture visit information of patients. But I am having problems with the designing of the database to include clinic daily information (such as clinic daily expenses, clinic daily revenues) in a table based on visit date. How would I create a relational design that would incorporate patient visit by date and clinical daily information only on DAY basis? What should be ideal design for clinic daily information table and how should I relate it to visit table? Let me explain the scenario with an example. Let say patients come to the clinic for their blood pressure check up. This information is inserted into tblVisit table. At the end of the day, if the clinic administrator wants to store information based on clinic (revenue, expenses etc...), how can you store this information in a table that relates to the visits by patients? Do you really have to relate it or you can create a table mutually exclusive of tblVisit to store daily clinic information.
Please Advise!
Thanks!