To implement the database 1. Translate the ER diagram provided into a relational schema using the correct notations and standards for this course. It should include: a. Table names b. Attribute names...

To implement the database

1.    Translate the ER diagram provided into a relational schema using the correct notations and standards for this course.  It should include:

a.    Table names

b.    Attribute names and field types (as required by XAMPP)

c.    Primary and foreign keys identified

2.    Create a text file called nnnn_create.sql (where nnnn is your student number).   The file should include:

a.    The SQL statements to create a database called BHE_Holdings_nnnn.txt (where nnnn is your student ID)

b.    The SQL statements to create the tables and the relationships between them.
3.    Create a text file called nnnn_insert.txt (where nnnn is your student number).  The file should include:

a.    The SQL statements to load sufficient data into each table you have created to test the queries given below.  Sample data has been provided, but you will need to include further data test the requirements.  You should add at least one record to the existing test data for each table.

To implement the database

1.    Translate the ER diagram provided into a relational schema using the correct notations and standards for this course.  It should include:

a.    Table names

b.    Attribute names and field types (as required by XAMPP)

c.    Primary and foreign keys identified

2.    Create a text file called nnnn_create.sql (where nnnn is your student number).   The file should include:

a.    The SQL statements to create a database called BHE_Holdings_nnnn.txt (where nnnn is your student ID)

b.    The SQL statements to create the tables and the relationships between them.

3.    Create a text file called nnnn_insert.txt (where nnnn is your student number).  The file should include:

a.    The SQL statements to load sufficient data into each table you have created to test the queries given below.  Sample data has been provided, but you will need to include further data test the requirements.  You should add at least one record to the existing test data for each table.