1. Design an E-R diagram that captures the following: A company consists of departments and employees. A department has responsibility for zero, one or more projects. A company has: name, address and telephone. A department has name. A project has name. An employee has name, address, a social security number (SSN) and is participating in zero, one or more projects. Let the E-R diagram show: entities with attributes, relationships (with names) between the entities and cardinalities for the relationships.

Oracle 12c: SQL
3rd Edition
ISBN:9781305251038
Author:Joan Casteel
Publisher:Joan Casteel
Chapter1: Overview Of Database Concepts
Section: Chapter Questions
Problem 3MC
icon
Related questions
Question
1. Design an E-R diagram that captures the following:
A company consists of departments and employees. A department has responsibility for zero,
one or more projects. A company has: name, address and telephone. A department has name.
A project has name. An employee has name, address, a social security number (SSN) and is
participating in zero, one or more projects.
Let the E-R diagram show: entities with attributes, relationships (with names) between the
entities and cardinalities for the relationships.
2. Transform the E-R model into Relational model.
Transcribed Image Text:1. Design an E-R diagram that captures the following: A company consists of departments and employees. A department has responsibility for zero, one or more projects. A company has: name, address and telephone. A department has name. A project has name. An employee has name, address, a social security number (SSN) and is participating in zero, one or more projects. Let the E-R diagram show: entities with attributes, relationships (with names) between the entities and cardinalities for the relationships. 2. Transform the E-R model into Relational model.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Requirement Analysis
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
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning