Please help me to finish this project for my Computer Class $($DATABASE$),$CST$4714$

Please present the functionable SQL CODE for Functions, Stored Procedures, Triggers. please make sure its unique from others results. Make it UNIQUE, please. complete all options fully for all $12$ steps $($ make sure

SQL code for step $2$a$,4,9,10,11,12,$

ER diagram

$$and choose for hospital business$)$

Thanks in advance $!$

Objective:

The objective of this project is to give some practical experience in designing, implementing, and maintaining a database application.

Your job is to find a business situation where a database application system seems desirable and design a simulation of a commercial product.

$$

Reminders and considerations:

DBA provides service support and service delivery to ensure a comprehensive, coordinated system that manages the data.

Data integrity implications

The following are the project$$s deliverables:

Access SQL Server to complete Assignment#$2.$

Write a $23$pages proposal of the business problem that needs to be solved.

This proposal should include a description of the organization$/$departmentName your product

Explain its audience

Explain your product$$s contribution to the improvement of business

$2.$Draw the Physical Entity$-$Relationship Diagram $($ERD$)$that represents your database model. $($Normalized to $3$NF$)$

a$.$There must be a minimum of $10$tables in this database model

$3.$Create$,$populate$,$ and secure the entities $(30$rows each via stored procedure$)$

$4.$Describe fifteen scripts$/$reports$,$how the newly implemented system would require for answering $15$typical questions. Be very descriptive.

$5.$Data security: $($at least three fields$)$client$\text{'}$s sensitive data$/$information such as email$/$phone number$/$credit cards etc. are expected to be secure and masked when on display.

$6.$Identify and describe the business rules$/$processes that will be automated by the database application.

$7.$Business indicates that the system becomes very slow when some canned reports are running. There are numerous ways to resolve this issue, identify one and implement it$.$

$8.$Data retention policy: data is kept indefinitely. There are numerous ways to resolve this issue, find one and implement it$.$

$9.$Generate at least three $(3)$payloads as Json output for downstream consumption. $($hint: use requirement #$4)$

$10.$Write and test four $(4)$user$-$defined functions.

$-$Functions must be used in either the stored procedures$$or the views$.$

$11.$Write and test seven $(7)$stored procedures to implement the business rules.

$-$At least three $(3)$of the store procedures must have error handling in its processing

$-$At least two $(2)$of the store procedures must have transaction management in its processing

$-$At least one $(1)$of the store procedures must be nested $$called by another store procedure and return a status to its caller. The caller must evaluate the return status

$-$All seven $(7)$store procedures must have adequate and appropriate comments

$12.$Write and test seven $(7)$triggers for seven $(7)$separate tables to implement the business rules.

At least two $(2)$of the trigger must be for deleteAt least one $(1)$of the trigger must be for insertAt least two $(2)$of the trigger must be for updateAt least one $(1)$of the trigger must be for insert$/$delete$/$update

Think of a business problem that requires the processing of data system for Hospital. They are also ideally suited to implement transaction management and error handling techniques.