Final Project

Overview: Create a database and the appropriate functions$/$procedures$.$

Review the specification below and complete all the requirements of the project. Your

group was hired to design, develop, and test a database for a general scenario $($decide

it with your instructor $$ see list below$).$ Your work MUST contain a specific scenario

created by your group and approved by your instructor based on a problem a database

may face. Discussions must be done in class with your instructor during the SCRUM

meetings.

The following steps should be taken:

$$ Design the database, following an ER approach using MySQL Workbench; then

go through the normalization process to come up with a collection of tables that

are in $3$rd normal form.

$$ Create realistic constraints such as primary keys, foreign keys, unique, and not

null constraints, for the tables and attributes, etc.

$$ After, use the model to generate the script to create the database, tables,

columns, etc.

$$ Populate the database in order to present your final results working in class as

you run your queries.

$$ Create a script and backup of the database, data, and queries in order to run

them during the presentation.

General Scenario:

$$ Pet Store

$$ Doctors Office

$$ Toy Store

$$ Pharmacy

$$ Game Store

$$ Book Store

$$ Home Decor Store

$$ Car Service Store

$$ Childcare registration

Specific Scenario: The group should include a list of three queries that will be

appropriate for the system. Also, $3$ procedures or functions that will be useful for the

system. Decide them with your instructor and get approval before going ahead.

The presentation should be professional $($slides to explain the group work$).$

Once you have all items complete $($ER model, script, backup file, queries, procedures,

zip all files together and submit them to the Final Project dropbox $($YourName$-$DBFinalProject.zip$).$ Each participant in the group should submit the files.

Grading Criteria

The project will be graded on the following criteria:

$$ Participation $-$ Scrum meetings are mandatory.

$$ Make sure the relationships between tables make sense.

$$ Make sure all requirements are met based on the work request $-$ Rubric.

$$ Make sure to save each work request file as stated in the work order and one

zip file is submitted at the end.