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

Data manipulation language, Question 1 Discuss about second normal form an...

Question 1 Discuss about second normal form and third normal form Question 2 Write short note on                        1) Data Manipulation Language 2) Data Definition La

What is equi join, What is equi join? Equi Join - It generates all th...

What is equi join? Equi Join - It generates all the combinations of tuples from two relations which satisfy a join condition along with only equality comparison (=).

What is meant by physical blocks, What is meant by Physical blocks? The...

What is meant by Physical blocks? The input and output operations are completed in block units. The blocks residing on the disk are referred to as physical blocks.

Er diagrams, in an organization several projects are undertaken. Each proje...

in an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the

Parallelism of transaction execution-data fragmentation, Parallelism of tra...

Parallelism of transaction execution: A transaction can be divided into various sub-queries that can operate on fragments in parallel. This enhances the degree of concurrency in t

State about the tables- DBMS, State about the Tables- DBMS Data is sto...

State about the Tables- DBMS Data is stored in columns and rows (much like a spreadsheet -main difference is how data is organised). Every row in a table is known as a record

Remove partial dependancy, , write the relational schema, and draw the new ...

, write the relational schema, and draw the new dependency diagrams. Identify the normal forms for each table structure you created

Illustrate how customer relationship is promoted, FitAll Ltd is a company t...

FitAll Ltd is a company that manufactures clothes. Its processes are manual and there are stand-alone Information Systems that aid to manage them. The Information Systems were purc

Queries, Find the names of all Albums that have more than 30 tracks. Result...

Find the names of all Albums that have more than 30 tracks. Result: (name: varchar(255))

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