.

I have an ERD for a banking system for a banking system and need help with some aspect of creating the database for it.

1. Create a database designto capture relationships between tables. Show Primary and Foreign keys. Note, N:M relationships have to be dissolved.

2. Create tables to match the entities in your ERD. (Specify table names, column names and data types. Make sure to capture primary and foreign keys and any other constraints)

3. Populate each table with atleast 20 rows.

4. Create a data dictionary to describe the database design.

Your submission should include the following:

- SQL scripts for create and insert statements.

- A copy of your database containing all tables and data saved as an '.sql' file extension

- A copy of your data dictionary in table format, either in word or excel.

- A database design

Name MemberID Member Social Security Number Address assigned Phone Number Email Addr Account Rate Savings Daily Balance checkings nteres Date AccountNum Date Balance Name MemberID Member Social Security Number Address assigned Phone Number Email Addr Account Rate Savings Daily Balance checkings nteres Date AccountNum Date Balance