submission of SQLAssignment1

Performed SQL database operations by creating a table with CHECK and DEFAULT constraints, and another with various data types (INT, VARCHAR, CHAR, NVARCHAR, FLOAT, DOUBLE, NUMERIC, DATE, DATETIME) while inserting sample records. Create a table with an IDENTITY column, execute DELETE and TRUNCATE operations, and observe identity behavior. Additionally, create a table with a computed column, and establish two tables—one with a PRIMARY KEY and another with a FOREIGN KEY. Attempt to insert records into the foreign key table that do not exist in the primary key table and try inserting NULL values. Practice the CASCADE command, and perform ALTER TABLE operations to change data types, rename columns, add new columns, drop existing columns, and remove constraints.