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.
How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View
Special comparison operator used in where Clause a. between. ...and...It gives range among two values (inclusive) Example: SELECT ENAME, SAL FROM EMP WHERE SAL BETWE
What are the basic objects of the data dictionary? Tables Domains Data elements Structures Foreign Keys
The need for three level architecture The aim of the three level architecture is to divide each user's view of the database from the way the database is physically shown.
Shared lock or Read Lock It is requested by a transaction that needs to just read the value of data item. A shared lock on a data item does not permit an exclusive lock
Multilevel Index The Multilevel Index is a modification of the secondary level index system. In this system we might be use even more number of levels in case the table is eve
Serialisability: Any schedule that makes the similar results as a serial schedule is known as a serialisable schedule. But how can a schedule are determined to be serialisable or n
What sorts of tables one can se in designing the hierarchy of a LDB? Tables, which are having Foreign Key relations.
external and internal mapping with examples
Explain the conventions (relationships) for displaying an ER schema as an ER 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