Translate the E-R diagram on page 1 (diagram) to database schema using MySQL Workbench (export as png or pdf). You can ignore the cardinalities on the ternary (Grant) relationship.

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

Translate the E-R diagram on page 1 (diagram) to database schema using MySQL Workbench (export as png or pdf). You can ignore the cardinalities on the ternary (Grant) relationship.      

 

Interpret the database schema on slide 4. Draw the E-R diagram underlying this schema. No need to draw the attributes. 

Skills
Skill ID
Skill
Name
University
ID
University
Name
University
Location
have
Universities
Person
ID
Person
Name
Person
Gende
grant
People
Connect
Degrees
Date
Granted
Degree
ID
work for
End
Date
Degree
Name
Start
Date
Company Company
ID Name
Companies
(
Transcribed Image Text:Skills Skill ID Skill Name University ID University Name University Location have Universities Person ID Person Name Person Gende grant People Connect Degrees Date Granted Degree ID work for End Date Degree Name Start Date Company Company ID Name Companies (
This is
"supervises"
HR/Payroll
employee
◆FName VARCHAR(30) +
Minit CHAR(1)
LName VARCHAR(30) H
SSN CHAR(9)
BDate DATE
> Address VARCHAR(50)
Gender CHAR(1)
>Salary DECIMAL (15,2)
◆DNumber TINYINT
SuperSSN CHAR(9)
has
Indexes
ses I
manages !
dependent
↑ EmployeeSSN CHAR(9)
DependentName VARCHAR(65)
→Gender CHAR(1)
BDate DATE
Relationship VARCHAR(30)
Indexes
department
DNumber TINYINT
◆ DName VARCHAR(30)
MgrSSN CHAR(9)
MgrStartDate DATE
Indexes
works in
IS Tocated al
Indexes
dept_locations
HI-
? DNumber TINYINT
DLocation VARCHAR(30)
has
works_on
? ESSN CHAR(9)
KPNumber TINYINT
◆ Hours INT
Indexes
project
PNumber TINY INT
PName VARCHAR(60)
PLocation VARCHAR(30)
◆DNumber TINYINT
Indexes
Transcribed Image Text:This is "supervises" HR/Payroll employee ◆FName VARCHAR(30) + Minit CHAR(1) LName VARCHAR(30) H SSN CHAR(9) BDate DATE > Address VARCHAR(50) Gender CHAR(1) >Salary DECIMAL (15,2) ◆DNumber TINYINT SuperSSN CHAR(9) has Indexes ses I manages ! dependent ↑ EmployeeSSN CHAR(9) DependentName VARCHAR(65) →Gender CHAR(1) BDate DATE Relationship VARCHAR(30) Indexes department DNumber TINYINT ◆ DName VARCHAR(30) MgrSSN CHAR(9) MgrStartDate DATE Indexes works in IS Tocated al Indexes dept_locations HI- ? DNumber TINYINT DLocation VARCHAR(30) has works_on ? ESSN CHAR(9) KPNumber TINYINT ◆ Hours INT Indexes project PNumber TINY INT PName VARCHAR(60) PLocation VARCHAR(30) ◆DNumber TINYINT Indexes
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
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