In Microsoft Access, relationships between tables are created in ...

[cdr_15]

In Microsoft Access, relationships between tables are created in the Relationships window.
 
  Indicate whether the statement is true or false

Question 2

Explain two methods for defining a primary key using SQL.
 
  What will be an ideal response?

[daiying98]

Answer to Question 1

TRUE

Answer to Question 2

A primary key may be defined by either the CREATE TABLE column description method or the CONSTRAINT phrase method. To create a primary key using the CREATE TABLE column description method, the primary key must be a single attribute. For the primary key attribute, the column property is specified to be PRIMARY KEY. There can be only one attribute specified as PRIMARY KEY with the CREATE TABLE column description method. This means that the creation of a composite key requires the use of the CONSTRAINT phrase method. Defining a primary key using the CONSTRAINT phrase requires that the column or columns that will serve as the primary key must have been defined as NOT NULL. Using the CONSTRAINT phrase method, the primary key is defined by adding a constraint to the table using a CONSTRAINT phrase after the table columns have been defined. The CONSTRAINT phrase names the column or columns that will be the table's primary key. The structure of the CONSTRAINT phrase is:

CONSTRAINT ConstraintName PRIMARY KEY (column names)

[cdr_15]

Thanks for the timely response, appreciate it

[ryansturges]

Excellent