What are instances and schema? DBMS

Instances: A database is generally used by many users where insertion and deletion of data occurs frequently. Overall information stored in a database at a particular moment is called the instance of the database. 


Schemas: The overall design of a database which includes the data structures, table designing and relation of data from table to table based on queries etc is called the database schema.

What is data model? Describe various data models. DBMS

Author: Tanmay Chakrabarty

Tanmay Chakrabarty is a former CSE student, currently working as a Senior Software Engineer with 5+ years of experience in the field of Web Application development in PHP+MySQL platform with strong skills in Javascript, JQuery, JQuery UI and CSS. He tries to write notes every week but fails due to heavy loads of duty.

Recommended Recommends

Comments

Contact Us