Simple overview on Database,
Schema and Tables
Hello to all visitors, Good day. We can read
a lot about the database and schema throughout a day. But, I skimmed the
concept for our easy understanding. To get more ideas, you can access other websites
where plenty of explanations are available.
Database is a collection of organized data
which can be related to each other.
The description of a database is called schema.
Database is like a main folder or a big container which contains all the
schemas in it and schemas are like subfolders within a database folder which
are mainly used to group objects together logically where we can easily reach
and fetch specific data from the vast amount of stored data. Here object refers
to a table, views etc.
Tables are the most significant component of
a relational database and there are other components such as views where it can
be used mostly to view the particular data pulled from some tables. For
example, the viewers will be given selected names of customers and their passwords
will not be provided or displayed in views due to security reasons. Views are
temporary stuffs where there is no memory is allocated for it in a database.
Inside schemas, there may be one or more
tables that comprises of rows and columns. Rows can also be called as records
and columns can also be called as attributes.
Thank you for reading the
article.
No comments:
Post a Comment