Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Explain view in RDBMS?
View - A view is a relation (virtual rather than base) and could be used in query expressions, which is, queries can be written by using the view as a relation. Instead, a view is a named table in which is represented, not through its own physically separate stored data, but through its definition in terms of other named tables (base tables or views). The base relations on that a view is based are sometimes known as the existing relations. The definition of a view in a create view statement is stored within the system catalog. The syntax to create a view is:
CREATE [OR REPLACE] VIEW [()] AS
WITH {READ ONLY|CHECK OPTION [CONSTRAINT
]};
FDs in Entities : Student entity : Enrolment number → Student name, Address Course Entity :
Example: Consider the following relations: ROLLNO NAME ADDRESS COURSE_ID 100 Ka
In E-R Diagram how derived attribute are represented ? In E-R Diagram By Dashed ellipse derived attribute are represented.
imagery
What is the difference between link and reference? The fundamental difference between links and references is that links are symmetrical on the other hand references refer only
Multi-list file Organisation Multi-list file organisation is a multi-index linked file organisation. A linked file organisation is a logical organisation where physical orderin
Draw the database using the ER approach and then make the tables accordingly. Populate the tables so that every table have at least 10 tuples. Then using Java and SQL, execute the
The ABC Bank authority now wants to create a database for their customers. So you are requested to modify your program of Assignment A3 as follows. The main program first displa
Draw an EER diagram that captures the "is-a" hierarchy of students in another simple database. The database captures both the "basic" information (say, student ID and student name)
what is correlation in nested query
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd