Wk 2 Discussion – Database Architectures [due Thurs]

Discussion TopicPost a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to other students.

Due Thursday

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

Respond to the following in a minimum of 175 words:

Compare the five characteristics of each of the following database architectures:

• Distributed
• Object-Oriented
• Relational
• Cube
• Multi-tier
• One-tier

Provide examples of when each would be used.

Due Monday

Reply to at least 2 of your classmates. Be constructive and professional in your responses.

Wk 2 – Advanced Database Architectures [due Mon]

Assignment Content

1. Your organization uses Microsoft® Excel® to maintain its inventory. The company is growing rapidly and has reached the point where an inventory database is needed.

   Your organization’s database needs include the following:

   • Multiple departments will require access to the database, including eCommerce, manufacturing, sales, and customer service
   • Employees will use the database to:
   • Enter data
   • Reference data
   • Use data to auto-populate new orders and customer service records
   • Analyze data and create reports

   Recommend three of the following six database architecture types that would work for your organization:

   • Hierarchical
   • Network
   • Relational
   • Distributed Relational
   • Object-Oriented
   • Cloud

   Include the following in your recommendation:

   • Your top three recommended architectures, in order, using the number 1 as your best recommendation
   • Your rationale for recommending each architecture
   • The characteristics that make each architecture a top recommendation
   • The current usage trends of these architectures in the industry and how it affected your recommendation for each
   • Potential concerns or disadvantages of each architecture
   • Summary of reasons for not recommending the remaining three architectures
   • Citations for any graphics, images, video, or audio used

   Create your recommendation as either:

   • A 3- to 4-page technical summary in Microsoft® Word
   • A 14- to 16-slide multimedia-rich presentation with detailed speaker notes

   Submit your assignment.

Wk 2 – Object-Oriented Data Model and SQL Query Definition [due Mon]

Assignment Content

1. 
   Refer to the Week 1 – Required Learning Activity: Appendix A, Database Systems.

   Consider any relevant feedback from your Week One Individual Assignment titled, ”
   
   
   DreamHome Case Study” that will support the completion of this week’s assignment.

   Create a data model for an object-oriented database in Microsoft® Visio® using the following resources:

   • The information presented in Appendix A, “User Requirements Specification for DreamHome Case Study” of Database Systems: A Practical Approach to Design, Implementation and Management (6th edition)
   • The distributed database created in the Week One Individual Assignment, “DreamHomeCase Study”

   Write a minimum of four queries for building the database structure and map to the data model.

   Note: The results of this assignment will be used in future
   DreamHome-related Individual Assignments in Weeks Three, Four, and Five.

   Compress the following files into a ZIP folder:

   • The Microsoft® Visio® file with the data model for an object-oriented database.
   • Microsoft® Word file containing the SQL queries for building the database structure.

   Submit the ZIP file.