Category INF503

7. LAB 7.1 SELECT DISTINCT Pnumber, PnameFROM PROJECTWHERE  Pnumber IN(SELECT PnumberFROM PROJECT, EMPLOYEE_DEPARTMENT, EMPLOYEE_RECWHERE Dnum = Dnumber ANDMgr_ssn = Super_ssn AND Lname = ‘Zelaya’)ORPnumber IN(SELECT PnoFROM WORKS_ON, EMPLOYEE_RECWHERE Essn = Ssn AND Lname = ‘Smith’); 7.2 SELECT Lname, FnameFROM EMPLOYEE_RECWHERE Salary > (SELECT MAX (Salary)FROM EMPLOYEE_RECWHERE Dno = 5);7.3SELECT E.Lname AS Employee_name,S.Lname AS Supervisor_nameFROM (EMPLOYEE_REC AS E LEFT OUTER JOIN EMPLOYEE_REC AS SON E.Super_ssn = S.Ssn);7.4SELECT SUM…

Q1) which of the following conditions must be satisfied for a database to be called distributed? 1. Connection of database nodes over a computers network2. Logical interrelation of the connected databases Q2) .consider the following figureThe name attribute of student is a______.…

 1. Who is responsible for identifying data to be stored in the database and for choosing appropriate structures to represent and store Data base designer 2. which of the following functions of database management system causes some data to be…

 Q1) Loss of availability occurs when:  A user or program cannot access objects who has legitimate right to those objects. Q2) Which of the following control measures is handled by creating user accounts and passwords to control the login processes…

1._____ are in charge of presenting data to the end user in a variety of ways.The correct answer is: Data visualization tools 2.______ focuses on filtering data as it enters the system to determine which data to keep and which to…

1._____ is the central activity during the parsing phase in query processing.The correct answer is: Query optimization 2._____ distributed database management systems (DDBMS) integrate multiple instances of the same DBMS over a network.The correct answer is: Homogeneous 3._____ fragmentation allows a user to break…

1._____ can render data useless to unauthorized users who might have violated some of the database security layers.The correct answer is: Data encryption 2._____ are required to prevent another transaction form reading inconsistent data.The correct answer is: Locks 3._____ means that data…

1.A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching values in the common columns) but also the rows with unmatched values.The correct answer is: outer 2.A(n) _____ query specifies which data should be…

1.A table that has all key attributes defined, has no repeating groups, and all its attributes are dependent on the primary key is said to be in _____. The correct answer is: 1NF 2.A table where all attributes are dependent on…

1._____ returns only the attributes requested, in the order in which they are requested.The correct answer is: PROJECT 2.An entity is said to be _____-dependent if it can exist in the database only when it is associated with another related entity…