Hey guys! Would really appreciate the help on this, Thanks alot !!! Consider the
ID: 3723943 • Letter: H
Question
Hey guys! Would really appreciate the help on this, Thanks alot !!!
Consider the following relational schema and briefly answer (don’t forget to define properly each table, considering keys):
Emp(eid: integer, ename: string, age: integer, salary: real)
Works(eid: integer, did: integer, pct time: integer)
Dept(did: integer, budget: real, managerid: integer)
3. Create an assertion on Dept that will ensure that all managers have age > 30 Use this table Create here your Assertion CREATE TABLE Dept ( did INTEGER, budget REAL, managerid INTEGER , PRIMARY KEY (did)Explanation / Answer
CREATE ASSERTION managerAge
CHECK ((SELECT E.age FROM EMP E, Dept D
WHERE
E.eid=D.managerid) > 30);
in this managerAge is the assertion name.