Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course:

STUDENT (SSN, Name, Major, Bdate)
COURSE (Course#, Quarter, Grade)
ENROLL (SSN, Course#, Quarter, Grade)
BOOK_ADOPTION (Course#, Quarter, Book_ISBN)
TEXT (Book_ISBN, Book_Title, Publisher, Author)

Specify the foreign keys for this schema, stating any assumptions you make.

The schema of this question has the following four foreign keys:

3. the attribute SSN of relation ENROLL that references relation STUDENT,

4. the attribute Course# in relation ENROLL that references relation COURSE,

5. the attribute Course# in relation BOOK_ADOPTION that references relation COURSE, and

6. the attribute Book_ISBN of relation BOOK_ADOPTION that references relation TEXT.

We now give the queries in relational algebra:

Computer Science & Information Technology

You might also like to view...

Analyze the following code:

``` double[] array = {1, 2, 3}; ArrayList list = new ArrayList<>(Arrays.asList(array)); System.out.println(list); ``` a. The code is correct and displays [1, 2, 3]. b. The code is correct and displays [1.0, 2.0, 3.0]. c. The code has a compile error because an integer such as 1 is automatically converted into an Integer object, but the array element type is Double. d. The code has a compile error because asList(array) requires that the array elements are objects.

View
Computer Science & Information Technology

Which of the following can you not save separately?

A) Custom theme B) Custom colors C) Custom fonts D) Custom theme effects

View
Computer Science & Information Technology

Unlike the default format for text in a text box, the default alignment for shapes with text in them is _____ text.

A. left-aligned B. right-aligned C. center-aligned D. top-aligned

View
Computer Science & Information Technology

Which acronym refers to the file structure database that Microsoft originally designed for floppy disks?

a. NTFS b. FAT32 c. VFAT d. FAT

View
Computer Science & Information Technology