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!
What is a view? Make a view of EMP table named DEPT 20, to display the employees in department 20 and their annual salary.
Ans: View is a virtual table that does not consists of it own data it fetch the data from the original table.
Create view DEPT20 as select * from dept;
Where dno=20 group by dno;
Differentiate strict two phase locking protocol and rigorous two phase locking protocol. In strict two phase locking protocol all exclusive mode locks taken by a transaction is
The Incident table, with an auto-incrementing incident number, etc, looks like: incident_num reporter date time incide
What is a database? Database - Basically in simple terms A database is a collection of inter related data and/or information stored so which it is available to several users
Differentiate between Primary and secondary storage? Primary and secondary storage - Primary storage device stores the data temporarily. Primary storage is commonly used thro
1. Which relational algebra operations do not need the participating tables to be union-compatible? Ans: Join is the relational algebra operations that do not need the particip
What is Management System? A management system is a set of rules and process which help us to create organize and manipulate the database. It also helps us to add, change delet
Relational Algebra is a set of basic operations used to influence the data in relational model. These operations allow the user to specify basic retrieval request. The result of re
Construct a clean ans concise ER diagram for the database indicating the cardinality mapping for Employee management syatem
a set of possible data value of an attribute is called??
what is natural join?
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