Question: If a field in a table is a foreign key referring to an auto - incrementing field, you must use an _ _ _ _

If a field in a table is a foreign key referring to an auto-incrementing field, you must use an _____ data type for the foreign key field.
Decimal
Autonumber
All of the other answers may be correct.
Integer
Varchar

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 Programming Questions!

Q:

If two tables have a relationship between themThen the field type data for the foreign key on the one table in the field data type for the primary key on the other table must be the same

Q:

ADM 1370 - Applications of Information Technology for Business - Winter 2022 - Assignment 3 Database Table Descriptions VOLUNTEERS Attribute Type Volunteer ID Number Volunteer_Last Name Short Text...

Q:

MY SQL MY SQL 2. Create a table named activityLevel with the following attributes, data types, and constraints: a. ID, integer, not null, auto increment b. exLevel, variable character, 25 characters,...

Q:

4 . 5 LAB - Implement supertype and subtype entities ( Sakila ) Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype...

Q:

4 . 1 4 LAB - Implement supertype and subtype entities ( Sakila ) Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype...

Q:

4 . 5 LAB - Implement supertype and subtype entities ( Sakila ) Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype...

Q:

4 . 5 LAB - Implement supertype and subtype entities ( Sakila ) Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype...

Q:

4 . 5 LAB - Implement supertype and subtype entities ( Sakila ) Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype...

Q:

4 . 5 LAB - Implement supertype and subtype entities ( Sakila ) Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype...

Q:

Similar entities have many common attributes and relationships. Similar entities are often converted into subtypes of a supertype entity, as illustrated in this lab. In the Sakila database, the...

Q:

When a company buys inventory for cash, total assets do not change. However, when it buys inventory on open account, total assets increase. Explain.

Q:

Some firms want to be environmentally friendly, even if "greener" production processes increase their costs. Consider two scenarios. In the first scenario, a "green" firm such as a renewable energy...

Q:

True or False? Current assets, interest rates, the time period, and cash flows in a relevant period are all figures used in a discounted cash flow analysis

Q:

The point (15, 16) is on the graph of y = f(x). a) A point on the graph of y = g(x), where g(x) = f(x) is b) A point on the graph of y = g(x), where g(x) = f(x+7) is c) A point on the graph of y =...