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!
Strong entity set and weak entity set?
Strong entity set and weak entity set: A strong entity set has a primary key. All tuples in the set are distinguishable through that key. A weak entity set has no primary key unless attributes of the strong entity set on that it depends are involved. Tuples in a weak entity set are partitioned according to their relationship along with tuples within a strong entity set. Tuples within each partition are distinguishable through a discriminator that is a set of attributes. A strong entity set has a primary key. All tuples in the set are distinguishable through that key. A weak entity set has no primary key unless attributes of the strong entity set on that it depends are included. Tuples in a weak entity set are partitioned according to their relationship along with tuples in a strong entity set. Tuples within every partition are distinguishable through a discriminator, which is a set of attributes.
Inconsistent Analysis : The problem as given with transactions T1 and T2 where two transactions interleave to make incorrect result during an analysis by Audit is the instance of s
Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and
What is meant by buffer blocks and disk buffer The blocks residing temporarily in main memory are referred to as buffer blocks. The area of memory where blocks reside t
Which element in the database can modified by changing the data dictionary? Data elements in the database can be changed or modified through changing the data dictionary.
Explain Hashing techniques The hashing techniques can be categorized as: Static Hashing Techniques - In this method, the data can be viewed a collection of buckets, along with
Control as State within Program 1. The term control exactly means to check effect of input within a program. For illustration, in Figure, after the ATM card is inserted (a
what is natural join?
Server Control It is usual to control access to the data via the front end application, for example by displaying data as ‘read only'. This part of the assignment illustrates ho
Discuss the count function? The COUNT function used returns the number of tuples or values fixed in a query. The count function comprises two types of syntax: (1) COUNT (*)
Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following
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