I have a database that has a list of drug names, their dosages, administration data etc. It ties in to the front end form where a user would enter this data.
I also need to record information about the pharmacist which is also on the same form (as they’re somewhat related). I could create the name, email, telephone etc fields in the same database as the above - all other fields relating to the drugs information will naturally be blank. Is this a valid way of database design, or is it better practice to create a new database altogether for these 4 or 5 fields (and one row of data)?
Hi there, @JS7319… if I understand your post correctly, you definitely want to have a Pharmacist data type, and that data type would have all of the fields related to a pharmacist, of course. You probably also want to have a Drug data type that has all of the data associated with a particular drug but not any dosage data (assuming we are talking about the same drug being able to have different dosages). Then, you could have a Dosage data type that has fields that link to the Drug and Pharmacist data types, and it would have its own fields that are specific to a particular dosage of the associated drug.
Anyway, maybe more food for thought there than anything else, and I hope it helps.
