Dete Adess Year of_death Purchase date Number_of entais Nane Year of Jath Code Times eted Number Bonus Bithplece ТАРЕ RENTED_TO CUSTOMER Nene Number STAR CONTANS Name Manber Rule PLAYEDN MOVE DIRECTED BY DIRECTOR Yer_of Jath Awards wan Year of death Tie Nominations Year Crtics ating Type

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

Convert the following ER diagrams into relational schemas 

Date
Addess
Year of_death
Purchase_date
Number_of_rentals
Name
Year of th
Code
Times_rented
Number
Bonus
Bithplace
TAPE
RENTED_TO
CUSTOMER
Nane
Number
STAR
CONTANS
Name
1
Number
Role
PLAYED_IN
MOVIE
DIRECTED_BY
DIRECTOR
Year_of Jairth
Nmbe
Awards wan
Year of denth
Tle
Nominations
Year
Crtics ating
Туре
Transcribed Image Text:Date Addess Year of_death Purchase_date Number_of_rentals Name Year of th Code Times_rented Number Bonus Bithplace TAPE RENTED_TO CUSTOMER Nane Number STAR CONTANS Name 1 Number Role PLAYED_IN MOVIE DIRECTED_BY DIRECTOR Year_of Jairth Nmbe Awards wan Year of denth Tle Nominations Year Crtics ating Туре
Expert Solution
Step 1

 we need to convert given E-R diagram to Relational schema.

For N: M relation we have created a New table/relation  PLAYED_IN that contain foreign key of both star and Movie Table.

1:1 or 1:N relationship types  , we have migrated primary key of one relation to other relation as foreign key.

steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY