write my assignment 4568
Database: Convert the E-R diagrams to relational schema and show:
• Primary Keys (using underline)
• Foreign Keys (using dotted underline)
• Referential Integrity
Your schema should look similar to the example below:
- Attachment 1
- Attachment 2
Convert the E-R diagrams to relational schema and show:Primary Keys (using underline)Foreign Keys (using dotted underline)Referential IntegrityYour schema should look similar to the example below:CUSTOMERCustNOCustNameL…ORDEROrderNoOrderDateCustNo1,EMPLOYEEBilingRatePROJECTEmpDEmpNameProjectIDProject Title2.BillingRateEMPLOYEEPROJECTEmpDampName"runs0- ProjectIDProject Tile3.managesBilingRateEMPLOYEEPROJECTEmpID.assigned to-..EmpName0- ProjectIDProject Title