CST 363 Module 3

What is an SQL view:

• How is it similar to a table?
  
  An SQL view is similar to a table in its structure, data access, and usage in queries. Basically, the view has both rows and columns just like a table, while also being able to query a view through a SELECT statement and can use joins, filters, and aggregations like a table as well.
  
  
• In what ways is it different?
  
  The way an SQL view is different to a table is due to the table's primary keys, alongside operations insert, update, and delete. Basically, tables are capable of using primary keys to store actual data, while views can't and only display the underlying data. On the other hand, tables are able to use the operations insert, update, and delete fully, while views may be able to have updatable views; however, they are very restricted and can only be done with non-complex views.
  
  

What features are similar to SQL:

Some features that are similar to SQL are the syntax structure and data handling. Basically, both SQL and Java rely on a structured syntax with keywords, expressions, and statements, which dictates the underlying implementation of the operations. On the other hand, SQL and Java both handle data, as SQL manipulates data stored in relational databases, while java provides ways to interact with databases through libraries.

Which are present in one language but not the other:

SQL is a language that is primarily for database management, while Java is an object-oriented programming language meant to be used for applications and servers. Basically, SQL executes queries through a database management system dealing with relational databases, while focusing on the maintenance of the database. On the other hand, Java runs through a Java Virtual Machine that implements complex data structures like arrays, lists, and objects, while also having multithreading capabilities.