Person (
aadhaar CHAR(12) PRIMARY KEY,
name VARCHAR(32));
Customer (
name VARCHAR(32),
email VARCHAR(32) PRIMARY KEY,
phone CHAR(10),
aadhaar CHAR(12),
FOREIGN KEY (aadhaar) REFERENCES Person(aadhaar));
Which of the following statements is/are correct?
This solution analyzes the properties of the $Person$ and $Customer$ relations based on the provided schema definitions to determine the correctness of the given statements.
The analysis identifies statements concerning the allowance of NULL values for the 'phone' field in the 'Customer' table and the status of 'aadhaar' as a candidate key in the 'Person' table as accurate based on standard SQL rules and the provided schema.