term project deliverable 4 details are given below | Academic Help

Term Project – Deliverable 4
For prior deliverables, you have framed your design by providing a list of structural business rules as well as a conceptual ERD. You have also received additional feedback and have continued augmenting your database skills with additional course material and experience. Your design is well on its way! You are ready to create a logical ERD for your project. Recall that logical ERDs are tied to relational model and contain primary and foreign key constraints. Further recall that entities are normalized in logical ERDs.
To make sure your logical ERD works both in theory and in practice, now is the time to begin implementing the SQL for Aspect 1. Recall that each aspect in this project has four components – the tables and constraints, a reusable stored procedure, example usages of the procedure, and a query.
As you begin writing the SQL for this aspect, you may realize that your design must be altered or enhanced in order to support the data and relationships needed, which is perfectly reasonable. You will just want to ensure that changes to the design are reflected consistently in the business rules, conceptual ERD, and logical ERD.
Your deliverables for this phase are to provide any updates from the work completed thus far, to create the logical ERD, and to create and execute the SQL for Aspect 1. Provide screenshots for:
Creation of tables and constraints
Creation of reusable stored procedure
Use of the stored procedure
SQL query
This Term Project deliverable is not a final submission of what you develop. You have the opportunity to make modifications before the final Term Project submission at the end of the course. Make sure that no plagiarism found