Question

create a database "Bank"and then create a table customer in the database with the following fields (assign appropriate data types ).Insert records in the table as shown here.<br /><br />●create a query to display names of customers from delhi <br />●create a query to display names of customers from chennai whose balance is more than rs2000<br />Acc.no. Name city balance (in rs )<br />1 george delhi 10,000<br />2 mary mumbai 50,000<br />3 Sam delhi 6000<br />4 sarah kolkata 7,500<br />5 robert chennai 8,000<br />6 peter delhi 19,000<br />7 rachel mumbai 20,000<br /><br />​

Answer 1

Step I

Before going ahead with database design you should know about :

1) Database Keys :

Keys are very important part of Relational database. They are used to establish and identify relation between tables. They also ensure that each record within a table can be uniquely identified by combination of one or more fields within a table.

For example you should know about primary key , composite primary key , foreign key , candidate key.