Quality Output

Using available resources, not including the textbook or your classmates, describe these terms.

· Database

It is a group of information that is systematized so that it can straightforwardly be opened, accomplished, and updated. In addition, databases can be confidential conferring to sorts of content: bibliographic, full-text, numeric, and pictures.

· Database Management System

It is system software for generating and working databases. The DBMS offers operators and computer operator with a methodical technique to produce, recover, update and achieve data.

· SQL

Structured Query Language is a homogenous software proposal language which is been used for running relational databases and performing numerous processes on the data in them. 

· Entity-Relationship model 

The entity-relationship model or ER model, is an approach of explicitly representing the logical relationships of entities or objects with the purpose of creating a database. 

· Relational algebra

An algebra is an official construction containing of groups and operations on those groups. Also, Relational algebra is an official scheme for using relations.

· Data modeling

It is frequently the primary phase in database proposal and object-oriented programming as the creators initially make it a theoretical model of how data objects communicate to each other. Correspondingly, Data Modeling includes a development from theoretical model to logical model to physical schema.

· RDS (from Amazon)

Amazon Relational Database Service or Amazon RDS is a disseminated relational database facility via Amazon Web Services AWS. Likewise, it is a web facility successively "in the cloud" intended to make simpler the setup, operation, and scaling of a relational database for custom in presentations.

· MySQL

MySQL is an exposed foundation relational database management system. Furthermore, MySQL database is kept in the formula of related tables. MySQL databases are normally used for web application development

2) Find two DBMS products that dominate the current market. Summarize why and how you believe these products dominate.  (Do not use vendors' marketing material.)

The most dominant products that the market has are MySQL and Oracle Acceding to the “http://db-engines.com/en/ranking” that MySQL the first system that has the highest score, after that, the Oracle takes the second stage with much less score than MySQL , but it still be the second product. As a result, I observed that MySQL has more than 65 percent shares and Oracle has market cut of more than 35 in the Database Management system .SQL has this data recovery systems, and it is doing decent for of its compatibility by Microsoft systems .On the other hand, Oracle can be measured as a developer in the market and at this time it is doing satisfactory for the reason it’s the cloud feature. In cooperation the DBMS products are top in the market since they have a improved reply for queries such as Dependency, portfolio, documentation, proposal.

3) Explain the interest among experts in NoSQL. Find and contrast with conventional databases one NoSQL product.

NoSQL or Not Only SQL is very handy for distributed data. It is luring various experts because of its capacities to handle big data performance and scalability in relational databases. It is coming up in the market because many companies are in a need to access and process

The SQL is good disseminated Data. It has many experts for the reason that the capability to manage a large data presentation in a scalability in the relational Database. The SQL is popular I the market because many institutions and companies in necessity to use it for entree and development.

Unstructured data present in virtual servers that are present in the cloud. It can function without using relational models and handle the clusters well.

4) Compare and contrast relational algebra and SQL.

Relational algebra: is sealed the result of every expression is a relation. Also, it has as a accurate foundation .It has simple semantics.it is used for reasoning, query optimization, etc.

SQL: is a superset of relational algebra. Has an expedient formatting structure. Offers total functions. Has difficult semantics. Also, it is an end-user language.

http://searchsqlserver.techtarget.com/definition/database

http://searchsqlserver.techtarget.com/definition/database-management-system

http://www.motive.co.nz/glossary/mysql.php

https://www.techopedia.com/definition/7057/entity-relationship-model-er-model

https://aws.amazon.com/rds/

http://searchdatamanagement.techtarget.com/definition/data-modeling