logo

Database Design for Desklib Online Library

   

Added on  2023-06-15

6 Pages712 Words495 Views
Running head: DATABASE DESIGN
Database Design
Name of Student-
Name of University-
Author’s Note-

1DATABASE DESIGN
1. Entity-Relationship Diagram
Figure 1: Entity-Relationship Diagram

2DATABASE DESIGN
2. Assumptions and Business Rules
Business Rules that are taken for the Entity-Relationship Diagram:
Entities Relationship
AGENT_INFORMATION- CUSTOM_AGENT: One - one relationship
AGENT_INFORMATION- CUSTOM_INFORMATION: One - many relationship
CUSTOM_INFORMATION - PRO_INFO: One - many relationship
CUSTOM_INFORMATION - ACDNT_INFORMATION: One - many relationship
CUSTOM_INFORMATION - PLCY_INFORMATIONRMATION: One - many relationship
CUSTOM_INFORMATION - PAYMENT_INFORMATION: One - many relationship
PRP_INFORMATION- PLCY_INFORMATION: One - one relationship
ACDNT_INFORMATION - PLCY_INFORMATION: One - one relationship
PLCY_INFORMATION - PAYMENT_INFORMATION: One - one relationship
3. Assumptions made for the ERD:
The CUSTOM_AGENT has a relation with AGENT_INFORMATION entity. In this
relation, A_ID and C_ID are the foreign keys. The relation between AGENT_INFORMATION
and the CUSTOM_AGENT has a 1:1 relationship. C_ADDRESS and C_PHNUM are the multi-
valued attributes. The CUSTOM_AGENT is a weak entity.

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Design of CQ Insurance
|6
|625
|494

CQ Insurance Database Diagram
|6
|635
|103

Database Design of CQ Insurance
|6
|661
|323

(solved) Organic Pastures Clinic
|5
|452
|395

ISY1002 Database Management Business Assignment
|8
|949
|75

Database Design: Entity Relationship Diagram, Assumptions, Logical and Physical Design
|8
|841
|205