Question: PRIMARY KEY based on data for an entity DEPT DEPTCODE Information Systems and Operations Management ISOM Management MGMT Finance FNAN Accounting ACCT Marketing MKTG Business
PRIMARY KEY based on data for an entity
DEPT
DEPTCODE
Information Systems and Operations Management
ISOM
Management
MGMT
Finance
FNAN
Accounting
ACCT
Marketing
MKTG
Business Foundations
BUSF
For an entity DEPARTMENT, both department name and DEPTCODE are both always present and always unique.
Which of the following statements are correct?
Composite of DEPT DEPTCODE is required to serve as primary key
DEPT is a candidate key
DEPTCODE would be better suited than DEPT as a primary key
DEPTCODE is a candidate key
DEPT would be better suited than DEPTCODE as a primary key
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
