subject

Section- Q. 6. Mr. Mohammed, a database administrator in “Al Saif Sports Institute” Has created the
following table named "GYM for the upcoming training schedule:
Table: GYM
PRICE BRANDNAME
ICODE INAME
C101
Power Fit Exerciser
120000
Power Gymea
G102
18000
Reliable
Aquafit Hand Grip
Cycle Bike
G103
Null
Ecobike
C104
Coscore
C105
Protoner Extrem Gym 30000
Message
Belt 5000
Crosstrainer
13000
Message Expert
C106
CTC Fitness
Help him in writing SQL query/command for the following purpose: :
i. To add a column duration with suitable data
type. ii. To display list of free Gym.
iii. To change the brandname to “Fit Trend India" of the item whose icode as "G104".
ix, To count and display the different BrandName

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 01:30
Consider the following statements: #include #include class temporary { private: string description; double first; double second; public: temporary(string = "", double = 0.0, double = 0.0); void set(string, double, double); double manipulate(); void get(string& , double& , double& ); void setdescription(string); void setfirst(double); void setsecond(double); }; write the definition of the member function set() so that the instance variables are set according to the parameters. write the definition of the constructor so that it initializes the instance variables using the function set() write the definition of the member function manipulate() that returns a decimal number (double) as follows: if the value of description is "rectangle", it returns first * second if the value of description is "circle" it returns the area of a circle with radius first if the value of description is "cylinder" it returns the volume of a cylinder with radius first and height second. hint: the volume of a cylinder is simply the area of the circle at the base times the height. if the value of description is "sphere" it returns the volume of the sphere with radius first. otherwise it returns -1.0;
Answers: 1
question
Computers and Technology, 24.06.2019 00:00
The gene form of a trait is called a(n) 
Answers: 2
question
Computers and Technology, 24.06.2019 04:30
Write and test a python program to find and print the largest number in a set of real (floating point) numbers. the program should first read a single positive integer number from the user, which will be how many numbers to read and search through. after reading in all of the numbers, the largest of the numbers input (not considering the count input) should be printed.
Answers: 1
question
Computers and Technology, 24.06.2019 17:00
Aman travel 200m towards east< br /> from his house then takes left< br /> to turn and moves 200 m north< br /> find the displacement & distance.< br />
Answers: 3
You know the right answer?
Section- Q. 6. Mr. Mohammed, a database administrator in “Al Saif Sports Institute” Has created the...
Questions
Questions on the website: 13722362