Question: Use SQL for the following 1. Create table Student (ROLL_NO, SNAME, MATHS, CHEM, PHY) with appropriate date types for columns 2. Insert five rows into

Use SQL for the following

1. Create table Student (ROLL_NO, SNAME, MATHS, CHEM, PHY) with appropriate date types for columns
2. Insert five rows into the table Student.
3. Calculate the total of marks and add column TOTAL to Student table.
4. Set the values of TOTAL for each row.
5. Calculate the average of marks and add column AVERAGE to Student table.
6. Set the values of AVERAGE for each row.

Step by Step Solution

★★★★★

3.42 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

1 CREATE TABLE IF NOT EXISTS Student ROLLNO int11 NOT NULL AUTOINCREMENT SNAME varchar255 NO... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Computer Engineering Questions!

Use SQL for the following 1. Create table CUSTOMER with following details; 2. Insert rows shown in Fig. 1. 2. Add a column called "Gender" in CUSTOMER 3. Add a column called "Email" and another...

Create a 3 2 contingency table with row totals of 25, 30, and 25 and column totals of 30 and 50. How many table cell counts are truly free (i. e., what is the smallest number of table cell counts...

Create a stored procedure named prc_new_rental to insert new rows in the RENTAL table. The procedure should satisfy the following conditions. a. The membership number will be provided as a parameter....

Write SQL commands for the following: a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table. b. Now write a command...

For the following shipment create a basic pallet plan to hold all of the cargo listed. Calculate the chargeable weight of the palletized load for each truck, air and ocean modes of transport. Then,...

SQL allows a foreign-key dependency to refer to the same relation, as in the following example: create table manager (employee-name char (20), manager-name char(20), primary key employee-name,...

Create a set of use cases for the following high-level requirements in a housing system run by the Campus Housing Service. The Campus Housing Service helps students find apartments. Owners of...

Create a set of use cases for the following system: A Real Estate, Inc. (AREI), sells houses. People who want to sell their houses sign a contract with AREI and provide information on their house....

Create a set of use cases for the following system: A Video Store (AVS) runs a series of fairly standard video stores. Before a video can be put on the shelf, it must be catalogued and entered into...

Create a set of use cases for the following system: Of-the-Month Club (OTMC) is an innovative young firm that sells memberships to people who have an interest in certain products. People pay...

The charts show results of studies on four-year colleges in the United States. You want to portray your college in a positive light for an advertising campaign designed to attract high school...

In two to three paragraphs use the examples in this module (Col Howard, LtCol Gadson, Flight 93, Heather Penney) to answer the following questions: 1. Does your sense of duty cr-eate your values or...

A disadvantage of small Latin squares designs is that they provide relatively small degrees of freedom, so , if tends to be desirable to replicate them to increase the error degrees of freedom?

3 . ) What is the time of completion, and why must it be clearly stated in the contract agreement provisions?

Let x represent the number of tails when a fair coin is flipped 100 times. a) Compute the distribution of x and represent it using a bar plot. b) Calculate the mean (expected value) and the standard...

What is the primary reason we have developed and employ an expansive body of knowledge of project management today?

6.4 Boolean functions Functions can return booleans, which is often convenient for hiding complicated tests inside functions. For example: def is_divisible(x, y): if x % y == 0: return True else:...

An access route is being constructed across a field (Figure Q8). Apart from a relatively firm strip of ground alongside the field's longer side AB, the ground is generally marshy. The route can...

Take one simple random sample of size 40 from the ChiSq data. a. Take 1000 resamples (1000 samples of 40 observations with replacement from the one simple random sample). b. Calculate the mean of...

Use the technology instructions provided on the CD to check your answers. Submit the software output. A p-value for each F- statistic is provided. State your conclusions about each of the...

In Question 24 of the extended activities regarding the ELISA test data, you found that the probability that a randomly selected person who tests positive for HIV (the first time) actually has the...

A corporation makes CV joints for automobiles. An integral part of CV joints is the bearings that allow the joints to rotate differentially. One application utilizes six bearings in a CV joint that...

Canidae Corporation, based in San Luis Obispo, California, is a producer of pet food. One of its products is Felidae cat food. The Chicken and Rice Cat and Kitten Formula is a dry cat food that comes...

The Fillmore Institute has established a service designed to help charities increase the amount of money they collect from their direct-mail solicitations. Its consulting is aimed at increasing the...