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!
(a) What is a view?
(b) What is the implication of creating a view with the select * statement in the view definition?
(c) Make reference to the relational schema given in Appendix I to answer this question. Create a VIEW called SALARY_VU based on the employee last names, first names, department names and salaries for those employees whose monthly salary is greater than 10000. Label the column Employee Last Name, Employee First Name, Department and Salary respectively. Make sure to encrypt the view.
(d) Explain the purpose of an Outer Join.
(e) In the HR schema given in the Appendix II, there are certain employees who are not assigned to any department and there is a few departments where no employee has been assigned yet.
(i) Write SQL code to display the employee Last name, the department_id and the department name for all employees. Your answer should display even those employees who have not been assigned to any departments.
(ii) Write SQL code to display the employee Last name, the department_id and the department name for all employees. Your answer should display even those departments which have no employee assigned to the departments.
Q. Differentiate between object oriented and function oriented design. Ans: • Function-oriented design depend on identifying functions which transform their inputs to create
Write down short notes on empirical estimation models ?
It should include all the theory that you need to complete the requested design, and all the simulation documents that you produce after synthesizing the circuit. Briefly, your rep
What are the principles of testing Below are some of the principles of testing: i) All tests must be performed according to user requirements. ii) Planning of tests m
What are the various types of system testing? 1. Recovery testing - is intended to check the system's ability to recover from failures. 2. Security testing - verifies th
Q. Show the cost drivers used in COCOMO model? A variety of attributes of cost drivers used in COCOMO model are: 1. Physical attributes : These are worried with required
What does Data abstraction contains? A Data abstraction is a named collection of data that defines a data object Eg: door Attributes: door type, Opening mechanism, Swing di
What are the demerits of spiral model? i. It is depends on customer communication. If the communication is not suitable then the software product that gets developed will not r
Coupling and Cohesion Data coupling - The data coupling is possible by parameter passing or data interaction. Control coupling - The modules share related control data
List the guidelines for data design. i. Apply systematic analysis on data. ii. Determine data structures and related operations. iii. Establish data dictionary. iv. Us
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