Computer Science Homework Help

AU WK 1 Relational & Non Relational Database in Terms of Simplicity of Design Essay

 

Relational Versus Non-Relational Database

Prior to beginning this discussion, read Chapter 1: Database Systems and Chapter 2: Data Models from the course text, and review the Database Design download presentation. Both relational and non-relational databases provide a mechanism for storage and retrieval of data. In order for organizations to remain competitive and/or make appropriate business decisions, it is important to understand the differences between the two. Discuss the difference between a Relational and Non-Relational Database in terms of simplicity of design, finer control over availability, speed and cost.

part 2 

Benefits of Database Management Systems

Prior to beginning this assignment, visit the following vendor websites: Microsoft SQL (Links to an external site.), MySQL (Links to an external site.), Oracle (Links to an external site.), and SQLite (Links to an external site.). These sites will provide you with additional information that will assist you with this interactive assignment. For this interactive assignment, you will discuss the use of DBMS and its benefits. Next, provide a comparison matrix between MySQL, MSSQL, Oracle, SQLite based on current version, operating system, cost, written in, licensing, graphical management tools, and maximum number of records.

Attach your comparison matrix in your initial post. Be sure to include references you used to populate the comparison matrix.

Coronel, C., & Morris, S. (2019). Database systems: Design, implementation, and management (13th ed.). Boston, MA: