SQL Server + DBSchema

The work is described and explained in a file. I intend to get the job done in 6/7 days. Objectives of the work:~ • Create a database that allows managing the resources and services provided by the city council. • Implement a client application to access the database and carry out operations necessary for its operationalization. Tasks to perform • In the development of the database, you can use DBSchema or [login to view URL] to create diagrams, or ERDPlus to create the relationship entity diagram, the relational model and the required SQL code. Alternatively. • The database management system to do the job is SQL Server. • The database must be implemented using an SQL script. • You must create a backup of the database with the data model and inserted data, which then allows you to reconstruct the database on any machine running SQL Server. • The database must be prepared to answer the questions mentioned in the introduction through: consultations, inserts updates and removals of data for the various types of users. • When deriving from the relationship entity diagram and the corresponding relational scheme. Keep in mind that the tables derived from the relational model must be normalized, assuming for the unspecified situations the solutions that seem more plausible. In development it must also explicitly indicate the choices made. • Develop the client application that allows you to interact directly with the database. In application development customers can use the tool they consider most appropriate. Below is a list with several alternatives for tools and examples of client applications developed in Java, FreePascal, C #, Python and Radzen for SQL Server (at work you must use SQL Server as DBMS).