Question: Create Table PERSON ( San INT NOT NULL, Dno INT NOT NULL DEFAULT 1, Fname VarChar(20), Lname VarChar(20) NOT NULL, Super_ssn INT, PRIMARY KEY (Ssn),

Create Table PERSON ( San INT NOT NULL, Dno INT NOT NULL DEFAULT 1, Fname VarChar(20), Lname VarChar(20) NOT NULL, Super_ssn INT, PRIMARY KEY (Ssn), Foreign Key (Super_ssn) References Person (Ssn). Foreign Key (Dno) References Department (Dnumber) [ ] 1) When a value of the attribute Fname is missing, if a tuple is inserted with NULL for FName, a RDBMS server always replaces it with the special character for NULL. I 12) The Foreign Key attribute Super_ssn in the table PERSON can NOT be NULL at any case. [13) (Ssn, Super_ssn) can be a SuperKey of Table PERSON and a KEY of Table PERSON as well. []4) In three levels of the architecture of RDBMS, a RDBMS server stores and maintains Database Schema information (meta data) and data instances (all the record tuples) of the tables together in the same files in the file system of RDBMS. []5) Any Retrieval (Select) statement could change a valid state of database to an Invalid state. []6) Any DML (Data Manipulation Language) statement could change a valid state of database to an Invalid state. (17) Every tuple in a relation (Base Table) should be unique. [ ]8) Every SQL query result always returns unique tuples only. [ 19) A SQL query with a missing WHERE clause would return an Empty Result [ ] 10) The result of a SQL query using a Set Operator like Union, Intersect, or Except always returns unique tuples only
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
