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 DATABASECST Please
NOTE # 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 # please complete option fully write codesand choose for hospital business.
NOTE # 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#Use db: Student and add the followingsuffix ProfGFP toall objects created under your schema eg Scityechdbdatabase.windows.net Write a pages proposal of the business problem that needs to be solved. This proposal should include a description of the organizationdepartmentName your product Explain its audience Explain your products contribution to the improvement of business Draw the Physical EntityRelationship Diagram ERDthat represents your database model. Normalized to NF aThere must be a minimum of tables in this database model Createpopulate and secure the entities rows each via stored procedureDescribe fifteen scriptsreportshow the newly implemented system would require for answering typical questions. Be very descriptive. Data security: at least three fieldsclients sensitive datainformation such as emailphone numbercredit cards etc. are expected to be secure and masked when on display. Identify and describe the business rulesprocesses that will be automated by the database application. 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 itData retention policy: data is kept indefinitely. There are numerous ways to resolve this issue, find one and implement itGenerate at least three payloads as Json output for downstream consumption. hint: use requirement #Write and test four userdefined functions. Functions must be used in either the stored proceduresor the viewsWrite and test seven stored procedures to implement the business rules. At least three of the store procedures must have error handling in its processing At least two of the store procedures must have transaction management in its processing At least one 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 store procedure
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
