Question

In: Computer Science

Your organization's database needs include the following: Multiple departments will require access to the database, including...

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

Solutions

Expert Solution

I recommend these database architecture types that would work for your organization To design a particular organizations we need .Database architecture. It mainly focuses on the design, development, implementation and maintenance of computer programs that store and organize information for businesses, agencies and institutions. A database architect develops and implements software to meet the needs of users.

Relational data base ;

In Relational database we store data in structured format to store employees details we must use tables ,

Tables includes rows and columns to store user data and also for reference data.To develop and design data Relational database is more useful.

Relational data base should be most preferable for these type of organizations

Network Data base ;

In our organisation we are going to use eCommerce for that it needs Network data base to connect to different users

Network data base includes the formation of huge network by connecting different users to a single network

Where our eCommerce includes products So it is better to prefer this Network database.

Cloud Data base;

Where our organization needs large amount of storage to store product detaills and customer details

Cloud data base includes the collection of Both structured data and unstructured data in a Bag.

To maintain any organisation we must need Cloud data base.

By using these three Data base architecture model we can develop and maintain organizations dynamically and powerfully, that's why I recommend these three Architechture Database


Related Solutions

1.Create a Database in Access with the information The database must include: Database name: Monaco Enterprise  Mark...
1.Create a Database in Access with the information The database must include: Database name: Monaco Enterprise  Mark Johnson #87451 Table name: Contacts Delete the Primary key. Fields name and data type are (remember to choose the data type): Field Name Data Types Employee Name Short text Name Short text Last Name Short Text Work Yes/No 2.Go to the “Datasheet View” and enter the data. * Remember to save the table. 3.Move the last name field after the employee name. 4.The (data)...
factory (including the name and the name of the director) needs to establish a management database...
factory (including the name and the name of the director) needs to establish a management database to store the following information: I) A factory has a number of workshops, each workshop has the workshop number, workshop director's name, address and telephone number. II) There are more than one workers in each workshop, and each worker has a staff number, name, age, sex type of work. III) A workshop produces a variety of products, each of which has the product number...
“…Many different departments within an organization now require access to the same data. With conventional file...
“…Many different departments within an organization now require access to the same data. With conventional file processing, data are often duplicated in multiple files. Often data are stored in different formats in each of the files in which they are stored. On occasion, data which are stored in multiple files do not agree and time has to be expended to resolve these differences. (Sourced from an Academic journal) List and illustrate 2 benefits of a suitable database system to support...
Many different departments within an organization now require access to the same data. With conventional file...
Many different departments within an organization now require access to the same data. With conventional file processing, data are often duplicated in multiple files. Often data are stored in different formats in each of the files in which they are stored. On occasion, data which are stored in multiple files do not agree and time has to be expended to resolve these differences. (Sourced from an Academic journal) List and illustrate 2 limitations of a paper-based file system to support...
Please use an Access database with two tables to answer the following: use an example to...
Please use an Access database with two tables to answer the following: use an example to discuss the difference between a right, left, and inner join. Next, perform the left joint, right joint, and inner joint all on the each of the two tables.
Write a SQL script to add another table to your database. Include these fields in your...
Write a SQL script to add another table to your database. Include these fields in your Product table: Field Name Description Data Type Sample Value ProductID Product ID integer 5 ProductName Product Name varchar(50) candle Description Product Description varchar(255) Bee’s wax candle picUrl Filename of the product’s picture varchar(50) candle.gif Price Product Price decimal 10.99           ProductID should be the Primary Key. It is an auto-increment field.           The Price field stores prices to 7 significant digits and to 2...
Consider the schemas of the following relational database for a company. The company has different departments...
Consider the schemas of the following relational database for a company. The company has different departments at different cities in different states: employee(employee-id, dept-id, name, street-num, street-name, city, state, zip, salary) department(dept-id, dept-name, city, state) manager(manager-id, employee-id) NOTES: manager-id in the manager relation is a foreign key to the employee relation. employee-id in the manager relation is a foreign key to the employee relation. dept-id in the employee relation is a foreign key to the department relation. An employee belongs...
1.write about your plan for the database performance tuning, query optimization, and distributed database management systems.  Include...
1.write about your plan for the database performance tuning, query optimization, and distributed database management systems.  Include appropriate diagrams.
This activity will require you to apply your knowledge of interfaces – including the Comparable interface...
This activity will require you to apply your knowledge of interfaces – including the Comparable interface – in order to leverage the capabilities of the ArrayList data structure. --------- You may work individually or with a partner, but be sure that each student submits their own assignment in Canvas (and leave a comment with your partner's name if you worked with one). --------- Description: Interfaces are used to make a Class implement a behavior or set of behaviors. Recall the...
Assume that your group of team members, drawn from multiple departments, and that it is struggling...
Assume that your group of team members, drawn from multiple departments, and that it is struggling to deliver promised deadlines within budget. Team tension grows, because people are frustrated and fearful of failure. You notice that the negative sentiments are risking outcomes. Conflict is growing, coordination reducing, and their direct supervisory managers limit their availability. What should you do? 250 words of detail - concise and structured business writing
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT