An organisation needs to maintain records of there Employees. They need to store the EmployeeID,
EmployeeName, Age, Address, Salary, DateOfJoining.
i) Which of the fields can be used as a Primary Key?
ii) Mention the appropriate data types for the fields.
iii) Explain the four views in which a Report can be worked upon.
Answers
Answered by
0
Hello bro I don't know the answer of this question.
Stay happy.
Stay blessed.
Stay healthy.
Sorry.
Answered by
9
Answer:
ᴏғᴛᴇɴ, ᴀ ᴜɴɪϙᴜᴇ ɪᴅᴇɴᴛɪғɪᴄᴀᴛɪᴏɴ ɴᴜᴍʙᴇʀ, sᴜᴄʜ ᴀs ᴀɴ ɪᴅ ɴᴜᴍʙᴇʀ ᴏʀ ᴀ sᴇʀɪᴀʟ ɴᴜᴍʙᴇʀ ᴏʀ ᴄᴏᴅᴇ, sᴇʀᴠᴇs ᴀs ᴀ ᴘʀɪᴍᴀʀʏ ᴋᴇʏ ɪɴ ᴀ ᴛᴀʙʟᴇ. ғᴏʀ ᴇxᴀᴍᴘʟᴇ, ʏᴏᴜ ᴍɪɢʜᴛ ʜᴀᴠᴇ ᴀ ᴄᴜsᴛᴏᴍᴇʀs ᴛᴀʙʟᴇ ᴡʜᴇʀᴇ ᴇᴀᴄʜ ᴄᴜsᴛᴏᴍᴇʀ ʜᴀs ᴀ ᴜɴɪϙᴜᴇ ᴄᴜsᴛᴏᴍᴇʀ ɪᴅ ɴᴜᴍʙᴇʀ. ᴛʜᴇ ᴄᴜsᴛᴏᴍᴇʀ ɪᴅ ғɪᴇʟᴅ ɪs ᴛʜᴇ ᴘʀɪᴍᴀʀʏ ᴋᴇʏ.
ᴏғᴛᴇɴ, ᴀ ᴜɴɪϙᴜᴇ ɪᴅᴇɴᴛɪғɪᴄᴀᴛɪᴏɴ ɴᴜᴍʙᴇʀ, sᴜᴄʜ ᴀs ᴀɴ ɪᴅ ɴᴜᴍʙᴇʀ ᴏʀ ᴀ sᴇʀɪᴀʟ ɴᴜᴍʙᴇʀ ᴏʀ ᴄᴏᴅᴇ, sᴇʀᴠᴇs ᴀs ᴀ ᴘʀɪᴍᴀʀʏ ᴋᴇʏ ɪɴ ᴀ ᴛᴀʙʟᴇ. ғᴏʀ ᴇxᴀᴍᴘʟᴇ, ʏᴏᴜ ᴍɪɢʜᴛ ʜᴀᴠᴇ ᴀ ᴄᴜsᴛᴏᴍᴇʀs ᴛᴀʙʟᴇ ᴡʜᴇʀᴇ ᴇᴀᴄʜ ᴄᴜsᴛᴏᴍᴇʀ ʜᴀs ᴀ ᴜɴɪϙᴜᴇ ᴄᴜsᴛᴏᴍᴇʀ ɪᴅ ɴᴜᴍʙᴇʀ. ᴛʜᴇ ᴄᴜsᴛᴏᴍᴇʀ ɪᴅ ғɪᴇʟᴅ ɪs ᴛʜᴇ ᴘʀɪᴍᴀʀʏ ᴋᴇʏ.ʜᴏᴘᴇ ɪᴛ's ʜᴇʟᴘs..⚡♦️
Similar questions