According to the scenario, we need to create er diagram then, relational schema , normalisation and assumptions made. then, we need to create one database and crate tables and insert the data in the...

According to the scenario, we need to create er diagram then, relational schema , normalisation and assumptions made. then, we need to create one database and crate tables and insert the data in the table. (data is given in a sample file ... the data should be similar with the given data.). diffrent queries are given so, we need to query them and we need to screenshot the query written and the output and display in the word file. details are given in page no.7