World's most popular travel blog for travel bloggers.

What is meant by the term view in context of DBMS? Why is it used? Consider the following

, , No Comments
What is meant by the term view in context of DBMS? Why is it used? Consider the following student schema: Student( S-ID, S-Name, S-Program) Course(C-Code, C-Name) Enrolled( S-ID, C-Code) 
Create a view for a student who’s S-ID is 2017001 which show the list of all the courses registered by the student in a program. The list should show C-Code, C-Name and S-Program. Explain any four constraints for updating a tuple in a view. 

0 comments:

Post a Comment

Let us know your responses and feedback