: Within the Discussion Board area, write 300–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your...

1 answer below »


:Within the Discussion Board area, write 300–600 words that respond to the following questions with your thoughts, ideas, and comments. This will be the foundation for future discussions by your classmates. Be substantive and clear, and use examples to reinforce your ideas:


There are 2 main ways to interface with the database: using stored procedures or passing in the raw queries directly.


If the class scheduler described in the Week 2 DB needed a screen to search for students, how might each approach be used?



  • Look at the advantages and disadvantages for each approach.

  • Provide a description of what functionality the screen will provide. What can the user do with this screen?

  • Consider the inputs (text boxes, drop-down lists, buttons, etc.) available to the user and how they will interact with the screen.

Answered Same DayDec 05, 2021

Answer To: : Within the Discussion Board area, write 300–600 words that respond to the following questions with...

Parul answered on Dec 07 2021
146 Votes
Being that there are only two critical methods in order to interface with database - one is utilising the stored procedure and other is directly using the raw queries. One of the most common way to interface with the database like stored procedures. A stored procedure can be explained as a set of statements that essentially forms Structured Query Language (SQL) with an assigned name that is recorded in a RDBMS. In a group it can be utilised and shared multiple times in the program. A stored procedure can modify and access data in a database however, it isn’t attached to a particular object or database which offers a number of benefits. Majority monolithic SQL database assist stored procedures. Essentially most of the stored procedures offers a significant layer of security between the user interface as well as the database. It assists the security by the virtue of data access controls since the end users may enter or modify the data while there are no write procedures. A procedure that is stored preserves essential data integrity since information that is entered is in the most consistent manner. Stored procedure enhances the productivity since statements in the most stored procedure are...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here