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!
Describe entity referential integrity and integrity. Give an example of each.
Entity Integrity Rule - If there is a attribute A of relation R is a prime attribute of R then A cannot accept null values.
Referential Integrity Rule - In referential integrity, it is ensured in which a value in which appears in one association for a given set of attributes also appears for a certain set of attributes in another relation.
For example:
Roll No is the primary key within the relation STUDENT and Roll No + Course is the primary key of the relation GRADE. (Entity Integrity) Roll No in the relation GRADE (child table) is a foreign key, which is referenced from the relation STUDENT (parent table). (Referential Integrity).
A model in database system mostly defines the organisation of data or structure and a set of operations on that data. Relational model is a easy model in which database is represen
Consider the entity type dependent related to employee entity, which is used to keep track of the dependents of every employee. The attributes of dependents are: name, sex, birth d
Attributes that are directly kept in the data base. For example, 'Birth date' attribute of a person. Derived Attributes that are not stored directly but can be derived
Give the Introduction of OBJECT DESIGN Strategies which are selected during system design are carried out in object-oriented design. In this procedure, objects which are identi
Explain the EXEC statement in SQL Ans: All statements which start with EXEC SQL are embedded SQL database statements. High level languages such as C can be employed to write a
MySQL statements for extending the database to incorporate new facilities Deliverables for submission You must submit the following deliverables in the Assignment Dropbox in
Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but
How nulls are treated in comparison operator? Along with comparison (relational) operators, the null values are ignored as we cannot derive the relation along with the given op
explain normalisation
What is the difference between internal tables and extract datasets? The lines of an internal table always have the similar structure. By using extract datasets, you can ha
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