Database Systems (csc-2078)

Name: Ali Muhammad

Reg No: 19-NTU-CS-1089

Department: Department of Computer Science (DCS)

Technology: BS Software Engineering (BSSE)

Semester: 3^rd

Course Title: Database Systems

Course Code: (CSC-2078)

Submitted To: Sir Dr. Muhammad Abdul Qayyum

Show complete record of Projects where Pnames are C++ or Database and Budget is greater than 270000

SELECT *

FROM Project

WHERE (Pname = 'C++' OR Pname = 'Database') AND Budget > 270000;

1. 
   Show responsibilities from Responsibility table where PNO are P1, P2 Or P4 and ENO is E3
   

FROM Responsibility

WHERE (PNO = 'P1' OR PNO = 'P2' OR PNO = 'P4') AND ENO = 'E3';

2. 
   Show complete record from Salary where salary is greater than 50,000 OR title is Mechanical Engineer
   

FROM Salary