Database Design

Week 2.   Discussion                                              Database Design

1. Write a 200- to 300-word short-answer response for the following:

•Why it is necessary to choose appropriate data types for each data column?

2.  Write a 200- to 300-word short-answer response for the following:

•How must a database designer balance the time to complete data modeling steps with the benefits the data modeling process offers in creating a database? Consider examples from your work place and class assignments.

3.  Write a 200- to 300-word short-answer response for the following:

What are some issues when working with a many-to-many relationship? Provide some examples.

4.  Write a 200- to 300-word short-answer response for the following:

            Think of a situation where null value should be allowed and a situation where it should not be allowed. What are the consequences of inappropriate null settings?

5. Write 200- to 300-word short-answer response to the following:

What is the data dictionary’s function in database design?

6. Write 200- to 300-word short-answer response to the following:

What are business rules? Why are they important to a database designer?

7. Write 200- to 300-word short-answer response to the following:

What is the minimal data rule in conceptual design? Why is it important?

            8. Write 200- to 300-word short-answer response to the following:

List and briefly explain the activities involved in the verification of an ER model.

APA format requires a concluding paragraph which sums up the wholepaper.     

Format your paper consistent with APA guidelines.

As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standards.

Write a 750- to 800-word paper in which you complete the following:

•Choosea database environment from the following:

• An appropriate database environment within your workplace (must be approved by your instructor)

• An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum

• Smith Consulting (Virtual Organization) – needs a database to track their consulting staff, each staff member’s skill sets, and what projects they are working on

•Analyze the database environment.

•Describe the problems and constraints.

•Describe the objectives of the database environment.

•Describe the scope and boundaries.

•List the data specifications (must include a minimumof three entities with attributes).

Include 3 to 5 references.

Format your paper consistent with APA guidelines.

Note. The database environment chosen will be used in the Weeks Three and Four Individual Assignments.

Include 2 to 4 references.

Format your paper consistent with APA guidelines