Field name and data type must be followed as such given in the schema diagram.There should not be any spelling mistakes in the field namesIf you specified wrong field name or missed any field name while creating the table, but if there is no syntax error then obviously the table will get created but it will not get Accepted.In this case, drop the table and recreate it again with correct field names and get it Accepted.

Write a query to create 'building' table.Hint: Refer the schema diagram for the field names and its data type of the table.Note:This ‘building’ table got foreign key reference. You no need to create building_type table. It is already created for you.Field name and data type must be followed as such given in the schema diagram.There should not be any spelling mistakes in the field namesIf you specified wrong field name or missed any field name while creating the table, but if there is no syntax error then obviously the table will get created but it will not get Accepted.In this case, drop the table and recreate it again with correct field names and get it Accepted.

Write a query to create a table named  'station'.Hint: Refer the schema diagram for the field names and its data type of the table.Note:Field name and data type must be followed as such given in the schema diagram.There should not be any spelling mistakes in the field namesIf you specified wrong field name or missed any field name while creating the table, but if there is no syntax error then obviously the table will get created but it will not get Accepted.In this case, drop the table and recreate it again with correct field names and get it Accepted.QUERY

The table is NOT getting created, identify the reason.

In the relational database model, each table name must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are the same.Select one:TrueFalse

Write a query to rename table 'station' to 'station_details'.Note:This ‘station’ table perform operation on ‘station’ table. So ensure the table ‘station’ already created and exists in the database.If you get an error like ‘station’ does not exist. Then go back to first query and execute that create table query once and come back to this query.Table name to be renamed and the new table name must be specified without any mistake.If you specified wrong table name while creating the table, but if there is no syntax error then obviously the table will get altered but it will not get Accepted.In this case, rename the table again with correct query and get it Accepted.