Home / Expert Answers / Computer Science / please-help-me-to-finish-this-project-for-my-computer-class-database-cst4714-please-prese-pa976

(Solved): Please help me to finish this project for my Computer Class ( DATABASE), CST4714 Please prese ...



Please help me to finish this project for my Computer Class ( ?DATABASE), ?CST4714 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 2a, 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 2 – 3 ?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 3NF) ? 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'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.



We have an Answer from Expert

View Expert Answer

Expert Answer


We have an Answer from Expert

Buy This Answer $5

Place Order

We Provide Services Across The Globe