Design a relational schema based on the Entity-Relation Diagram (ERD) or Enhance

Question

Design a relational schema based on the Entity-Relation Diagram (ERD) or Enhanced EntityRelation Diagram (EER) attached. All relations must be in 3NF. In each relation, underline the primary key and the foreign key(s), if any, with a solid line and a broken line, respectively. You should also specify, for each foreign key, the relation it references. This is accomplished by the arrow used to show referential integrity. Also, select data types for each columns in your logical schema. You do not need to provide reasons for each datatype, however, your choices should be reasonable.  

CREDIT UNION EMPLOYEES Branch Name County City Employee iD assigned DEPARTMENTS Department Name Head of Department obtain Hourly Rate AccOun ID open by manages Branch Id Account Type Rate JOB TITLES TRANSACTION Title Name Title Desciption include Transaction Type Transaction Name Status open TRANSACTIONS CUSTOMERS Company Name DateTime Email Contact Title ACCOUNT TYPES Employee ID Type ID Type Name made by work for LOANS COMPANIES Interest Rate Company ID Company Name Contact Te

Explanation / Answer

Relational schema refers to database tables design.
Here are the Relational Schema ..

CUSTOMERS(
CustomerID: INT Primary
company name: varchar
phone: INT
Email: varchar
contact Title: varchar
)

---------------------------------------------------------
TRANSACTON_TYPES(
Transaction Type: char Primary
Transaction Name: char
Description: char
)

-----------------------------------------------------------
JOB_TITLES(
Title ID: INT,Primary
Title Name: varchar
Title Description: varchar
)
-------------------------------------------------------------
DEPARTMENTS( Department ID: INT Primary
Department name: varchar
head of Department: varchar
)
-------------------------------------------------------------
ACCOUNT TYPES(
Type ID: INT primary
Type Name: varchar
Description: varchar
Rate Range: DOUBLE
)
---------------------------------------------------------------
CREDIT UNION BRANCHES(
Branch ID: INT primary
Branch Name: varchar
country: varchar
City: varchar
Phone: INT
Manager ID: Foreign INT Reference Manager)
------------------------------------------------------------------
ACCOUNTS (
AccountID: INT Primary
BranchID: INT Foreign Reference CREDIT UNION BRANCHES
CustomerID: INT Foreign Reference CUSTOMERS
Account Type: varchar
Balance: DOUBLE
Rate: DOUBLE
Status: varchar
)
-------------------------------------------------------------------
LOANS(
Loan ID: INT primary
DurationByMonth: INT
InterestRate: INT
Start Date: DATE)
-----------------------------------------------------------------------
COMPANIES(
Company ID: INT primary
Compant Name: varchar
Phone: INT
Email: varchar
Contact Title: varchar)
------------------------------------------------------------------------
Employees(
Employee ID: INT Primary
BranchID: INT Foreign Reference CREDIT UNION BRANCHES
Title ID: INT Foreign Reference JOB_TITLES
Department ID: INT Foreign Reference DEPARTMENTS
Manager ID: INT Foreign Reference Manager
Salary : INT
Hourly Rate: INT
Level: INT
Password: varchar)
-----------------------------------------------------------------------------

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.