Scribd
Upload
69 views

Course 1 Module 02 Lesson 4

This document discusses non-procedural access to databases. It defines non-procedural access as requesting data through a query without specifying procedural steps. This allows users to indicate what data to retrieve without detailing how to retrieve it. The document explains that non-procedural access improves productivity and accessibility through tools like the SQL SELECT statement and graphical user interfaces that allow viewing and modifying database contents through forms, reports, and other visual methods. A key database skill is writing queries to retrieve needed information without relying on programming code.

Uploaded by

rastparul1
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
69 views

Course 1 Module 02 Lesson 4

This document discusses non-procedural access to databases. It defines non-procedural access as requesting data through a query without specifying procedural steps. This allows users to indicate what data to retrieve without detailing how to retrieve it. The document explains that non-procedural access improves productivity and accessibility through tools like the SQL SELECT statement and graphical user interfaces that allow viewing and modifying database contents through forms, reports, and other visual methods. A key database skill is writing queries to retrieve needed information without relying on programming code.

Uploaded by

rastparul1
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PPTX, PDF, TXT or read online on Scribd
You are on page 1/ 9

Information Systems Program

Module 2
Introduction to Databases and DBMSs

Lesson 4: Non-Procedural Access


Lesson Objectives
• Discuss the importance of non-procedural access
• Explain the link between the five types of
application development tools and nonprocedural
access

Information Systems Program


Nonprocedural Database Access

Loop

• Query: request for data to answer a question


• Indicate what parts of database to retrieve not the
procedural details
• Improve productivity and improve accessibility
• SQL SELECT statement and graphical tools

Information Systems Program


SELECT Statement Execution

Information Systems Program


Graphical Tool for Nonprocedural
Access

StdFirstName StdLastName StdCity OfferNo EnrGrade


MARIAH DODGE SEATTLE 1234 3.8
BOB NORBERT BOTHELL 5679 3.7
ROBERTO MORALES SEATTLE 5679 3.8
MARIAH DODGE SEATTLE 6666 3.6
LUKE BRAZZI SEATTLE 7777 3.7
WILLIAM PILGRIM BOTHELL 9876 4

Information Systems Program


Sample Data Entry Form

Information Systems Program


Sample Report

Information Systems Program


Procedural Language Interface
• Combine procedural language with nonprocedural
access
• Why
– Batch processing
– Customization (especially for ecommerce) and automation
– Performance improvement

Information Systems Program


Summary
• Database technology vital to modern organizations
• Crucial DBMS feature: nonprocedural access
• Query language, visual tool, form tool, report tool, and
embedding
• Fundamental skill: query formulation

Information Systems Program

You might also like