Identify primary keys and foreign keys for the following tables. Also, specify tables referenced by the foreign key. If a table does not have a foreign key, leave the entry blank. (Note: Some tables have composite primary key. Identify all composite key attributes for such tables.)

STUDENT
FACULTY
COURSE
CRSSECTION
REGISTRATION
ROOM
TERM
LOCATION
MAJOR
DEPARTMENT


Computer Science & Information Technology

You might also like to view...

Which of the following is a valid assignment, given the following declarations?

float *s; float *t; a) s = 50.0; b) t = 2000; c) s = s * 2; d) s = t;

Computer Science & Information Technology

What is the purpose of HTML5, semantic markup?

What will be an ideal response?

Computer Science & Information Technology

_______________ assistants on the latest smartphones and tablets enable quick, vocal interaction to accomplish common goals.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

Software defined networking (SDN) cuts the control plane of individual devices out of the picture and lets an all-knowing program called a __________ controller dictate how both physical and virtual network components move traffic through the network.

A. network B. slave C. primary D. secondary

Computer Science & Information Technology