Create a small Family database with one table to include data about members of your family. Include...

Question

Create a small Family database with one table to include data about members of your family. Include data fields such as family member number, first name, last name, type of relationship, hometown, and age. You can be creative with the family member number or use the autogenerated number from the database. It must be a unique value; each member of your family must have a different family member number. Populate the database with members of your family. Be sure to include data about yourself in the table. Place at least 10 records in your database table, even if it is necessary to make up information. The type of database (SQL Server or Access) will be determined by your instructor. Write a C# program to display all of the data that appears in the database table on a data grid.

Aditi · Accepted Answer

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','kumar','father','raebareli',52);
INSERT INTO `members` VALUES (4,'akash','tripathi','mother','faizabad',20);
INSERT INTO `members` VALUES (5,'abhishek','pandey','brother','ghaziabad',18);

Create a small Family database with one table to include data about members of your family. Include data fields such as family member number, first name, last name, type of relationship, hometown, and...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment