Your friend owns a chemist shop, he needs to keep records of the medicines with their id’s, date of purchase, expiry date, price, etc. in a database program. But he does not have any knowledge about the database. Explain to him the following to get a better understanding of the DBMS concepts.
1. What is DBMS? Explain in brief.
2. Name any two database programs which can be used to create a table and store the data as per the requirement.
3. Which field can be set as a Primary Key?
4. Is it possible to make more than one field as a primary key in your table? (Yes/No). Justify your answer.