Create a
small BankAccount database with one table storing account details. The Account
table...

Question

Create a
small BankAccount database with one table storing account details. The Account
table should have fields for account number, customer last and first names, and
current balance. The type of database (SQL Server or Access) will be determined
by your instructor. Populate the table with 8–10 records. Design and create a
user interface that will enable you to display all customer records.

Kshitij · Accepted Answer

DATABASE -
DROP TABLE IF EXISTS `members`;
CREATE TABLE `members` (
`memberId` bigint(20) NOT NULL AUTO_INCREMENT,
`firstname` varchar(255) NOT NULL DEFAULT '',
`lastname` varchar(255) NOT NULL DEFAULT '',
`relationship` varchar(255) NOT NULL DEFAULT '',
`hometown` varchar(255) NOT NULL DEFAULT '',
`age` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`memberId`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
INSERT INTO `members` VALUES (1,'anmol','rai','brother','delhi',23);
INSERT INTO `members` VALUES (2,'sandip','nepal','sister','nepal',23);
INSERT INTO `members` VALUES (3,'rahul',

Create a small BankAccount database with one table storing account details. The Account table should have fields for account number, customer last and first names, and current balance. The type of...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment