Question: A foreign key A) must be either null or a primary key in another table. B) must be a primary key in another table and

A foreign key

A) must be either null or a primary key in another table.

B) must be a primary key in another table and cannot be null.

C) may be a primary key or a non-key attribute in another table.

D) may be a non-key attribute in another table and cannot be null.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

1. In a Relational Database, there are several vital rules in the creation of the RDBMS that must be met for a database to be well designed. The rule that a foreign key can be null or must represent...

Q:

Please answer! will upvote Given here is a SQL script create table course( cid varchar(10), name varchar(50), prof integer ); create table student( gid integer, fname varchar(25), lname varchar(25),...

Q:

Answer the true / false questions below, providing a brief explanation of your answers. You will not receive marks for answers without explanation. Relations that are in 3 NF must also be in BCNF . (...

Q:

Which of the following describes referential integrity? A primary key of a relational table must not contain a null value The value for a foreign key attribute must either be null or match one of the...

Q:

Which of the following describes referential integrity? A primary key of a relational table must not contain a null value The value for a foreign key attribute must either be null or match one of the...

Q:

-- create database and tables create database expandedbookbiz go use expandedbookbiz go create table authors ( au_id char(11) not null primary key, au_lname varchar(40) not null, au_fname varchar(20)...

Q:

This SQL script is not executing for some reason please help IF OBJECT_ID( 'TCourseStudents' ) IS NOT NULL DROP TABLE TCourseStudents IF OBJECT_ID( 'TCourses' ) IS NOT NULL DROP TABLE TCourses IF...

Q:

construct an ESG of the college database for the entities specified above. Write SQL statements to create these tables in your schema of the class database. You may add additional attributes to the...

Q:

SQL Exercise Using the given query below and write queries (with subqueries) to answer the following questions. 1. Which publishers haven't published a cook book? 2. Which publisher has the highest...

Q:

1. Which publishers haven't published a cook book? 2. Which publisher has the highest priced book? 3. Which titles have more than one author (show the title)? 4. Which titles don't have an author?...

Q:

A 20.0 cm à 30.0 cm rectangular loop of wire carries 1.0 A of current clockwise around the loop. (a) Find the magnetic force on each side of the loop if the magnetic field is 2.5 T out of the...

Q:

Produce an automorphism of P2 other than the identity map, and other than a shift map p(x) p(x - k).

Q:

What is a disactvantage of the global caphai markett Miniple Choice The cost of captel is more in a globel merket then e domestic matrt Foreign imvestments may be diven by speculative fows in the...

Q:

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Q:

=+j Explain the balance sheet approach, as well as other approaches, of

Q:

=+j Distinguish between global remuneration and international assignment C&B.

Q:

=+Outline the basic objectives of global compensation and benefi ts (C&B).