A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781337668880
Author: Pratt
Publisher: Cengage
Question
Book Icon
Chapter 2, Problem 16RQ
Program Plan Intro

Functional dependencies:

Functional dependency is a term in the relational database theory which refers to a constraint that is located in between the two sets of attributes in a relation from a database. The functional dependencies of the given database are as follows.

  • DEPARTMENT_NUM à DEPARTMENT_NAME
  • ADVISOR_NUM à ADVISOR_LAST_NAME, ADVISOR_FIRST_NAME, DEPARTMENT_NUM
  • COURSE_CODE à DESCRIPTION
  • STUDENT_NUM à STUDENT_LAST_NAME, STUDENT_FIRST_NAME, ADVISOR_NUM
  • STUDENT_NUM, COURSE_CODE à GRADE

Relations:

The term relation refers to the relationship between the data represented in a row-column format. The relative relations for the given database table is as follows:

  • DEPARTMENT (DEPARTMENT_NUM, DEPARTMENT_NAME)
  • ADVISOR (ADVISOR_NUM, ADVISOR_LAST_NAME, ADVISOR_FIRST_NAME, DEPARTMENT_NUM)
  • COURSE (COURSE_CODE, DESCRIPTION)
  • STUDENT (STUDENT_NUM, STUDENT_LAST_NAME, STUDENT_FIRST_NAME, ADVISOR_NUM)

 For the database, a new relation is defined as it is mentioned that an advisor can advise any number of students but each student has only one advisor. Therefore, it can be defined as follows:

 STUDENT_COURSE (STUDENT_NUM, COURSE_CODE, GRADE)

The above relations are defined for the condition when an advisor can advise any number of students but the student can have only one advisor. Therefore, it clearly represents that the relation between the advisor and the student is many-to-one relation.

Blurred answer
Students have asked these similar questions
I need help to resolve the case, thank you
In 32-bit MSAM, You were given the following negative array. write a program that converts each array element to its positive representation. Then add all these array elements and assign them to the dl register. .data    myarr sbyte -5, -6, -7, -4.code     ; Write the rest of the program and paste the fully working code in the space below.   the dl register should have the value 22 after summing up all elements in the array.
Microprocessor 8085 Lab Experiment Experiment No. 3 Logical Instructions Write programs with effects 1. B=(2Dh XOR D/2) - (E AND 2Eh+1) when E=53, D=1Dh 2. HL= (BC+HL) XOR DE (use register pair when necessary), when BC=247, HL 516, DE 12Ach 3. Reset bits 1,4,6 of A and set bits 3,5 when A=03BH Write all as table (address line.hexacode,opcede,operant.comment with flags)
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
MIS
Computer Science
ISBN:9781337681919
Author:BIDGOLI
Publisher:Cengage
Text book image
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L
Text book image
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Text book image
C++ for Engineers and Scientists
Computer Science
ISBN:9781133187844
Author:Bronson, Gary J.
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning