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

Compare three clustering algorithms in weka, Compare three clustering algor...

Compare three clustering algorithms in Weka. For this comparison, you will need to use at least two different datasets. Run the algorithms on the datasets, and use the visual

Describe log based recovery, Describe log based recovery The most usabl...

Describe log based recovery The most usably structure for recording data base modification is the LOG the log is a sequence of log records recording all the update activities i

Explain saving derived attributes to avoid re-computation, Saving Derived A...

Saving Derived Attributes to Avoid Re-computation   As discussed, "redundancy means duplication of exact data". But, if multiple copies of same data are present in the system,

Textbook ordering system, Question: Consider the following database rel...

Question: Consider the following database relations for a textbook ordering system used by a college bookshop: Book (b-copy#, bname, ISBN#, author, price, subject) Order (s#

Commercial database architecture, At its most essential level the DBMS arch...

At its most essential level the DBMS architecture can be divide into two parts: the back end and the front end. The back end is responsible for managing the physical database an

Explain the steps for reduction of e-r model, Explain the steps for reducti...

Explain the steps for reduction of E-R model into relational model. Ans:(a) Entity set in E-R model will be considered as table name in relational Model. (b) Attributes of e

What are the benefits of prepared statements, What are the benefits of prep...

What are the benefits of prepared statements and place holders? Parameter binding operations automatically handle escaping of characters Encourage Statement reuse

Differentiate between various levels of data abstraction, Differentiate bet...

Differentiate between various levels of data abstraction? Data Abstraction - Abstraction is the procedure to hide the irrelevant things from the users and represent the rele

Describe the development process of object oriented methods, Describe the d...

Describe the development process of Object oriented methods Object oriented methods have roots which are strongly anchored back in the 60s, functional and structured methods we

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