Recent content by 05me39

Thank you! it is really helpful.

hi. its been a wonderful discussion. everybody seems to be talking about the normalization. I dont have an academic background of software or database. I dont seem to grab the meanings (and I have been trying for a while now) of normalization. I have read the definetions but they dont clear my...

I shall look for that option. Thanks for your suggestion.

Thank you Mile-O for the excellent explanation. since your last post I have been thinking about this issue. it (as per your suggestion) sure seems to be a good design but would it not be difficult to have it in user form? I have a form which collects the data for all the reports. and one form...

Hi, Thank you all for the comments. all of the above comments are really helpful.

Hi, I dont think you need a separate table for the group leader. there can be a field in the drivers table that identifies a particular driver as leader. something like a remarks field. Regards

Hello, I rrad somewhere that it is a good practice to make a new table whenever some entry gets repeated. for example if you have to write the department of employees then it is better to have a separate table having all the departments in it and relating it to the main employees table. how...

Thanks Mihail, that is what I was looking for. I shall try that with my database. If I come across any issues, I shall share it here. However, I am very interested to know the issue in design of the database as mentioned by Mile-O. Thanks once again.

yes it does have a field for each type of report. I am not well versed with the database design so there could be a design issue. please tell the solution.

as an example of the problem, I have a patients database, where the patient'S medical reports (4 different reports) are stored with date. I want to be able to draw reports over time ( sugar level over time). I already have designed a query and drawn the trend. however I have to change the query...

thanks for tye reply. yes that is the requirement of the problem.

Hello! I have a table which has 8 fields. The task is to design a query which always shows the first two fields (or any other two specific fields) and any one of the remaining 6 fields based on the input from the user. I am using a simple form with combo boxes to get the choices from the user...

Hello, I am a mechanical engineer and I am here because I am an enthusiast. also, database tools are very useful in my profession. :cool: