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.

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code “Newclient” for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.


The post DAT380 University of Phoenix Wk 2 Advanced Database Architectures Discussion appeared first on Top Premier Essays.

"Is this qustion part of your assignmentt? We will write the assignment for you. click order now and get up to 40% Discount"