Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PK is defined in context of a table ( entity ) so that it must uniquely identify a row in the table. I.e . ,

PK is defined in context of a table(entity) so that it must uniquely identify a row in the table. I.e., if i give you the value for PK it should return one and only one row from that table. PK can be a single attribute or a combination of attributes.
FK: is defined as an attribute in one relation which must be a Pk(or part of PK) in another relation. It is used to join (reference) tables.
Given the following relations identify PK and FK of each relation
CUSTOMER (cust_ID, cust_name, cust_address, cust_balance)
Now let's assume a new attribute account_ID is added
CUSTOMER_ACCOUNT(cust_id, acct_id, cust_balance)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems 6th Asian Conference Aciids 2014 Bangkok Thailand April 7 9 2014 Proceedings Part I 9 2014 Proceedings Part 1 Lnai 8397

Authors: Ngoc-Thanh Nguyen ,Boonwat Attachoo ,Bogdan Trawinski ,Kulwadee Somboonviwat

2014th Edition

3319054759, 978-3319054759

More Books

Students also viewed these Databases questions

Question

f. Did they change their names? For what reasons?

Answered: 1 week ago

Question

LO3 Discuss the steps of a typical selection process.

Answered: 1 week ago