a. The following pair of concepts are related in some way and different in another. Explain how the concepts are similar and how they are different: TABLE / VIEW
a. The following pair of concepts are related in some way and different in another. Explain how the concepts are similar and how they are different: TABLE / VIEW
Database Systems: Design, Implementation, & Management
12th Edition
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Carlos Coronel, Steven Morris
Chapter7: Introduction To Structured Query Language (sql)
Section: Chapter Questions
Problem 97C: The following tables provide a very small portion of the data that will be kept in the database....
Related questions
Question
a. The following pair of concepts are related in some way and different in another. Explain how the concepts are similar and how they are different: TABLE / VIEW
b. The following pair of concepts are related in some way and different in another. Explain how the concepts are similar and how they are different: UPDATE / ALTER
c. The following pair of concepts are related in some way and different in another. Explain how the concepts are similar and how they are different: DELETE / DROP
Expert Solution
Step 1
a)
Similarities:
Table:
- It is a collection of rows and columns.
- Here, all the rows are identified by some primary keys, and columns are identified by their unique column names.
- It is used to store data in the database.
- The table can be created by using the CREATE TABLE command.
- Different types of UPDATE, DELETE, or INSERT commands are used to modify or update the table in SQL.
View:
- They are also stored in the database like a table.
- Once the view is created in the database, it can be called any number of times by using its name.
- The execution time of view is very less.
- Views are used to restrict access to table data.
- They play important role in data security.
Step by step
Solved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning