Answered: Given the following conceptual…

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

See similar textbooks

Related questions

Concept explainers

Question

Given the following conceptual representation:

Based on the participation of Department and Employee in manages, what can you conclude?
c) Based on the cardinality of works, what can you conclude? Explain the corresponding business rule
d) Mention one alternate key for Project
e) What is supervises in this diagram? Provide as many details as possible
f) Convert the E-R diagram into tables. You can draw tables or provide the Relational Schema
g) What do you need to modify to specify that every employee must have a supervisor? Details matter
h) How would you include suppliers in this diagram? Provide a clear explanation and illustrate your answer with an extract of your original E-R diagram

SIN
emplD
employs
firstName lastName
M
middleName
1
Name
Employee M
1 M
manages
1
Department
address
depID depName
age
supervises
works
depLocation
1
M
projlD
country
projLocation province
Project
city
Duration
codeName
budget

Expert Solution

Step by step

Solved in 4 steps with 3 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

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