Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Consider the subsequent relation schemes:
Project (Project#, Project_name, chief_architect)
Employee (Emp#, Empname)
Assigned_To (Project#, Emp#)
Give expression in Tuple calculus and Domain calculus for each of the queries below:
(i) Get the employee numbers of employees who work on all projects.
(ii) Get the employee numbers of employees who do not work on the COMP123 project.
Ans: (i) Tuple Calculus:
{t[Emp#] | t ∈ ASSIGNED_TO ∧ ∀p (p ∈ PROJECT ∃u (u ∈ ASSIGNED_TO ∧ p[Project#] = u[Project#] ∧ t[Emp#] = u[Emp#]))}
Domain Calculus:
{e | ∃p (
∈ ASSIGNED_TO ∧ ∀p1 ( ∈ PROJECT ∈ ASSIGNED_TO))}
(ii) Tuple Calculus:
{t[Emp#] | t ∈ ASSIGNED_TO ∧ ¬∃u (u ∈ ASSIGNED_TO ∧ u[Project#] = 'COMP123'∧ t[Emp#] = u[Emp#])}
∈ ASSIGNED_TO ∧ ∀p1, e1 ( ∉ ASSIGNED_TO ∨ p1 ≠ 'COMP123' ∨ e1 ≠ e))}
Briefly explain the state diagram by taking one example. State Diagram - An object can be given a sequence of input instructions. The state of the object can vary depending u
Benefits of Hashed file Organisation 1. Insertion or search on hash-key is quick. 2. Best if equality search is required on hash-key. Drawbacks of Hashed file
Advantages of Observation Methods: Bailey has pointed out four advantages of observation: 1. Superior in Data Collection on Non Verbal Behavior: When a person a opi
Eliminate Columns Not Dependent On Key The Employee Relation satisfies - First normal form - As it has no repeating groups. Second normal form - As it do not have multi-a
In an E-R diagram an entity set is represent by? In an E-R digram entity set is represted by rectangle.
Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang
explain in details about one to one binary relationship
Smart Alex Catering Sevice (SACS) is a company offering top class catering staff for prestigious events. The company employs approximately 200 hourly paid contact staff - chefs,
Explain the term- Periodic recomputation Periodic recomputation: Base values are often updated in bunches. Sometimes, it is possible to just recompute all derived attributes p
Consider the relations EMP(ENO,ENAME,AGE,BASIC_SALARY) WORK_IN(ENO,DNO) DEPT(DNO,DNAME,CITY) Express the following queries in SQL (i) Find names of employees who work in a dep
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd