Home  >  Forum  >  Database
Post New Query

Can anyone help me in DBMS? I am not able to understand what the question mean?


joined on
October 13,2014
Asked on January 03,2015
Question: Consider the following relations for a database that keeps track of student enrollment in courses and the books adapted for each course:

STUDENT(SSN, Name, Major, Bdate)
COURSE (Course#, Cname, Dept)
ENROLL (SSN, Course#, Quarter, Book_ISBN)
TEST (Book_ISBN, Book_Title, Publisher, Author)

Specify the foreign keys for this schema, state if you have any assumption.
joined on
October 10,2013
Replied on January 04,2015

ENROLL (SSN)  is foreign key of  STUDENT(SSN) 
ENROLL (Course#)  is foreign key of  COURSE(Course#) 
ENROLL(Book_ISBN) is foreign key of TEST(Book_ISBN)

Hope, It will help you.

Write Answer








Copyright ©2017 concretepage.com, all rights reserved |Privacy Policy | Contact Us