The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
0 votes
16 views

Consider the relation schemas are shown below, which were generated
from the E-R diagram in Figure given below. For each schema, specify what foreign key
constraints, if any, should be created.

teaches (ID, course id, sec id, semester, year)
takes (ID, course id, sec id, semester, year, grade)
prereq (course id, prereq id)
advisor (s ID, i ID)
sec course (course id, sec id, semester, year)
sec time slot (course id, sec id, semester, year, time slot id)
sec class (course id, sec id, semester, year, building, room number)
inst dept (ID, dept name)
stud dept (ID, dept name)
course dept (course id, dept name)

 

asked in Databases by Boss (10.2k points) | 16 views

Please log in or register to answer this question.

Related questions

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
49,814 questions
54,521 answers
188,388 comments
75,424 users