Phase I $$ Analysis & Specification

About E$-$commerce management

The task for Phase I deliverables includes:

$1.$ Propose an appropriate title for database management system from the real world.

$2.$ Identify problem statement, objective, scope, project significance and expected outcome of the chosen database management system application.

$3.$ Identify all the entities and attributes required to store and manage the information in the chosen system.

$4.$ Identify the required tables that would be required in the system and normalize the table up to $3$NF$.$

$5.$ Create a complete ER Diagram to show the various entities, attributes and relations among the attributes with appropriate cardinalities.

$6.$ Provide Data Flow Diagram showing the primary documents and tasks of the system and the flow of data among them.

$7.$ Write the SQL queries to create the required tables.

$8.$ Design at least $10$ sample user interfaces to perform data operations including insertion, deletion, update, and search of information.