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;
The advantages of a database management system (DBMS) include :- Data integrity and elimination of duplication.
What it creates while a primary key is combined with a foreign key? It creates Parent-Child relation ship between the tables that connect them while a primary key is combined w
What is a Name? A user-supplied name is used for identity. This form of identity is used for files in file systems. The user gives every file a name that uniquely identifies it
What is DDL? Make a list of commands with short description used in DDL Ans: Data Definition Language that is abbreviated as DDL is a computer language for defining data struct
The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an
What do you mean by persistence? How you will make your data persistent? Persistent data is the data, which has a longer lifetime than program which has created it. Enabling th
To do the division operation R1 ÷ R2, R2 should be a correct subset of R1. In the following example R1 have attributes A and B and R2 have only attribute B so R2 is a correct subse
Develop C# schoolproject ASAP Helping me with schoolproject. The project is prepared in C# and haves a database connection. We have some small issues asking up data from t
Define page. The database is partitioned into some number of fixed-length blocks, which are referred to as pages.
usecase diagram,activity diagraM,SEQUENCE DIAGRAM
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