Question: Please help me to finish this project for my Computer Class ( DATABASE ) , CST 4 7 1 4 Please NOTE # 1 Present

Please help me to finish this project for my Computer Class (DATABASE),CST4714 Please
NOTE # 1 Present the functionable SQL CODE for Functions, Stored Procedures, Triggers. please make sure its unique from others results. I don't want to put similar answer which is available in online. make it unique for me please.
NOTE # 2. please complete option 11fully (write 7,3,2,1codes),and choose for hospital business.
NOTE #3. PLEASE FINISH WHOLE PROJECT FOR ME, DON'T SKIP ANY POINTS. 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. (Do not choose a too simple or an extremely complicated problem). 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 projects deliverables: Access SQL Server to complete Assignment#2.Use db: Student and add the followingsuffix ProfG_FP toall objects created under your schema (e.g S125).cityechdb1.database.windows.net Write a 23pages 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 products contribution to the improvement of business 2.Draw the Physical Entity-Relationship Diagram (ERD)that represents your database model. (Normalized to 3NF) a.There must be a minimum of 10tables in this database model 3.Create,populate, and secure the entities (30rows each via stored procedure)4.Describe fifteen scripts/reports,how the newly implemented system would require for answering 15typical questions. Be very descriptive. 5.Data security: (at least three fields)client'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 proceduresor 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 procedure

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!