Question : You have been given a relationship diagram, with to relationship.
E.g. there are two entity Person and Passport
Each person can have only one passport and each passport can belong to one person.
Person : Person_ID (Unique in database) Passport : Passport Number (Unique in database)
So, which would be the correct keys in this case? 1. Key attributes of either participating entity types 2. Key attributes of both participating entity types 3. Access Mostly Uused Products by 50000+ Subscribers 4. Key attribute of the relationship type
Correct Answer : Get Lastest Questions and Answer : Explanation: So, in one to one relationship, you can use either side of the keys to uniquely identify relationship instance.
Question : . You are uploading your video on HadoopExam training website HadoopExam.com , and you have following relationship. One user id can upload many videos. However, each video has a unique id. So in this case how do you find unique key for 1 to n relationship? 1. Key attributes of either participating entity types
2. Key attributes of both participating entity types
Correct Answer : Get Lastest Questions and Answer : Explanation: As we have 1 to many relationship. A user can upload many training videos, hence its id will appear many times. So only way to uniquely identifying a video is using video id on many side.
Question : You have been writing a technical book, which will be published on HadoopExam website. Now, HadoopExam had provided many other authors to help you complete your book on time. Hence, we are having here many to many relationship. One book can be written by multiple author and an author can write multiple books. Now, you need to find unique relation, how would you find in this case.
You will be having unique author_id and unique book_id
Author(Author_id) -----(m to m) ------ Book (BookId) 1. Key attributes of either participating entity types
2. Key attributes of both participating entity types
Correct Answer : Get Lastest Questions and Answer : Explanation: In this scenario to identify unique participative key, we need to use key from both the side of relationship.