[Solved] Discussion Solutions

Week 4 Discussion 1cis515

Optimizing Database Design Please respond to the following:

Many legacy systems require normalization. Identify at least two factors that should be considered in order to produce an optimal normalized set of tables when performing normalization. Include in your discussion a detailed example on how each factor would eliminate data redundancy

Optimal database design recognizes proper organization of table structures and relationships. Suggest at least two methods that can be used to improve the design of a database system.

Week 4 Discussion 2cis515

Denormalization Functionality Please respond to the following:

Having an adequate data model to serve specific business needs of an organization is important. Evaluate the need for denormalization within an organization. Provide at least three examples that prove denormalization is useful to data consumers.

Using a data-modeling checklist can help database developers design efficient data repositories. Suggest at least two possible scenarios that could take place if one of the steps in the data-modeling checklist (table 6.7 in Chapter 6 of the textbook) is missed

Week 4 Discussion 1cis524

Direct Manipulation and Virtual Environments Please respond to the following:

Your software development company has been contracted to build a tool that will manage user accounts and rights in an Active Directory environment. One of your developers tells you that he wants the tool to make use of direct manipulation. A second developer argues that a command line structure would be a better and more secure approach. Take a stand on this argument, providing at least three positives of each approach, and then make a decision for this project and support it.

Describe virtual and augmented reality. Suggest a way in which this technology could be used in the future; either to improve a current process / procedure or create a new process / procedure. Provide an example of your suggested use of the technology.

Week 4 Discussion 2cis524

Menu Selection and Organization Please respond to the following:

• Describe the considerations that you would take into account when selecting the menu style for an application and why. Support your response with examples.