Assessment Details:Title: Design and development of a Database System for an Enterprise Individual courseworkStyle: Labexercise and Individual report and SQL Script for the developed database.These exercises will help students develop their skills in executing and implementing SQLcommands Final ProjectCase Study: Design and develop a Database system for Software Company. A software companywishes to install a database to help in the monitoring and correcting of errors that are discovered inits software products. Each software product has a product identification number and description. Inaddition, there may be several different versions of the product released in the field, or underdevelopment, at any time. Versions are identified by the version number and a version name andhave a release date. Each version of the product needs to be registered before it can be sold to theexternal user. A version of a product may it used by users, for each user we safe name, and phonenumber. We have two different types of users external to the organization, or internal users such asprogrammers or system testers. When a product version is sold to an external user, each version ofthe product is allocated a registration number and a date of registration, while the internal user canuse each version of the product without registration. If a user encounters a problem with a product, aproblem report is sent to the companys quality assurance teamproblem reports submitted byinternal or external users. A problem report records the description of problem along with the dateon which it was submitted. If a problem report is sending by an external user, the company namemust be recorded. Internal users do not have a company name, but their department is recordedwhen submitting problem reports. When a report is received, the quality assurance team allocates aproblem report number and then passes the report to the software maintenance department. Qualityteam also allocate a priority rating and record the status of the report as \'with maintenance. Themaintenance department consists of a number of maintenance teams, each of which has a uniquename and a team leader. Software products are maintained by a number of maintain departments. Aproblem report is allocated to a specific quality assurance team who updates the status asappropriate; \'fixed\', in progress\', \'not a problem.As part of this project, you will: Critically evaluate existing database technologies and suggest which will be best forSoftware Company Design a database system using normalisation techniques and create an ERD diagram State any assumptions that you have made and applied Develop a database system schema and implement the design system State anyassumptions that you have made and applied. o Create a set of tables and relation requiredfor the system. o Populate your tables with Software Company data sets o Create queries andviews based on every service requirement of the dataset Apply advanced database techniques State any assumption that you have madeand applied. o Apply security measures define users, assign privileges.Additional information:The final report structure should include: Title Page Contents PageCritical Evaluation of database systems for an enterprise Database Designo Entity relationship diagram ERDlogical model oRelation schema mapping Database Development Implementation o Physical model of the system for theselected enterprise o Tables and Relations o Queries Examples Security Scenario