Question

If the following appeared in a CREATE TABLE statement FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) true false - The jable bong crealed must have a column named PeolD true false -The CREATE TABLEWill fail becaue2 tables can ut have a field with the named PersonlD true false -personlD in thi table must be UNIQUE true false- There must be a diftorent table named Pasons Deviousl reated Record Answer
0 0
Add a comment Improve this question Transcribed image text
Answer #1

A foreign key is used to connect two tables.The foreign key in one table references the primary key of the another table( some case it can refer the primary key of the same table also).The table containing the primary key is parent and table containg the foreign key is child table.

FOREIGN KEY (PersonID) REFERENCES Persons(PersonID);

First PersonID is the foreign key column in the child table and Persons is the parent table .Persons(PersonID) indicates the primary key of parent table.

eg.CREATE TABLE Order (
    Oid int NOT NULL,
    Ono int NOT NULL,
    PersonID int,
    PRIMARY KEY (Oid),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);

The value of the foreign key either one of the value present in the parents tables primary column or it can be null.

1. The table being created must have a column named personid

True

2. The create table will fail because 2 tables can not have a field with the named personid

False

3. personid in this table must be unique.

false

foreignkey need not be unique.the only constraint is it must have value that is either present in parent table or it can be null.

4. There must be a different table named persons previously created

True

Since we are creating a link ,the parent table must be present before creating the foreign key references.

Add a comment
Know the answer?
Add Answer to:
If the following appeared in a CREATE TABLE statement FOREIGN KEY (PersonID) REFERENCES Persons(PersonID) true false...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 7- The values of a Foreign Key column in a table can be referenced to any...

    7- The values of a Foreign Key column in a table can be referenced to any column in a second table (Primary key or non-primary key). TRUE FALSE) 8- Using WITH GRANT OPTION clause will result in granting the user the authority to pass ONLY his/her privileges to other users. TRUE FALSE ) 9. To change the characteristics of a column, use the ALTER TABLE command with a SET clause. TRUE FALSE) 10- When inserting new values into a table...

  • A foreign key value must exist in the table where it is a primary key. True?...

    A foreign key value must exist in the table where it is a primary key. True? False?

  • Help Save & En s the following statement correct (true) or incorrect (false)j? with Big Data because querying related Tables (le. tables that are linked using Primary and Foreign Key Relation...

    Help Save & En s the following statement correct (true) or incorrect (false)j? with Big Data because querying related Tables (le. tables that are linked using Primary and Foreign Key Relationship containing Big Data requires more secondary memory than what current computers can support." True or Faise True False < Prey 25 of 2SⅢ Next> for working with large Data in tables within relational database MacBook Pro 5 6 8 9 0 0 Help Save & En s the following...

  • 8. True or False? 8.The primary key of the Employees table would be posted in the...

    8. True or False? 8.The primary key of the Employees table would be posted in the Production Steps table as a foreign key. 26.The primary key of the Production Steps table would be posted in the Production Plan table as a foreign key. 39. The link between the Products and Production Plan tables would be implemented as a linking table. 0.. Materials Production Steps 0... 0.. Production Plan Employees 0..* 1..1 1..1 Products are Products 0.. Production 0..* Authorization develope.

  • 1> Alter Table Department_JCS 2> Add Constraint Department_fk 3> Foreign Key (ManagerSSN) References Employee_JCS(EmployeeSSN) 4> GO...

    1> Alter Table Department_JCS 2> Add Constraint Department_fk 3> Foreign Key (ManagerSSN) References Employee_JCS(EmployeeSSN) 4> GO Msg 547, Level 16, State 1, Server DESKTOP-54BQ7EN\LOCALDB#743D77CD, Line 1 The ALTER TABLE statement conflicted with the FOREIGN KEY constraint "Department_fk". The conflict occurred in database "master", table "dbo.Employee_JCS", column 'EmployeeSSN'. How can I get rid of this problem and make a foreign key to with the given variables? Am I making a syntax error or is it something else?

  • The employee is table, the best candidate for primary key is Select one: a. Department ID...

    The employee is table, the best candidate for primary key is Select one: a. Department ID b. Employee hiredate c. Employee ID d. Employee salary Question 2 A primary key can be composed of more than one attribute. Select one: True False Question 3 A foreign key allows you to join two tables. Select one: True False Question 4 Given two tables, department (dept_id, dept_location, dept_name) and EMPLOYEE(emp_id, emp_name, emp_dept_id, emp_name, emp_salary), which attribute (column) is the foreign key? Select...

  • Database Concepts! please help Consider the following create table statements: create table R (a integer primary...

    Database Concepts! please help Consider the following create table statements: create table R (a integer primary key); create tables (b integer primary key, c integer references R(a) on update cascade); Assume that these tables have the following data inserted: R: (1) and (2) S: (1,1) and (2, 1) What happens when we want to delete the record (1) from R? The corresponding record from S and T will be deleted due to the cascade option Only the record in Rwill...

  • -- Schema definition create table Customer (     cid   smallint not null,     name varchar(20),    ...

    -- Schema definition create table Customer (     cid   smallint not null,     name varchar(20),     city varchar(15),     constraint customer_pk         primary key (cid) ); create table Club (     club varchar(15) not null,     desc varchar(50),     constraint club_pk         primary key (club) ); create table Member (     club varchar(15) not null,     cid   smallint     not null,     constraint member_pk         primary key (club, cid),     constraint mem_fk_club         foreign key (club) references Club,     constraint mem_fk_cust...

  • True or false? True or false? Question 63 Based on the Customer table below, which command...

    True or false? True or false? Question 63 Based on the Customer table below, which command lists all information from the table concerning customer 282? CustomerNum CustomerName --- Street City State Zip 148 Al's Appliance 28 Greenway Filmore FL 33336 282 Brookings 3827 Devon Grove FL 33321 Question 37 You have your project all set locally and on the server. You want to now make changes to your site. Which of the following is the last step of the process?...

  • Based on the CREATE TABLE statements, make an ER model of the database. Give suitable names...

    Based on the CREATE TABLE statements, make an ER model of the database. Give suitable names to the relationships. (Remember cardinality and participation constraints.) The diagram must use either the notation used in the textbook (and the lectures) or the crow’s foot notation. To save you some time: There are a few tables that include the following address fields: Address, City, State, Country and PostalCode (and the same fields with the prefix Billing-). You are allowed to replace these attributes...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT