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.
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