New Page 1
Welcome to basicsofcomputer.com
 

Share This Free Knowledge With Your Friends:

Home » Transformation of E-R Model into Relational Data Model » Types of Relationships in Database and Representing Relationship

Types of Relationships in Database and Representing Relationship:

There are three types of relationships in the E-R model such as unary, binary and ternary. The procedure to represent a relationship depends on the type of relationship and the cardinalities of the relationship.

The type of relationships and their representation is described below.

Representing Binary Relationship

Representing Unary Relationship

Representing Ternary Relationship

Representing IS-A Relationship

Relevant Articles:

Steps to Convert E-R Model into Relational database design
Representing Entities
Types of Relationships in Database and Representing Relationship
Normalize the Relation
Representing Entities Case Study
 
New Page 1

Basic Computer Science
   
» The Age of Information
» Types of Computer and Digital Age
» Input and Output Devices
» Storage Devices Of Computer
» Central Processing Unit
» Software: The Power Behind The Power
» Data Communication and Computer Networks
» The Nature Of Information
» The System Theory
» Transaction Processing System (TPS) and Management Information System (MIS)
» Decision Support System (DSS) and Executive Support System (ESS)
» Expert System (ES) and Office Information System (OIS)
 

Operating Systems
   
» Introduction to Operating System
» Introduction to Process Management
» Threads and CPU Scheduling
» Process Synchronization in Operating System
» Deadlocks
» Memory Management in Operating System
» Virtual Memory in Operating System
» File System Management in Operating System
» I/O and Device Management
» Security
» Linux Operating System
 

Database Management System
   
» Introduction to Database Systems
» Database System Architecture
» Database Administration and Database Development Process
» The Entity-Relationship Model
» Semantic Object Model
» Logical Database Design and Relational Data Model
» Normalization in Database
» Transformation of E-R Model into Relational Data Model
» Representing Semantic Object Model and Types of Semantic Object Model
» Physical Database Design
» Introduction to Structured Query Language (SQL)
» Implementation of Relational Database and Database Application Design
» Client Server Database Systems & Open Database Connectivity (ODBC)
 

Questions and Answers
   
» Basics of Information Technology
» Computer Architecture
» Data Communication
» Information Networks
» Fundamentals of the Internet
» Application and Uses of Computer
» Security, Copyright and The Law
» Windows Operating Systems
» Spreadsheet Software
» Process Management in CPU
» CPU Scheduling
» Process Synchronization
» Deadlocks
» Memory Management
» Database Systems
» Database System Architecture
» Database Administration and Database Development Process
 
 
New Page 1
 

Home                Dictionary                 Contact us                   About us                    Privacy policy                  Link to us                   Advertise

Copy right ©  2012