Write the sql queries using data manipulation language, Database Management System

Assignment Help:

Problem

1. Write the SQL queries using Data Manipulation Language (DML) statements.

  1. Insert values into student table with field names using insert command
  2. Display the table student using select command
  3. Update student address in student table using update command.
  4. Delete a row from student table.

>> Writing SQL using DML for each part:

2. Create the payroll database considering table employee.

       1. Do simple queries on the above database.

                     i. list all information of the above both tables.

                    ii. list the empno, ename, jobtitle,and hiredate of employee from the employee table.

       2. list the name, salary of the employees who are clerks.
       3. list the name,job,salary of every employee joined on certain date. (say ‘december 17,1980')
       4. list name and annual salary of all the employees.
       5. list the employees who have salary between certain range (say between Rs. 1000 & 2000)

>> Creating database according to 5 subparts


Related Discussions:- Write the sql queries using data manipulation language

Explain the use of constraints in functional model, Explain the use of cons...

Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or   among various values of the sam

Mapping, external and internal mapping with examples

external and internal mapping with examples

Relationships, Let us first describe the term relationships. What Are Re...

Let us first describe the term relationships. What Are Relationships? A relationship can be defined as: A set of associations or connection, or A rule for communic

Why dml is used for, Why DML is used for? DML is used to Manipulation and...

Why DML is used for? DML is used to Manipulation and processing of database. DML is provided for manipulation & processing of database. (Data stored in the database is processed

Access, I have to solve a problem using access

I have to solve a problem using access

Design an entity relation model, Funky Festivals Specification Funky Fe...

Funky Festivals Specification Funky Festivals organise music festivals which take place at various venues throughout the UK.  A venue needs to be booked before a Festival can t

Consistency, what do you mean by consistency in rdbms?

what do you mean by consistency in rdbms?

What is nested trigger, What is Nested Trigger? A trigger can also havi...

What is Nested Trigger? A trigger can also having INSERT, UPDATE and DELETE logic within itself, so when the trigger is fired because of data modification it can also cause ano

Define multivalued dependency, Define multivalued dependency.  What do unde...

Define multivalued dependency.  What do understand by trivial multivalued dependency?  Ans: A multivalued dependency is a full constraint among two sets of attributes in a rela

What are the uses of odbc, What are the uses of ODBC? Under what circumstan...

What are the uses of ODBC? Under what circumstances we use this technology? ODBC expose database capabilities within a standardized way to the application programmer by an ap

Write Your Message!

Captcha
Free Assignment Quote

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!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd