please use c# and question is in the images

project must meet the following requirements:

Your architecture must be based upon the 3-tier client/server model.

Your user interface layer may be either graphical or character based.

The user interface layer must communicate only with the data access logic. Direct database communication from the user interface layer is prohibited.

The system must be able to dynamically locate the database (no hardcoded paths).

The system must be able to add a new record.

The system must be able to update an existing record.

The system must be able to logically delete a record.

The system must be able to logically undelete a record.

The system must be able to purge (physically delete) a record, but only if it is already logically deleted.

The system must support searching for a record by a data field other than the primary key.

The system must be able to display a single record to the user interface.

All SQL must be parameterized. The concatenation of parameter values directly into SQL is prohibited.

All input data MUST be validated both at the user interface and at the server.

An operation must not be allowed to fail due to invalid or missing data (error handling must exist to catch such conditions).

Helpful messages must be displayed to the user for validation errors or any other system related error.

Create a MS Axcees prototvpe of your database. The database must contain the following: 1. A master table, which will contain the data for yeur project. 2. The miaster table must set appropriate data types and sices for euch field. 3. A minimum of one support table. 4. A words and abbreriations table that containe words and their assaciated abbreviations. Name this table SYTDO1_WORD_A.OBRCV_LKP. 5. Provide a M5 Word document that explains your database naming convertions. This document must explain the databae file naming comvention, the table naming comvention, and the ficld naming convention. 6. Pravide descriptions for eath lield [this can be done with the table designer in MS Ancess). 1. Provide a description for each table ithis can be done within the properties for each tablel Provide a description of the database. This will be placed in the database comments field. This field is in the File | Info | Database Properties section Create a MS Axcees prototvpe of your database. The database must contain the following: 1. A master table, which will contain the data for yeur project. 2. The miaster table must set appropriate data types and sices for euch field. 3. A minimum of one support table. 4. A words and abbreriations table that containe words and their assaciated abbreviations. Name this table SYTDO1_WORD_A.OBRCV_LKP. 5. Provide a M5 Word document that explains your database naming convertions. This document must explain the databae file naming comvention, the table naming comvention, and the ficld naming convention. 6. Pravide descriptions for eath lield [this can be done with the table designer in MS Ancess). 1. Provide a description for each table ithis can be done within the properties for each tablel Provide a description of the database. This will be placed in the database comments field. This field is in the File | Info | Database Properties