View is a virtual table with no data of its own, but can be operated like any other table. It is like a window through which you can view data of another table, which is called the base table. syntax: CREATE VIEW table_name as SELECT statement ;
Views can be created in a database using the CREATE VIEW key wordEx:CREATE VIEW view_name ASSELECT column_name(s)FROM table_nameWHERE conditions
The first object that must be created in a database is the database itself. It serves as the foundational structure that holds all other objects, such as tables, views, and indexes. Without the database, there would be no environment to store and manage these additional objects.
the ---- of a database presents the views that the end user have
Database Nation was created in 2000.
The autism database - was created in 2010.
Gypsy - database - was created in 2010.
BioModels Database was created in 2005.
Gadfly - database - was created in 1994.
Hibari - database - was created in 2010.
ThYme - database - was created in 2010.
PANDIT - database - was created in 2006.
Domine Database was created in 2010.