Computers and Technology, 07.02.2021 14:00, school7067

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

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 23.06.2019 21:40, gaby06

Simon says is a memory game where "simon" outputs a sequence of 10 characters (r, g, b, y) and the user must repeat the sequence. create a for loop that compares the two strings. for each match, add one point to user_score. upon a mismatch, end the game. sample output with inputs: 'rrgbryybgy' 'rrgbbrybgy'

Answers: 3

continue

Computers and Technology, 25.06.2019 00:40, lexieprochaskaaa

Roger ginde is developing a program in supply chain management certification for managers. ginde has listed a number of activities that must be completed before a training program of this nature could be conducted. the activities, immediate predecessors, and times appear in the accompanying table: activity immediate predecessor(s) time (days) a -− 44b -− 55 c -− 11 d b 1010 e a, d 55 f c 55 g e, f 1010 calculate the slack time. show the details.

Answers: 2

continue

Computers and Technology, 25.06.2019 09:30, cheesecake1919

Evaluate the following code segment. what is the value of count after execution? int count = 1; for(int outer = 0; outer < 4; outer++) for(int inner = 1; inner < 3; inner++) count++; 1 3 9 12 13

Answers: 1

continue

Computers and Technology, 26.06.2019 00:00, lohnnaw4813

What might be the explanation for the following scenario? a user reports that it took a longer than usual amount of time to access a document. upon further investigation, the user tells you that the document he or she was attempting to access is from a budget report written two years ago.

Answers: 1

continue

Do you know the correct answer?

Section- Q. 6. Mr. Mohammed, a database administrator in “Al Saif Sports Institute” Has created the...