Activity 7.3 System Analysis and Design.

Part 1: Answer the Module Review Questions listed below. These questions were chosen to demonstrate your understanding and help you assess your progress.

1. Describe the two steps to data storage design. How are a file and a database different from each other?
2. Name five types of files and describe the primary purpose of each type.
3. Name two types of legacy databases and the main problems associated with each type. What is the most popular kind of database today? Provide three examples of products that are based on this database technology.
4. What are the two most important factors in determining the type of data storage format that should be adopted for a system? Why are these factors so important?

Part 2: Module Practice:

You have been given a file that contains the following fields relating to CD information. Using the steps of normalization, create a logical data model that represents this file in third normal form. The fields include the following:

• Musical group name
• Musicians in group
• Date group was formed
• Group’s agent
• CD title 1
• CD title 2
• CD title 3
• CD 1 length
• CD 2 length
• CD 3 length

The assumptions are as follows:

• Musicians in group contains a list of the members of the people in the musical group.
• Musical groups can have more than one CD, so both group name and CD title are needed to uniquely identify a particular CD.