1. Create Client_master with the following fields(ClientNO, Name, Address, City, State,
bal_due). Then
( a ) .Insert five records
( b ). Find the names of clients whose bal_due> 5000 .
( c ). Change the bal_due of ClientNO “ C123” to Rs. 5100
( d ) .Change the name of Client_master to Client12 .
( e ). Display the bal_due heading as “BALANCE”
To execute the mentioned operations, you would typically use SQL queries. Here's an example of how you can achieve these operations using SQL syntax:
(a) Create the Client_master table:
CREATE TABLE Client_master (
ClientNO VARCHAR(10),
Name VARCHAR(100),
Address VARCHAR(100),
City VARCHAR(100),
State VARCHAR(100),
bal_due FLOAT
);
(b) Insert five records:
INSERT INTO Client_master (ClientNO, Name, Address, City, State, bal_due)
VALUES
('C123', 'John Doe', '123 Main St', 'New York', 'NY', 6000),
('C124', 'Jane Smith', '456 Elm St', 'Los Angeles', 'CA', 4000),
('C125', 'Mike Johnson', '789 Oak St', 'Chicago', 'IL', 7000),
('C126', 'Lisa Brown', '321 Pine St', 'Houston', 'TX', 3000),
('C127', 'Sarah Davis', '654 Maple St', 'Seattle', 'WA', 8000);
(c) Find the names of clients whose bal_due > 5000:
SELECT Name FROM Client_master WHERE bal_due > 5000;
(d) Change the bal_due of ClientNO 'C123' to Rs. 5100:
UPDATE Client_master SET bal_due = 5100 WHERE ClientNO = 'C123';
(e) Change the name of Client_master to Client12:
ALTER TABLE Client_master RENAME TO Client12;
(f) Display the bal_due heading as 'BALANCE':
SELECT bal_due AS BALANCE FROM Client12;
Note: The implementation may vary depending on the specific SQL database management system you are using.