PART 3Relational ModelEMPLOYEEFname Minit Lname Ssn Bdate Address Sex SalaryAAAADEPARTMENTDnamc Dnumber Mgr_san Mgr_start_datcAAADEPT_LOCATIONSDnumber DlocationPROJECTPname Pnumber Plocation DnumWORKS ONEssn Pno HoursDEPENDENTEssn Dependent_name Sex Bdate RelationshipDrawn the ER diagramSuper_ssn Dno

Answered: Relational Model EMPLOYEE Fname Minit…

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

Question

PART 3
Relational Model
EMPLOYEE
Fname Minit Lname Ssn Bdate Address Sex Salary
AAAA
DEPARTMENT
Dnamc Dnumber Mgr_san Mgr_start_datc
AAA
DEPT_LOCATIONS
Dnumber Dlocation
PROJECT
Pname Pnumber Plocation Dnum
WORKS ON
Essn Pno Hours
DEPENDENT
Essn Dependent_name Sex Bdate Relationship
Drawn the ER diagram
Super_ssn Dno

Expert Solution

Step 1: Description about ER diagram

What Is ER Diagram:

ER, suggests the relationship between one entity to every other entity, and the ER diagram allows us to explain the flow and shape of the database layout and the logical shape of the database layout. ER diagram equally appears like the waft chart of the device.

What are the additives of the ER diagram?

A)Entity

b)Relationships

c)Attributes

What is an entity:

An entity is a single object. A single item is supposed to be a person, location, aspect, or a couple of entities called the ER diagram.

What are the attributes:

Attributes describe the functions of a single entity, the excellence of the entity, and the elements of a selected entity.

Step by step

Solved in 3 steps with 1 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