III SEM BCA SEP - DBMS Lab - A2 - Create a table CLIENT using SQL command and run queries on it.

Create a table CLIENT to store CLIENT_NO, NAME, ADDRESS, STATE, BAL_DUE. Client no must start with ‘C’. Apply the suitable structure for the columns. Specify Primary Key and NOT NULL constraints on the table. Insert 10 records. Write the following SQL queries: a) From the table CLIENT, create a new table CLIENT1 that contains only CLIENT_NO and NAME , BAL_DUE from specified STATE. Accept the state during run time. b) Create a new table CLIENT2 that has the same structure as CLIENT but with no records. Display the structure and records. c) Add a new column by name PENALTY number (10, 2) to the CLIENT d) Assign Penalty as 10% of BAL_DUE for the clients C1002, C1005, C1009 and for others 8%. Display Records e) Change the name of CLIENT1 as NEW_CLIENT f) Delete the table CLIENT2