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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!