हिंदी

An organisation wants to create a database The company wants to retrieve details of the dependent of a particular employee. Name the tables and the key which are required to retrieve this detail. -

Advertisements
Advertisements

प्रश्न

An organisation wants to create a database EMPDEPENDENT to maintain the following details about its employees and their dependent.

EMPLOYEE(AadharNumber, Name, Address, Department, EmployeeID)
DEPENDENT(EmployeeID, DependentName, Relationship)

The company wants to retrieve details of the dependent of a particular employee. Name the tables and the key which are required to retrieve this detail.

एक पंक्ति में उत्तर

उत्तर

Employee and Dependent tables linked via key EmployeeId

shaalaa.com
Keys in a Relational Database
  क्या इस प्रश्न या उत्तर में कोई त्रुटि है?
Share
Notifications

Englishहिंदीमराठी


      Forgot password?
Use app×