This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd diagram. Also I would like to know the answers regarding the above mentioned queries in the question with sql command.

Thank you

Tommorrow is my deadline. I would really appreciate your answer as soon as possible and I would be really grateful for that.

This module is assessed by coursework (50%). For the coursework, the students are required to develop a database for an organization. The coursework/assignment should cover all of the following, but should also not be limited only to these features/functionalities: Creation of objects-Entities and Attributes Creation of Relationship Types Identify and include constraints (Such as not null, unique, Supertype, Subtype, etc.) Identity and include Primary Keys Foreign keys and unique keys. Normalization of the Relationships (INF) with Explanation of the process with reasoning Draw 2 ER Diagram, for initial (before normalization) and final (after normalization) with entities and relationships This coursework is about the design and implementation of a database for Masterpieces Limited. Part 1. Introduction (15%) Introduction of the business, its forte, ains, and objectives (5 marks) b. Description of Current Business Activities and Operations (5 marks) c. List of Business Rules that derived from the description of Operational Procedures that will be used in the system (5 marks). The rule affects the structure of the database schema. d. Identification of Entities and Attributes. The coursework should create the objects and attributes that are related to requirements gathered. (5 marks) Part 2. Initial ERD (5%) The initial Entity Relationship Model should be listed in this section and should include: a List of the created objects - Entities and Attributes b. Identification and representation of the Primary Keys. Forcign Keys. .Entity Relationship Diagram of the identified Entities with attributes and relationships (5 marks) Part 3. Normalization (20%) Normalize the data collected from Unnormalized form to Third Normal Form with valid process description. Produce a set of fully normalised tables for the system as described in the case study Show clearly all the steps of normalization. Demonstrate that each of your relations is in third normal form (NF) by displaying the functional dependencies between attributes in cach relation Part 4. Final ERD (10%) Part 5. Implementation (15 %) 2. Create relations and tables for the Masterpieces Limited database with the SOL Command and list the image of its resulting output. Ensure that referential integrity is established between related tables. (5 marks) b. Populate them with appropriate test data that is relevant to the questions listed below. List the screenshots of the SQL Command used and the overall rows of the table with an image of its resulting output. Enter at least 7 rows in cach table. Include the screenshot of the INSERT SQL Statement used to populate table data, along with the TABLES CONTENT displayed using SELECT statements. (5 marks) c. Drop tables according to order at the end of coursework. (5 marks) Part 6: Database Querying (20%) Part 7: Critical Evaluation (5 %) a Critical Evaluation of module, its usage and relation with other subject b. Critical Assessment of coursework (Students must provide two paragraphs) Part 8: Structure and Formatting (5%) Students will be awarded 2 marks for structure and formatting and 3 marks for providing dump files. Part 9: Database Dump file ution (5%) Submit all appropriate Oracle SQL scripts and screenshots of the resulting image of the output. Make sure each functionality report is documented separately and clearly mark cach piece of output and state its purpose. You are required to create and submit a dump file along with your coursework file A minimum of 5 Tables must be dexcloped after the termalication This module is assessed by coursework (50%). For the coursework, the students are required to develop a database for an organization. The coursework/assignment should cover all of the following, but should also not be limited only to these features/functionalities: Creation of objects-Entities and Attributes Creation of Relationship Types Identify and include constraints (Such as not null, unique, Supertype, Subtype, etc.) Identity and include Primary Keys Foreign keys and unique keys. Normalization of the Relationships (INF) with Explanation of the process with reasoning Draw 2 ER Diagram, for initial (before normalization) and final (after normalization) with entities and relationships This coursework is about the design and implementation of a database for Masterpieces Limited. Part 1. Introduction (15%) Introduction of the business, its forte, ains, and objectives (5 marks) b. Description of Current Business Activities and Operations (5 marks) c. List of Business Rules that derived from the description of Operational Procedures that will be used in the system (5 marks). The rule affects the structure of the database schema. d. Identification of Entities and Attributes. The coursework should create the objects and attributes that are related to requirements gathered. (5 marks) Part 2. Initial ERD (5%) The initial Entity Relationship Model should be listed in this section and should include: a List of the created objects - Entities and Attributes b. Identification and representation of the Primary Keys. Forcign Keys. .Entity Relationship Diagram of the identified Entities with attributes and relationships (5 marks) Part 3. Normalization (20%) Normalize the data collected from Unnormalized form to Third Normal Form with valid process description. Produce a set of fully normalised tables for the system as described in the case study Show clearly all the steps of normalization. Demonstrate that each of your relations is in third normal form (NF) by displaying the functional dependencies between attributes in cach relation Part 4. Final ERD (10%) Part 5. Implementation (15 %) 2. Create relations and tables for the Masterpieces Limited database with the SOL Command and list the image of its resulting output. Ensure that referential integrity is established between related tables. (5 marks) b. Populate them with appropriate test data that is relevant to the questions listed below. List the screenshots of the SQL Command used and the overall rows of the table with an image of its resulting output. Enter at least 7 rows in cach table. Include the screenshot of the INSERT SQL Statement used to populate table data, along with the TABLES CONTENT displayed using SELECT statements. (5 marks) c. Drop tables according to order at the end of coursework. (5 marks) Part 6: Database Querying (20%) Part 7: Critical Evaluation (5 %) a Critical Evaluation of module, its usage and relation with other subject b. Critical Assessment of coursework (Students must provide two paragraphs) Part 8: Structure and Formatting (5%) Students will be awarded 2 marks for structure and formatting and 3 marks for providing dump files. Part 9: Database Dump file ution (5%) Submit all appropriate Oracle SQL scripts and screenshots of the resulting image of the output. Make sure each functionality report is documented separately and clearly mark cach piece of output and state its purpose. You are required to create and submit a dump file along with your coursework file A minimum of 5 Tables must be dexcloped after the termalication