Write a definition for function BUMPER( ) in C++ to read each object of a binary file GIFTS.DAT, find and display details of those gifts, which has remarks as “ÖN DISCOUNT”. Assume that the file GIFTS.DAT is created with the help of objects of class GIFTS, which is defined below:

class GIFTS
{
	int ID;char Gift[20],Remarks[20]; float Price;
public:
	void Takeonstock()
	{
		cin>>ID;gets(Gift);gets(Remarks);cin>>Price;
	}
	void See()
	{
		cout<<ID<<':'<<Gift<<':'<<Price<<':'<<Remarks<<endl;
	}
	char *GetRemarks(){return Remarks;}
}

Write a definition for function BUMPER( ) in C++ to read each object of a binary file GIFTS.DAT, find and display details of those gifts, which has remarks as “ÖN DISCOUNT”. Assume that the file GIFTS.DAT is created with the help of objects of class GIFTS, which is defined below:

class GIFTS
{
	int ID;char Gift[20],Remarks[20]; float Price;
public:
	void Takeonstock()
	{
		cin>>ID;gets(Gift);gets(Remarks);cin>>Price;
	}
	void See()
	{
		cout<<ID<<':'<<Gift<<':'<<Price<<':'<<Remarks<<endl;
	}
	char *GetRemarks(){return Remarks;}
}

Find the output of the following C++ code considering that the binary file MEM.DAT exists on the hard disk with a data of 1000 members.

class MEMBER
{
	int Mcode;char MName[20];
public:
	void Register();void Display();
};
void main()
{
	fstream MFile;
	MFile.open('MEM.DAT',ios::binary|ios::in);
	MEMBER M;
	MFile.read((char*)&M, sizeof(M));
	cout<<'Rec:'<<MFile.tellg()/sizeof(M)<<endl;
	MFile.read((char*)&M, sizeof(M));
	MFile.read((char*)&M, sizeof(M));
	cout<<'Rec:'<<MFile.tellg()/sizeof(M)<<endl;
	MFile.close();
}

Give a suitable example of a table with sample data and illustrate Primary and Alternate Keys in it.

Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:

TABLE: CARDEN

TABLE: CUSTOMER

Write SQL commands for the following statements:

1. To display the names of all the silver colored
2. To display name of car, make and capacity of cars in descending order of their sitting
3. To display the highest charges at which a vehicle can be hired from
4. To display the customer name and the corresponding name of the cars hired by them

Consider the following tables CARDEN and CUSTOMER and answer (b) and (c) parts of question:

TABLE: CARDEN

TABLE: CUSTOMER

Give the output of the following SQL queries:

1. SELECT COUNT(DISTINCT Make) FROM CARDEN;
2. SELECT MAX(Charges),MIN(Charges) FROM CARDEN;
3. SELECT COUNT(*),Make FROM CARDEN;
4. SELECT CarName FROM CARDEN WHERE Capacity=4;