This topic contains 0 replies, has 0 voices, and was last updated by  EduGorilla 2 years, 6 months ago.

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


    Consider the following set of relation schemas
    STUDENTS (ROLLNO, NAME, DOB, AGE)
    ENROLL (ROLLNO, COURSENO)
    COURSES (COURSENO, COURSENAME, INSTRUCTOR)
    GRADES (ROLLNO, COURSENO, GRADE)
    Consider the following FD’s and tell the normal form in which the relations exist.
    FD1: DOB AGE
    FD2: NAME ROLLNO
    FD3: ROLLNO NAME
    FD4: COURSENO COURSENAME
    FD5: COURSENO INSTRUCTOR
    FD6: (ROLLNO, COURSENO) GRADE
    FD7: ROLLNO COURSENO
    FD8: COURSENO ROLLNO

    Options :-

    1. 2NF but not in 3NF
    2. 3NF but not in BCNF
    3. In BCNF
    4. None of the above
    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: Consider the following set of relation schemas STUDENTS (ROLLNO, NAME, DOB, AGE) ENROLL (ROLLNO, CO….
Your information:




Verify Yourself




Log in with your credentials

or    

Forgot your details?

Create Account