This topic contains 0 replies, has 0 voices, and was last updated by  EduGorilla 1 year, 11 months ago.

  • Author
    Posts
  • #1440501 Reply
     EduGorilla 
    Keymaster
    Select Question Language :


    Suppose R & S are two relations, R (A, B, C) and S (A, C, D). Here, A in relation S is the foreign key (on Delete cascade) referencing to the primary key of relation R. Number of tuples in relation R & S are 100 and 200 respectively. Also, the no of times ‘A’ value can be repeated in S is maximum 5 times. Suppose an update was made, and three values (any random value) of A in R get deleted. What is the range of maximum no. of tuples in natural join of R & S?

    Options :-

    1. 100 to 200
    2. 0 to 200
    3. 100 to 185
    4. 185 to 200
    Post your Training /Course Enquiry
    Are You looking institutes / coaching center for
    • IIT-JEE, NEET, CAT
    • Bank PO, SSC, Railways
    • Study Abroad
    Select your Training / Study category
Reply To: Suppose R & S are two relations, R (A, B, C) and S (A, C, D). Here, A in relation S is the forei….
Your information:




Verify Yourself




Log in with your credentials

or    

Forgot your details?

Create Account