Relational Database : A database Management System is a software application for managing the database in a well-organized form. It provides a systematic way to create, retrieve and update the database. In DBMS, the schema explains the logical structure of the data base system. It provides the capability to the user to self-analyze the database and perform the necessary operations. A relational database comprises of rectangular tables known as relations. Every row in relation is known as tuple. Each column in table is termed as field or attribute. It describes the characteristics of entity represented by corresponding tuple. Given code: TEMP1<- JOIN EMPLOYEE and JOB Where EMPLOYEE.EmplId= JOB. EmplId TEMP2<-SELECT from TEMP1 where Dept = ‘SALES’ RESULT <- PROJECT Name from TEMP2

Question

Want to see the full answer?

Answer 1

Question

Chapter 9, Problem 35CRP

Program Plan Intro

Relational Database:

A database Management System is a software application for managing the database in a well-organized form.

It provides a systematic way to create, retrieve and update the database.

In DBMS, the schema explains the logical structure of the data base system.

It provides the capability to the user to self-analyze the database and perform the necessary operations.

A relational database comprises of rectangular tables known as relations.

Every row in relation is known as tuple.

Each column in table is termed as field or attribute.

It describes the characteristics of entity represented by corresponding tuple.

Given code:

TEMP1<- JOIN EMPLOYEE and JOB

Where EMPLOYEE.EmplId= JOB. EmplId

TEMP2<-SELECT from TEMP1 where

Dept = ‘SALES’

RESULT <- PROJECT Name from TEMP2

Expert Solution & Answer

Want to see the full answer?

Check out a sample textbook solution

See solution

Students have asked these similar questions

Consider the relational database below, where the primary keys are underlined.employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name)Give a query for each of the following:a Find the company that has the smallest payroll.b Modify the database so that Jones now lives in Newtown.c Give all employees of the First Bank Corporation a 10 percent raise.d Give all managers in database a 10 percent raise.e Give managers in the database a 10 percent raise, unless the salary would be greaterthan $100,000. In such cases, give only 3 percent raise.f Delete all tuples in the works relation for employees of Small Bank Corporation.

Consider the relational database below, where the primary keys are underlined.employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name)Give a query for each of the following:a Give all managers in database a 10 percent raise.b Give managers in the database a 10 percent raise, unless the salary would be greaterthan $100,000. In such cases, give only 3 percent raise.c Delete all tuples in the works relation for employees of Small Bank Corporation

Consider a database that consists of the following relations.SUPpLIER(Sno. Sname)PART(Pno, Pname)PROJECT(Jno, Jname)SUPPLY(Sno, Pno, Jno)The database records information about suppliers, parts, and projectsandincludes a ternary relationship between suppliers, parts, and projects.Thisrelationship is a many-many-many relationships. Specify and execute thefollowingqueries using the relational algebraRetrieve the part numbers that are supplied to exactly two projects.b. Retrieve the names of suppliers who supply more than two parts toproject J11c. Retrieve the part numbers that are supplied by every supplier.d. Retrieve the project names that are supplied by supplier S1' only.e. Retrieve the names of suppliers who supply at least two different partseach to at least two different projects.