Planning Database Design

Week 1 Discussions 1 & 2
Subject: General Questions    / College life

Week 1 Discussion 1

“Planning Database Design” Please respond to the following:

•The proper implementation of a database is essential to the success of the data performance functions of an organization. Identify and evaluate at least three considerations that one must plan for when designing a database.

•Suggest at least two types of databases that would be useful for small businesses, two types for regional level organizations and two types for internationally wide companies. Include your rationale for each suggestion.

Week 1 Discussion 2

“Database Modeling” Please respond to the following:

•Following a data model is important in the planning of a database system. Evaluate at least two classic models that are used in providing structure for database solutions.

•Compare and contrast the effectiveness of classic models and recently evolved models such as Big Data and NoSQL. Give your opinion on which type of model is more effective and why.

Week 2 Discussion 1

“Maintaining Data Integrity” Please respond to the following:

•Describe the importance of maintaining integrity rules throughout the database structure.Create at least three examples of common relationships that are used within a relational database system. Justify your response.

•Many times, database designs do not include the proper use of indexes. Provide a specific example on how an index could be used in order to enhance user search experience. List specific fields that you would index. Analyze what would occur if the proper index is not included, with respect to your example.

Week 3 Discussion 1

“The Entity Relationship Model” Please respond to the following:

•Defining relationships within a database can improve search capabilities and optimal performance of the database in the long run. Identify at least two relationship strength types that can be used within the entity relationship model.

•Using the classifications from part one of this discussion; provide a real word scenario that demonstrates each relationship strength classification.

Week 3 Discussion 2

“Preparing an Adequate Data Model” Please respond to the following:

•Using specialization hierarchies can provide an efficient application development structure. Justify the use of surrogate primary keys for a database design. Provide an example to support your response.

•Historical data can be important to measuring performance. Prepare an example on how time-variant data can be properly captured and maintained within a database system.

Order Now