Solution-Names of students in an ascending order

Names of students in an ascending order

Assignment Help Basic Computer Science

Reference no: EM131113217

Examine the following table and answer the following questions;

STUDENT

REGNO	NAMES	AGE	ADDRESS
SC02-0111/07	Hilda Omondi	18	Box 7 Kisumu
SC02-0112/07	Rachel Kamau	21	Box 34 Nairobi
SC02-0113/07	Barrack Papai	19	Box 5768 Kakamega

i). Write an SQL data definition statement which when executed would result in the relation shown above. Indicate any primary key(s), field types and sizes

ii) Write a DML statement to add the second tuple of the above relation

iii) Write a DML statement that lists all the names of students in an ascending order

Reference no: EM131113217

Questions Cloud

The following information is available for your first year : Receivables Management as the manager of the accounts receivable department for Beavis Leather Goods, Ltd., you recently noticed that Kelly Collins, your accounts receivable clerk who is paid $1,200 per month, has been wearing unusually tasteful and ..

What kind of measures would you propose to prevent the recur : In an integrated world financial market, a financial crisis in a country can be quickly transmitted to other countries, causing a global crisis. What kind of measures would you propose to prevent the recurrence of an Asia-type crisis?

Determine the load voltage and the armature current : If the generated emfs are 200 and 210 V, respectively, determine the load voltage and the armature current of each machine.

Write a code in java to implement menubar : Write a code in Java to implement menubar

Names of students in an ascending order : Write a DML statement to add the second tuple of the above relation. Write a DML statement that lists all the names of students in an ascending order

Calculate the load current and terminal voltage : When the generators supply a battery of emf 300 V and resistance of 1.5 Ω.

Write a simple program to implement inner class : Write a simple program to implement inner class using ActionListener

Why is the note zero interest bearing : Do you expect to receive the $4,000,000 in cash by March 31st, your fiscal year-end?

Define the process for identifying : Change management plans define the process for identifying, approving, implementing, and evaluating necessary changes due to new requirements, risks, patches, maintenance, and errors.

User Account

All Pages

Names of students in an ascending order

Reference no: EM131113217

Reference no: EM131113217

Questions Cloud

Reviews

Write a Review

Basic Computer Science Questions & Answers

Identifies the cost of computer

Input devices

Cores on computer systems

Prepare an annual budget in an excel spreadsheet

Write a research paper in relation to a software design

Describe the forest, domain, ou, and trust configuration

Construct a truth table for the boolean expression

Evaluate the cost of materials

The marie simulator

What is the main advantage of using master pages

Describe the three fundamental models of distributed systems

Distinguish between caching and buffering

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT