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).
Using Column aliases Example: To print column names as NAME and ANNUAL SALARY SELECT ENAME "NAME", SAL*12 "ANNUAL SALARY" FROM EMP;
1. Which model is used to store data in tree structures Ans: Hierarchical model is used to store data in tree structures
Submission Requirements All answers must be computer generated (including text and diagrams). The hand-in version must include a header page (or with sufficient space)
DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b
Provide Examples of different types of Time and Date formats. It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo
1. Staff (staffID --> availabilityID) 2. Services (servicesID --> itemBasedID --> timedBasedID) 3. TimedBased (timedbasedID--> priceid) 4. Clients (clientId, serviceId-->
What is the need of a log in a DBMS? Briefly describe the various types of records that are normally present in a log. Ans: The system log, which is generally writt
How persistent programming languages differ from traditional programming languages? Database languages vary from traditional programming languages in that they directly manipul
What is Conceptual Schema? Conceptual Schema - Conceptual schema elaborates the structure of the overall database for a community of users. It hides the details of physical sto
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 consist
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