You need to have two tables, one for storing information about medicines and other one for inventory. Databases are collection of tables that are related to each other. We can have one big table with all the information about medicines in it but it will cause a lot of issues while adding or updating the … Read more
You might want to start with database answers. This is a large collection of database models, offered for free. Many of them have no implementation alonmg with them, so they are just a starting point for a do it yourself project. But the author has done a lot of work clarifying the problem. I don’t … Read more
It depends on the end product and what level of device integration you hope to have (and when you hope to have it). To start with, it sounds like you’d be best served by designing a standard web application with mobile support… if you are diligent and design EVERYTHING to support mobile browsers then there … Read more
You have a User table with a User ID as the primary key. You have a Step table with a Step ID as the primary key. Something like this. Step —- Step ID Step Name Then you have a junction table that captures the many to many relationship between users and steps. UserStep ——– UserStep … Read more
You are misunderstanding the concept of a database. You don’t add a column for each entry. Instead, look at your items, ores in this case, what do they have in common? Could be something like Id, OreName Or could be somwthing complex like: Id, OreName, price + a bunch of other columns with relations It … Read more
SELECT * FROM student_certificates GROUP BY student_id HAVING COUNT([DISTINCT] certificate_id) >= 20 Join students table if some columns from it needed (do not forget to expand GROUP BY expression accordingly). 1 solved sql get query to get any student records who have passed multiple certificates? [closed]
Include a flag column in the user table to indicate the user’s status, then build views on top of this against which you run your actual queries. Maybe something like this: create table users ( …. is_active boolean not null ); create view active_users as select * from users where is_active = true; create view … Read more
That’s a lot of questions in one! I can’t really answer them all for you, but I’ll try and explain a couple things and let you know that I think it would be smarter for you to research thoroughly your questions and if you can’t find an answer, resubmit all of your questions more formally … Read more
I would recommend structuring your category table like below: Category ———- CategoryId ParentCategoryId –nullable CategoryName I’m not sure what you want to store in products so it’s hard for me to tell you how to design that, but at a minimum you should have a CategoryId column in there. I would leave it to your … Read more
There is no way insertion in a table can check whether that primary key is present in another table apart from either forcing this constraint through business rule or by using DB Trigger. You need to analyse your DB Model again and try to identify a good design. 1 solved IS_A relationship primary key validation … Read more
Without seeing the data, lets make some assumptions: A pass is awarded for a subject if the marks obtained for that subject are equal to or more than 50% of the total marks available for that subject. The name of the table is called Enrollment To return a list of students who have passed at … Read more
Assuming you are talking about SMS, the easiest way to do that is to first subscribe to a messaging provider like Twilio and get yourself an API key. Then you can utilize their REST API for sending text messages. 2 solved Need an elixir function that sends a message to a phone number
One way of doing this is to filter your select by using a subselect in the where clause. I did this really fast just to demonstrate: select * from manufacturer m inner join manufacturer_has_product mhp on m.manufacturer_id = m.manufacturer_id inner join product p on mhp.product_id = p.product_id where m.manufacturer_id in ( select m.manufacturer_id from manufacturer … Read more