To explain a view, its definition and what happens when user accesses a
Explanation of Solution
A view is an individual user’s or application program’s picture of a database. View is used by an individual to create charts, reports and other objects with the help of data in database.
The SELECT command used in the View creation basically creates the view and gives the definition for the view. It indicates what to include in a view. The data described in a view definition never exists in that form. In fact, when a query is created with a view, the DBMS make changes to the query and make it to the one that includes the data selection from the tables that created the view. There is less involvement of view than the full database.
Accessing a database through a view, the users cannot make any changes to the structure of the database and can only view the data.
Want to see more full solutions like this?
Chapter 4 Solutions
EBK CONCEPTS OF DATABASE MANAGEMENT
- Access path A database table is composed of records and fields hold data. Data is stored in records. A field is a part of a record and contains a single piece of data for the subject of the record. The access path for finding the list of books is AUTHOR: AuthorID, Lname BOOKAUTHOR: AuthorID, ISBN BOOKS: Pubdate, ISBNarrow_forwardIn the hierarchy of data, what is the difference between a data attribute and a data item? What is the domain of an attribute?arrow_forwardAn in-memory database (IMDB) is a database management system that stores the entire database in _______. a. random access memory b. read-only memory c. distributed servers d. virtual memoryarrow_forward
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- Principles of Information Systems (MindTap Course...Computer ScienceISBN:9781285867168Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningEnhanced Discovering Computers 2017 (Shelly Cashm...Computer ScienceISBN:9781305657458Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. CampbellPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning