Question

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) structures.

__________ Obtain a general description of the soccer club operations.

__________ Draw a data flow diagram and system flowcharts.

Answer 1

Answer:

The solution of this question is given below in the explanation section.

Explanation:

To design a database for a new soccer club, the following sequence of activities will be carried out.

_____8_____Create the application programs.

_____4_____ Create a description of each system process.

_____9_____ Test the system. Load the database.

____7______ Normalize the conceptual model.

___1_______ Interview the soccer club president.

___6_______ Create a conceptual model using ER diagrams.

___2_______ Interview the soccer club director of coaching.

____7______ Create the file (table) structures.

____3______ Obtain a general description of the soccer club operations.

____5______ Draw a data flow diagram and system flowcharts.

The correct orders of activities the to design a soccer club database is given below:

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. Create the file (table) structures.
8. Normalize the conceptual model.
9. Create the application program
10. Test the system. Load the database.