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

Another question on Computers and Technology

Computers and Technology, 22.06.2019 05:00

Write a loop that reads positive integers from standard input and that terminates when it reads an integer that is not positive. after the loop terminates, it prints out, on a line by itself and separated by spaces, the sum of all the even integers read, the sum of all the odd integers read, a count of the number of even integers read, and a count of the number of odd integers read, all separated by at least one space. declare any variables that are needed. assume the availability of a variable, stdin, that references a scanner object associated with standard input. that is, stdin = new scanner(system.in); is given.

Answers: 3

Answer

Computers and Technology, 22.06.2019 10:30

Auniversity wants to install a client-server network. which feature do you think is important for them as they set up the network? sending email blocking multiple people to use the same file low security low set up cost limited access to files

Answers: 1

Answer

Computers and Technology, 22.06.2019 22:00

Discuss the ways in which electronic information associated with payments is addressed in terms of security. include encryption, secure sockets layers, and secure electronic transactions in your discussion. are there any other ways that consumers and businesses can keep their payment information secure in an electronic commerce environment? do you feel that your information is safe when conducting electronic business? why or why not?

Answers: 1

Answer

Computers and Technology, 23.06.2019 15:00

Idon’t understand the double8 coding problem. it is java

Answers: 1

Answer

You know the right answer?

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

Questions