DAT380 University of Phoenix Wk 2 Advanced Database Architectures Discussion

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

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.