Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

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
(
expand button
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
expand button
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
Check Mark
Knowledge Booster
Background pattern image
Computer Science
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
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education