Question

In: Computer Science

SQL is our language for relational databases - do you think it's an adequate "language" for...

SQL is our language for relational databases - do you think it's an adequate "language" for database creation and manipulation?

Solutions

Expert Solution

Yes, I think SQL is an adequate "language" for database manipulation until the data is structured. It is very useful for database creation and manipulation because of its easy to use syntax.

Following are the merits which make SQL adequate for database creation and manipulation:

  • No coding needed

It is very easy to manage the database systems without any need to write a substantial amount of code by using the standard SQL.

  • Well defined standards

Long established are used by the SQL databases that are being used by ISO and ANSI. There are no standards adhered to by the non-SQL databases.

  • Portability

SQL can be used in the program in PCs, servers, laptops, and even some of the mobile phones.

  • Interactive Language

This domain language can be used for communicating with the databases and receive answers to the complex questions in seconds.

  • Multiple data views

With the help of SQL language, the users can make different views of database structure and databases for the different users.


Related Solutions

SQL is our language for relational databases - do you think it's an adequate "language" for...
SQL is our language for relational databases - do you think it's an adequate "language" for database creation and manipulation? Please help answer this.
SQL is our language for relational databases - do you think it's an adequate "language" for...
SQL is our language for relational databases - do you think it's an adequate "language" for database creation and manipulation?
The database design process for noSQL databases is different from one for relational (SQL) databases. As...
The database design process for noSQL databases is different from one for relational (SQL) databases. As we learned noSQL database does not require to have a predefined structure, except of creating a list of databases and the list of collections. Some of the noSQL databases (like MongoDB) allow to define certain rules that will define what should be the structure of the acceptable documents for each collection. As you may recall, when you need to store multiple data points in...
Why do you think it's difficult for our generation to save money? Share one piece of...
Why do you think it's difficult for our generation to save money? Share one piece of budgeting/financial advice you've learned or heard
NoSQL databases can store relationship data—they just store it differently than relational databases do. How would...
NoSQL databases can store relationship data—they just store it differently than relational databases do. How would you describe the differences between a relational database and a NoSQL database? What do you see as the business advantages that a NoSQL database has over a relational database?
I think that SQL language is a great tool for database creation and manipulation. The basics...
I think that SQL language is a great tool for database creation and manipulation. The basics of SQL are easy to learn and understand. The coding is simple from the creation, changing, or even deleting data from the database. I overall really like learning SQL I can easily visualize what I am doing with the code. What could be added to this post?
Do you think the four principles of high involvement provide for an adequate context for designing...
Do you think the four principles of high involvement provide for an adequate context for designing high-performance work systems? What other concerns or guidelines for developing high-performance work systems would you suggest?
What is financial literacy? Do you think it's important? Why?
What is financial literacy? Do you think it's important? Why?
Q1. What do you mean by A view in SQL language? Give an example? Q2. Explain...
Q1. What do you mean by A view in SQL language? Give an example? Q2. Explain the role of SQL authorization mechanisms that allow to differentiate among the users of the database as far as the type of access they are permitted on various data values in the database?
Since accounting is the language of business, why do you think it will be important as...
Since accounting is the language of business, why do you think it will be important as a business person to be able to speak the language fluently? What would be the consequence of not knowing the language very well?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT