[go: up one dir, main page]
Scribd
Upload
5 views9 pages

Examples of Mapping

The document outlines the mapping of E-R models to relational models for various systems including banking, car insurance, and hospitals. It details the required tables for each system, such as Account and Branch for banking, and patients and doctors for hospitals. Additionally, it presents a final relational schema for a weak entity involving manufacturers, parts, and orders.

Uploaded by

mohitsaw100
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
5 views9 pages

Examples of Mapping

The document outlines the mapping of E-R models to relational models for various systems including banking, car insurance, and hospitals. It details the required tables for each system, such as Account and Branch for banking, and patients and doctors for hospitals. Additionally, it presents a final relational schema for a weak entity involving manufacturers, parts, and orders.

Uploaded by

mohitsaw100
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 9

Problems on Mapping of E-R Model

to Relational Model
Adyasha Rath
Assistant Professor, CSE Dept, CGU
E-R Diagram of Banking Management System
Applying the rules that we have learnt, minimum 6 tables
will be required-
•Account (Ac_no , Balance , b_name)
•Branch (b_name , b_city , Assets)
•Loan (L_no , Amt , b_name)
•Borrower (C_name , L_no)
•Customer (C_name , C_street , C_city)
•Depositor (C_name , Ac_no)
E-R Diagram of a Car-insurance Company
Car insurance tables:
person (driver-id, name, address)
car (license, year, model)
accident (report-number, date, location)
participated(driver-id, license, report-number, damage-amount)
E-R Diagram of a Hospital
Hospital tables:
patients (patient-id, name, insurance, date-admitted, date-
checked-out)
doctors (doctor-id, name, specialization)
test (test-id, test-name, date, time, result, patient-id)
doctor-patient (patient-id, doctor-id)
performed-by (test-id, doctor-id)
E-R Diagram of a Weak Entity
Final relational schema after reduction is as follows;
Manufacturer (name, street, city)
Part (part_num, description, name)
Customer (ID, Name)
Order (order_num, ID, part_num, Quantity)

You might also like