562 views
0 votes
0 votes
What is the difference between Subschema, View and Virtual table in DBMS?

please explain!!

1 Answer

0 votes
0 votes

Subschema: A subschema lets the user have access to different areas of applications in which the user designed. The areas that are included in an application are set, types, record types, data items, and data aggregates. Schemas may have many different subschemas' that are all very different.

View and Virtual table: 

In SQL, a view is a virtual table based on the result-set of an SQL statement.

A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real tables in the database.

You can add SQL functions, WHERE, and JOIN statements to a view and present the data as if the data were coming from one single table.

https://sqlite.org/lang_createvtab.html (This link for virtual table). Please correct me if I m wrong at any point. Yeah. :)

Related questions

11 votes
11 votes
3 answers
1
rahul sharma 5 asked Jul 9, 2017
10,411 views
Number of schedules view equal to following schedule :- r1(A), w1(B), r2(A), w2(B), r3(A), w3(B)
0 votes
0 votes
0 answers
2
Shrenik Pradhan asked Nov 16, 2023
179 views
How can I represent the ER model in tabular form? , in java point, the tabular form doesn't seem to be correct.Ref. https://www.javatpoint.com/dbms-reduction-of-er-diagra...
0 votes
0 votes
1 answer
3
3 votes
3 votes
1 answer
4
ashish pal asked Jan 25, 2018
459 views
Answer given is 3But my answer is 2 . I have combined the Department and Project relation since the participation of Project was total.please someone explain why can't we...