You will begin with going back to the scenario presented in Assignment $2,$ problem $1$: Capital College database, and it subsequent scripts from Assignment $3.$

You are to perform the following requirements:

Make corrections to the database design, add an additional constraint, and implement a new EER model to represent entities of the database, including

tables, views, and relationships. The new constraint you need to add to the original Capital College database is that of tracking the students that are

members of each organization; here each student can belong to any number of organizations and each organization can have any number of students as

members.

Then you will implement a script to create the database, including all tables, indexes, and sample data.

In reviewing the chapter on views, determine if the Capital College database would benefit from the use of one or more views, then implement a script to

create one view.

In reviewing the section on stored programs, scope out $3$ stored programs of your choice that may be beneficial to user in maintaining the data in this

database. These can be any of the four types described; stored procedure, stored function, trigger, or event. Then document the scope of the $3$ programs

describing the objectives, the input $($if any$)$ and the output $($if any$).$ Psuedocode or program flow diagram can be included but is not necessary.

In reviewing the last section on database administration, document the what tools might be used to monitor the server to make sure that it is running

efficiently, the user accounts and privileges that a user might have, and finally, a plan for backing up the database and a plan to restore the database if it

becomes necessary.