Answer Happy

Posted: **Sun Jul 03, 2022 9:59 am**

: Name Conic Entity Relationship Diagram View Bate No Customer Has Loan Rate View Apply Loan Type Name Loan Type Manage Ma 1 (38.26 KiB) Viewed 22 times

ERD to the relational mapping of this diagram(map allthe relations and link them as mentioned in the examplebelow)

: Name Conic Entity Relationship Diagram View Bate No Customer Has Loan Rate View Apply Loan Type Name Loan Type Manage Ma 2 (69.58 KiB) Viewed 22 times

Name CONIC ENTITY RELATIONSHIP DIAGRAM view Bate No Customer has Loan Rate view Apply Loan type Name Loan type Manage Manage No. of employees -ot Loan Application A CNIC Application Admin IMID Bank Branch Manage Manage EMI Details view Loan type Name Location Loan Details Manage EMI Amount Recept No Lean 10 Customer Name Receipt Date Customer Details Customer Manage EMI Payment Details LO view has view
EMPLOYEE Fname Minit Lname Ssn Bdate AAAA DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours Address Sex DEPENDENT Essn Dependent_name Sex Bdate Relationship Salary Super_ssn Dno Figure 9.2 Result of mapping the COMPANY ER schema. into a relational database schema.