SQL Query Assignments
-------------------------- ASSIGNMENT - 1 --------------------------- Create the following tables using SQL Server Management Studio. Table Name : flatMaster About this table: The flatMaster table is a master table which holds all the details related to all the flats in the apartment. This table has got flatNo as primary key as there is no duplicate flat numbers in the apartment. Flat numbers are written/captured in such a way that they give meaning to block number and flat number. A101 gives the meaning as , this belongs to block 'A' and then number of the flat is 101. Field Name Field Type Constraints (if any) Description flatNo varchar(10) PRIMARY KEY This field contain the flat number. This would an alphanumeric value. For example : A303 (means block A and flat no. 303) floorNo smallint NA Floor number. For example : 1 , 2, 3 block ...