There are 2 main ways to interface with the database
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?
(week 2: After designing the base set of tables for the project, the topic of security was brought up. Designing in security at an early stage of the project will make it easier to properly close potential loopholes.
As an example, one type of user is being considered. A class scheduler will be a user who can assign students to classes. They can view student and class information but cannot edit that data—they can only edit the data in the Students_Classes table.
Discuss how the class scheduler can be limited to access a specific database or table. Also specify which login method you recommend to be used and the reasons for your recommendation?)
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, and so on) available to the user and how they will interact with the screen.
Paper Format: APA
Answer preview to There are 2 main ways to interface with the database
APA
467 words
Get instant access to the full solution from yourhomeworksolutions by clicking the purchase button below
