Share
Notifications

View all notifications

Observe the Following Table Carefully And· Write the Names of the Most Appropriate Columns, Which Can Be Considered as (I) Candidate Keys And. (Ii) Primary Key: - Computer Science (C++)

Login
Create free account


      Forgot password?
ConceptIntroduction to Data Base Concepts and Its Need in C++

Question

Observe the following table carefully and· write the names of the most appropriate columns, which can be considered as (i) candidate keys and. (ii) primary key:

Code Item Qty Price Transaction Date
1001 Plastic Folder 14" 100 3400 2014-12-14
1004 Pen Stand Standard 200 4500 2015-01-31
1005 Stapler Mini 250 1200 2015-02-28
1009 Punching Machine Small 200 1400 2015-03-12
1003 Stapler Big 100 1500 2015-02-02

Solution

Candidate keys : Code, Item

Primary keys : Code

  Is there an error in this question or solution?

APPEARS IN

Solution Observe the Following Table Carefully And· Write the Names of the Most Appropriate Columns, Which Can Be Considered as (I) Candidate Keys And. (Ii) Primary Key: Concept: Introduction to Data Base Concepts and Its Need in C++.
S
View in app×