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!
BCNF Boyce-Codd Normal Form
A relation schema R is in BCNF if it is in 3NF and accepts an additional constraint that for every FD X A, X has to be a candidate key. If a relational process is in BCNF then all redundancy based on functional dependency has been replaced, although other kinds of redundancy can still exist. A relational schema R is in Boyce-Codd normal form if and only if for each one of its dependencies X → Y.
Which data type can store unstructured data? Raw data type can store unstructured data.
System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys
1 NF Normal Form The domain of attribute must add only atomic (simple, indivisible) values First normal form (Minimal Form or 1NF) is a normal form need in database normalizat
How many types of Views are there? There are Four types of views:- Database View Help View Projection View Maintenance View
Explain the Project-Join normal form A relation R is in PJNF along with respect to a set of functional dependencies D if for all join dependencies of the outline *(R 1 , R 2 ,
What types of adjustments are required to increase chances of inheritance. a) Some attributes can be added or ignored in the base class operation b) Some changes can be
What is difference between TRUNCATE and DELETE? - Truncate can't be rolled back whereas Delete can be. - Truncate keeps the lock on table whereas Delete keeps the lock on ea
Preliminary entities and attributes of human resourse management database management system
What is known as sequential file organization? In the sequential file organization, the records are kept in sequential order, according to the value of a "search key" of every
Describe five main functions of a database administrator. Ans: A database administrator (DBA) is a person who is accountable for the environmental aspects of a database. Genera
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