SQL assignment

Executed SQL database operations by creating a table featuring CHECK and DEFAULT constraints, along with another table that includes various data types (INT, VARCHAR, CHAR, NVARCHAR, FLOAT, DOUBLE, NUMERIC, DATE, DATETIME) while inserting sample records. Additionally, a table with an IDENTITY column was created, and DELETE and TRUNCATE operations were performed to observe the behavior of the identity values. A table with a computed column was also established, alongside two tables—one containing a PRIMARY KEY and the other a FOREIGN KEY. Attempts were made to insert records into the foreign key table that do not exist in the primary key table, as well as to insert NULL values. The CASCADE command was practiced, and ALTER TABLE operations were conducted to modify data types, rename columns, add new columns, drop existing columns, and remove constraints.