Define Partial-artificial-alternate-compound
Give a brief explanation of the term partial, artificial, alternate, compound and natural key.
Expert
It is a set and collection of attributes which can uniquely identify weak entities and which are related to equivalent owner entity. It is sometime named as Discriminator.
Alternate Key: All the Candidate Keys without the Primary Key are recognized as Alternate Keys.
Artificial Key: When no obvious key either stands alone or compound is accessible, then the last resort is to easily make a key, through assigning a unique number to each and every record or occurrence. Then this is recognized as developing an artificial key.
Compound Key: When no single data element uniquely determines occurrences in construct, then combining multiple elements to make a unique identifier for construct is recognized as creating a compound key.
Natural Key: If one of data elements kept in a construct is employed as the primary key then it is named as natural key.
1. MyCo has 14 locations. The locations are 1 HQ, 2 regional centers (RC), and 11 local offices (LOs). 2. About 10,000 people work in this company, 25% at the HQ, 10% at each RCs, and 5% at each LOs. 10,000 total people: 25% x 10,000 @ HQ (2,500)
State the five major technologies which are used in order to develop the Client/Server applications?
Write down the features which are given by layering?
What is the right time for replacing cell phone with a VoIP phone? Illustrate briefly.
What kind of features which you can expect from web conferencing service?
What is Management Information Base or MIB?
Normal 0 false false
Explain the advantages of the Star Topology.
What is Feistel Cipher? briefly explain it.
18,76,764
1953192 Asked
3,689
Active Tutors
1456692
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!