the the number name the number the birth the Date name name number Phone section Works N the employee for him Son genter name N Manges project the mumber (start Date

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

The given figure represents the entity and relationship model to represent employee data And their departments and their children in an industrial company

What is required is to convert the shape into an equivalent database schema

the
the number
The
number
name
the
birth
the
Date
name
name
number Phone
section
the
N
Works
employee
for him
N
Son
gender)
name
marges
N
Project
the number
Start Date
Transcribed Image Text:the the number The number name the birth the Date name name number Phone section the N Works employee for him N Son gender) name marges N Project the number Start Date
Expert Solution
Problem :
  • In this question, we have 4 entities that are Section, the employee, son, and project.
  • Each entity has some attribute and is in relationship with other entities.
  • We have to find the equivalent database schema.
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education