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 collection of a same kind of entities is known as an Entity Set or entity type.
Example:
For the COLLEGE database defines earlier objects of concern are Students, Faculty, Course and departments. The sets of all the students' entities form a entity set STUDENT. Likewise collection of all the courses creates an entity set COURSE.
Entity sets require not be disjoint. For example - an entity may be part of the entity set STUDENT, the entity set FACULTY, and the entity set PERSON.
What are the General Transformation Rules for Relational operations? Ans: The transformation rules transform one relational algebra expression to AN EQUIVALENT ONE 1. E
recovey techniques based on deferred update and immediate update
Define and differentiate between ordered indexing and hashing. Ans: Ordered indexing: To gain fast random access to records in a file, we can make of an index structure. Every
Exclusive lock It is asked for by a transaction on a data item that it wants to update. No other transaction can put either a shared lock or an exclusive lock on a dat
What is the use of keyword ISA? The use of keyword ISA is to show that a class is a specialization of another class.
Question : Object-Oriented Database (OODM) is defined as a logical data model that captures the semantics of objects supported in object-oriented programming. An Object-Oriente
Advantages of Database management system Let us summarize the advantages. Reduction of Redundancy: This is perhaps the most important advantage of using DBMS. Redundancy i
Consider the table student and list names of students in the departments other than maths and computer. SELECT std_name FRM student WHERE dept_name NOT IN (‘Maths','Computer);
CAN SOMEONE HELP ME WITH ENTITY DIAGRAMS IN FIRST NORMAL FORM?
Illustrate the Deployment Diagram A deployment diagram shows all nodes on network, their processor execution and interconnections. In a dynamic model, this is used to represen
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