Describe the three parts involved in any SQL-based relational database application
From an end-user perspective, any SQL-based relational database application involves three parts: a user interface, a set of tables stored in the database, and the SQL "engine.". Each of these parts is explained below.
1 . The end-user interface. Basically, the interface allows the end user to interact with the data (by automatically generating SQL code). Each interface is a product of the software vendor's idea of meaningful interaction with the data. You can also design your own customized interface with the help of application generators that are now standard fare in the database software arena.
2 . A collection of tables stored in the database. In a relational database, all data are perceived to be stored in tables. The tables simply "present" the data to the end user in a way that is easy to understand. Each table is independent. Rows in different tables are related by common values in common attributes.
3 . SQL engine. Largely hidden from the end user, the SQL engine executes all queries, or data requests. Keep in mind that the SQL engine is part of the DBMS software. The end user uses SQL to create table structures and to perform data access and table maintenance. The SQL engine processes all user requests—largely behind the scenes and without the end user's knowledge. Hence, SQL is said to be a declarative language that tells what must be done but not how.
You might also like to view...
Questionnaires serve as enduring records of the research
Indicate whether the statement is true or false
Equal treatment of employees can result in more knowledgeable employees with more responsible jobs going unrecognized and unrewarded.
Answer the following statement true (T) or false (F)
The FTC:
a. and an advertiser can enter into a consent decree to force the advertiser to both stop the running of the advertisement and to publicly admit its advertisement was deceptive. b. can order a false or misleading advertisement to be stopped through a "cease and desist order," but cannot require the violator to correct its advertising. c. can fine an advertiser for running a misleading advertisement if it fails to comply with its order to "cease and desist." d. All of these are correct.
Dorothy files a petition for bankruptcy in bankruptcy for relief through an individual's repayment plan. If she is granted a discharge, debts that will most likely be discharged include
a. claims not provided for by the plan. b. payments on retirement accounts. c. claims for domestic support obligations. d. credit-card debt incurred more than one year before filing.