Write query to select student from math department, Database Management System

Assignment Help:

Consider the table student and list names of students in the departments other than maths and computer.

SELECT std_name FRM student WHERE dept_name NOT IN
(‘Maths','Computer);

Related Discussions:- Write query to select student from math department

Database design and documentation, A use case diagram giving a pictorial ov...

A use case diagram giving a pictorial overview of user requirements and brief use case descriptions. As the case study contains only an outline of a business scenario, you will als

network and relational dbms, complete assignment on the above title

complete assignment on the above title.

The data of a view is not physically stored, The data of a view is not phys...

The data of a view is not physically stored, but derived from one or more tables. True the data of a view is not physically stored

What is transaction, What is transaction? Transaction is a unit of prog...

What is transaction? Transaction is a unit of program implementation that accesses and possibly updated several data items.

What are called multilevel indices, What are called multilevel indices? ...

What are called multilevel indices? Indices with two or more levels are known as multilevel indices.

Relation schema for student, Example RELATION SCHEMA for STUDENT: STU...

Example RELATION SCHEMA for STUDENT: STUDENT (Roll No: string, name: string, login: string, age: integer) RELATION INSTANCE

Mobile database, write short note on mobile database

write short note on mobile database

Relational DBMS, Due date for May 8

Due date for May 8

What is a transaction? and how does it differs from update, wh

What are the general transformation rules, What are the General Transformat...

What are the General Transformation Rules for Relational operations? Ans: The transformation rules transform one relational algebra expression to AN EQUIVALENT ONE 1. E

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages