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 database is a set of data. But, is the data kept in a database trustworthy? To answer that query we must first answer the question. What is integrity?
Integrity simply means to keep the consistency of data. Therefore, integrity constraints in a database make sure that changes made to the database by authorised users do not compromise data consistency. Therefore, integrity constraints do not permit damage to the database.
There are primarily two integrity constraints: the referential integrity constraint and the entity integrity constraint. In order to describe these two, let us first describe the term Key with respect to a Database Management System.
What is Asterisk in SQL? Asterisk (*): In SQL, the columns for all the tables and views in the FROM clause will be displayed.
how can apply joins on table
Problem 1. Create a PL/SQL program to insert data into student table and display the details of the student having Reg.No 1010 Writing a PL/SQL program to Insert data
Explain retrieval in QBE? Retrieval in QBE : A "GUI" for expressing queries. Based on the Domain Relational Calculus (DRC) Actually invented before GUIs. Very co
Question : (a) Data mining is one of the best ways to analyse data and using software method, hidden and unexpected patterns and relationships in sets of data can be extracte
Conversion of entity sets: I) For every strong entity type E in the ER diagram, we make a relation R containing all the easy attributes of E. The relation R pri
i want to database for online assignment submission system
Define entity integrity and referential integrity. How does SQL allow specification of these? Ans: Entity Integrity Rule- If the attribute A of relation R is a prime attribut
1.Why we need data mining? Give an example to illustrate your answer. 2. Why data mining is considered as "misleading name"? 3. Distinguish the difference between database an
What are the DBMS languages? Explain. Ans: a) Data Definition Languages (DDL): It is employed to specify database schema for example CREATE DROP statements etc. b) Dat
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