Question
When we translate a 1:N relationship in an ERD to a relational schema, we add the primary key of one-side entity to the many-side entity
When we translate a 1:N relationship in an ERD to a relational schema, we add the primary key of one-side entity to the many-side entity as a foreign key.
a) Why should we do so?
b) What happen if we add the PK of N-side entity to one-side entity?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
The Database Experts Guide To Database 2
Authors: Bruce L. Larson
1st Edition
0070232679, 978-0070232679
