Consider the following relations:
Employee ( E-ID, Name, P-ID)
Project ( P-ID, E-ID, P- Cost, P-Profit)
Consider the following query on these relations:
List the E-ID, Name, P-Code and P-Profit whose E-ID is 2017001
Popular Posts
-
First Create Table in your Database create database SampleDB; use SampleDB; CREATE TABLE product ( product_id Num...
-
Ans. Algorithm: Step 1: Input NUM Step 2: LEN = 0 & Y=NUM Step 3: While (Y > 0) HEXD[LEN]=Y%16... -
Course Code: MCS-014 Course Title: Systems Analysis and Design Assignment Number: MCA (I)/014/Assignment/15-16 Maximum Marks: 100 Weightage:...
-
Software Requirement Specification for Railway Reservation System The SRS for Railway Reservation System is given as follo...
-
Answer the following simple queries in SQL. a) Find name of supplier for city = “MUMBAI”. ...
-
SRS for Library Management System This page contains Library management system project SRS document. A development process consist of va...
-
ERP is the acronym of Enterprise Resource Planning. ERP utilizes ERP software applications to improve the performance of organizations’ res...
-
ER diagram of Cab Management System, Cab Booking System or Cab Mobile Application -
Ans. #include<stdio.h> #include<conio.h> Void main() { int a[3][3],b[3][3],c[3][3],d[3][3]; int i,j,k; for(i=0;...
-
Cash is the most important current asset for a business operation. It is the force that drivers business activities and also the ultimate o...
0 comments:
Post a Comment
Let us know your responses and feedback