dept - PowerPoint PPT Presentation

1 / 1
About This Presentation
Title:

dept

Description:

... (SSN, profname, deptname, salary) course(coursename, deptname, profSSN, ... TA(SSN, Taname, deptname, salary, tacourse) guides(TA_SSN, student_SSN, coursename) ... – PowerPoint PPT presentation

Number of Views:20
Avg rating:3.0/5.0
Slides: 2
Provided by: viswanat
Category:
Tags: dept | guide | salary

less

Transcript and Presenter's Notes

Title: dept


1
Works_for
teaches
prof
languages
Ta_for
employsTA
TA
dept
course
Belongs_to
helps
student
Relations
offers
  • dept(deptname, addr_num, addr_street)
  • prof(SSN, profname, deptname, salary)
  • course(coursename, deptname, profSSN, time)
  • student(SSN, studentname, deptname)
  • TA(SSN, Taname, deptname, salary, tacourse)
  • guides(TA_SSN, student_SSN, coursename)
  • speaks(TA_SSN, language)

F-K constraints prof(deptname) -gt
dept(deptname) guides(coursename) -gt
course(coursename) course(deptname) -gt
course(coursename) etc.
Write a Comment
User Comments (0)
About PowerShow.com