You have been assigned to design the database for a new socc

You have been assigned to design the database for a new soccer club. Indicate the most appropriate sequence of activities by labeling each of the following steps in the correct order. (For example, if you think that “Load the database” is the appropriate first step, label it “1.”)

                ______Create the application programs.

                ______Create a description of each system process.

                ______Test the system.

                ______Load the database.

                ______Normalize the conceptual model.

                ______Interview the soccer club president.

                ______Create a conceptual model using ER diagrams.

                ______Interview the soccer club director of coaching.

                ______Create the file (table) structure.

                ______Obtain a general description of the soccer club operations.

                ______Draw a data flow diagram and system flowcharts.

Solution

1)Interview the soccer club president.

2)Interview the soccer club director of coaching.

3)Obtain a general description of the soccer club operations.

4)Create a description of each system process.

5)Draw a data flow diagram and system flowcharts.

6)Create a conceptual model using ER diagrams.

7)Normalize the conceptual model.

8)Create the file (table) structure

9)Create the application programs.

10)Load the database.

11)Test the system.