need help on this 400-600 words There are 2 main ways to interface with the data

Question

need help on this

400-600 words

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.

Explanation / Answer

Advantages of Stored Procedures
Stored procedures are so popular to extract data from Relational Database Management Systems (RDBMS).

By using stored procedures scripts are in one location, updates and tracking becomes easier
By using Stored procedures we Can test independent of the application
There’s no confusion of having business rules spread over potentially
These are cached on the server
These are Limiting direct access to tables
It Secures just the data and the code that accesses it

Drawbacks
Limited Coding Functionality
Stored procedure code is not much robust as query processing
Some critical Stored Procedures that uses core functionality and not easy to understand.
The main draw back is that errors in Stored Procedures are not generated until runtime executes.
Need much overhead while maintaining Stored Procedures.
It is more cost.

Advantages of using raw queries.
The main advantage is that it is easy to understand.
Less cost and best suitable for small organizations.
Using raw queries provides integrity and robustness.

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.