Search Interview Questions | Click here and help us by providing the answer. Click Correct / Improve and please let us know. |
|
|||
|
| ||||
| Design - Interview Questions and Answers for 'Vivint' - 1 question(s) found - Order By Newest | ||||
| ||||
| Ans. Following Tables can be created ASSET - Entity Table With foreign key reference to Table AssetType ASSET_TYPE - Entity Table specifying information related to Asset Type like Books, CDs etc. MEMBER - Registration information for the member MEMBERSHIP_TYPE - Membership Types provided by Library MEMBERSHIP - Relation table with foreign key for MEMBER , MEMBERSHIP_TYPE ASSET_ISSUE_LEDGER - Relationship between MEMBER and ASSET. This specify the issue of particular asset to a particular member. | ||||