1. Create Relational Database Model (RDM) for Sailing bed and breakfast club as follows (10 marks) Table_Name( attribute_1, attribute_2, attribute_3, ? ,attribute_x) Primary Key ( attribute_1, attribute_2) Foreign Key attribute_4 References Table_Name_2 (repeat for each foreign key) Additionally primary keys should be underlined. 2. Specify a data dictionary as follows (20 marks) Assessment 2 – Part A – Database Creation Part B – Database Application BIT201 Database Systems - 2015 3. Create Database (Use MS Access)  Use MS Access to create a table for each table identified in the relational data model (RDM) (20 marks).  All create table SQL statements must be saved within your MS Access database.  All CREATE TABLE SQL statements included in your MS Word format submission (20 marks).  Create relation diagram in MS Access and include MS Access Relationship Diagram in MS Word(20 marks)  The tables can only be created in a specific order with regards to referential integrity. Please ensure you provide the SQL CREATE TABLE statements in the correct order.  For each table you MUST provide 3 SQL INSERT INTO statements which must be printed in your MS Word submission (10 marks).  The remaining data for each table may be typed in using MS Access datasheet. Screen shot/Screen dump of MS Access datasheets for each table should be included should be included in your MS Word submission