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 relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries:(i) Get details of employees working on project COMP33.(ii) Get the employee number of employees who work on all projects.(iii) Get details of project on which employee with name ‘RAM' is working.
Ans:(i) EMPLOYEE ∏Emp#(σproject#='comp33'(ASSIGNED)) (ii) ∏Emp#(EMPLOYEE)-(ASSIGNED ÷∏project#(PROJECT)) (iii) PROJECT (∏project#(σEmp_name='RAM'(EMPLOYEE) ASSIGNED))
Define tuple variable Tuple variable is a type of variable whose domain is the set of all tuples.
Sequential File Organisation The most necessary way to organise the collection of records in a file is to use sequential Organisation. Records of the file are stored in series
(1) Insert into PERSON Violated constraint: - Key constraint Reason: - Primary key 1 already exists in PERSON. Dealing: - DBMS could ask the user to provide valid PER
What is hashing file organization? In the hashing file organization, a hash function is computed on some attribute of every record. The result of the hash function specify in
What is OLTP (Online Transaction Processing)? In OLTP - online transaction processing systems relational database design use the discipline of data modeling and generally follo
What is a relationship called when it is maintained between two entities? A relationship is called Binary relationship when it is maintained between two entities.
First Normal Form and second normal form First Normal Form (1NF) A relation is said to be in 1NF if it having no non-atomic values and each row can give a unique combinat
What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p
Many-to-many : Entities in A and B are related with any number of entities from each other. Example: Taught_by Relationship among course and faculty. One faculty member ca
What is an index? An index is a structure that helps to place desired records of a relation quickly, without probing all records.
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: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd