Consider the instance of the EMPLOYEE relation shown in the following

1.	Consider the instance of the EMPLOYEE relation shown in the following table. Identify the attributes, degree, cardinality and domain of Name and Emp_code. EmpCode Name Department Designation Salary1000SudheeshPurchaseManager250001001DhanyaSalesManager250001002FathimaMarketingClerk120001003ShajanSalesClerk13000
Answer» Attributes- These are column names, i.e, Emp_Code, Name, Department, Designation and Salary Degree(CD) - the number of Columns is the Degree i. e Degree is 5(Here 5 columns) Cardinality (RC)-: the number of Rows is the Cardinality i. e. Cardinality is 4(Here 4 rows) Domain is the pool of possible values Domain of Name is a String(Sudheesh, Dhanya, Fathima, Shajan.etc) Domain of Emp_Code is a number (1000,1001,1002, 1003, etc)

Consider the instance of the EMPLOYEE relation shown in the following table. Identify the attributes, degree, cardinality and domain of Name and Emp_code. EmpCode Name Department Designation Salary1000SudheeshPurchaseManager250001001DhanyaSalesManager250001002FathimaMarketingClerk120001003ShajanSalesClerk13000

Answer»

Attributes- These are column names, i.e, Emp_Code, Name, Department, Designation and Salary Degree(CD) - the number of Columns is the Degree i. e Degree is 5(Here 5 columns)

Cardinality (RC)-: the number of Rows is the Cardinality i. e. Cardinality is 4(Here 4 rows) Domain is the pool of possible values Domain of Name is a String(Sudheesh, Dhanya, Fathima, Shajan.etc) Domain of Emp_Code is a number (1000,1001,1002, 1003, etc)

Discussion

No Comment Found

Related InterviewSolutions

What were the two main occupations of the Rig Vedic Aryans?
Name the two political institutions which exercised check on the powers of the King in the Rig Vedic period.
What w’as the position of women in the Rig Vedic age ?
Describe the social life of the Rig Vedic Aryans with reference to the following: (a) The Family Structure (b) Position of Women (c) Varna System
With reference to the following explain the main features of the Rig Vedic Economy: (a) Agriculture (b) Domestication of Animals (c) Trade Transactions, Crafts and Transportation
Mention any two archaeological sources to reconstruct the later Vedic Age.
Mention any two of the Ashrams in the life of a man in Aryan society.
What information do we gather from the later Vedic literature in respect of: (a) Spread of Vedic Civilization to many New Regions. (b) Role of Iron in later Vedic Economy.
Mention briefly the rituals and sacrifices of the later Vedic Aryans?
What is the message of the Bhagavad Gita?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment