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!
In an organization several projects are undertaken. Each project can employ one or more employees. Each employee can work on one or more projects. Each project is undertaken on the required of client. A client can request for several projects. Each project has only one client. A project can use a number of items and a item may be used by several projects. Draw an E-R diagram and convert it to a relational schema.
The ER Diagram can be converted into the following relational schema. Entity Sets (i) Employee (Empno, Name, Salary, Desig) (ii) Project (P_id, Pname, P-desc) (iii) Item (I_id, Iname, I-desc) (iv) Clients (C_id,Cname, Address) (v) Works_on (Empno, P_id) (vi) Requests (P_id, C_id) (vii) Requires (P_id, I_id)
explain external view
What is meant by heuristic optimisation?Discuss the major heuristics that are applied during query optimisation.
What are the comparison operator in SQL? Comparison operator in SQL are =, LIKE and BETWEEN
Data Mining 1. What is data mining? Write Data Mining applications. 2. Explain OLAP? Write the benefits of OLAP. 3. What are the key features of a Data Warehouse? 4. W
Normalize the following tables upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the
Define in which normalisation form if an attribute of a composite key is dependent on an attribute of other composite key. Ans: 3NF A relation is in 3 NF if an attribute of
What is called an evaluation primitive? A relational algebra operation annotated with instructions on how to evaluate is known as an evaluation primitive.
What is a security? Securities are claims on financial assets. They can be illustrated as "claim checks" which give their owners the right to receive funds in the future. Sec
Explain the cartesian product in Database Management System
What is storage manager? A storage manager is a program module that gives the interface between the Low level data kept in a database and the application programs
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