Awesome q2a theme
0 votes
8 views
R = {Student ID, Last Name, First Name, Course ID, Course Section, Course Name, Grade, Professor Last Name, Professor First Name, Bldg, Office #, Semester} with following functional dependencies
FD1 = Student ID --> Last Name, First Name
FD2 = Student ID, Semester, C_ID, C_Section --> C_Name, Grade
FD3 = Semester, C_ID, C_Section --> Prof_LName, Prof_FName, Bldg, Office#
CONVERTING IT TO 2NF IM GETTING THREE TABLES BUT ANSWER IS GIVEN AS 4 TABLES. PLEASE HELP ME.
in Databases by (6 points) | 8 views

Please log in or register to answer this question.

Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
Welcome to GATE CSE Doubts, where you can ask questions and receive answers from other members of the community.
Top Users Jul 2020
  1. Shaik Masthan

    39 Points

  2. hiteshpujari

    9 Points

  3. fazin

    7 Points

  4. srestha

    7 Points

  5. gaurav2697

    6 Points

  6. Venkatesh Akhouri

    6 Points

  7. Meghana518

    6 Points

  8. athenahermes

    6 Points

  9. bittujash

    6 Points

  10. Pawan_k

    6 Points

7,560 questions
1,783 answers
10,868 comments
90,492 users