QUESTIONS TO ANSWER
What topics BELOW did you find the most interesting and possibly applicable to the work you envision in the future? Explain how you would use what you learned?
TOPIC I
Define each of the following key terms:
a. Base table.
b. Data definition language.
c. Data manipulation language.
d. Dynamic view.
e. Materialized view.
f. Referential integrity constraint.
g. Relational DBMS (RDBMS).
h. Schema.
i. Virtual table.
2. Contrast the following terms:
a. Base table; view.
b. Dynamic view; materialized view.
c. Catalog; schema.
3. Describe a relational DBMS (RDBMS), its underlying data model, data storage structures, and manner of establishing data relationships.
TOPIC 2
Distinguish among data definitions commands and data manipulation commands.
Explain why it is necessary to limit the kinds of updates performed on data when referencing data through a view.
TOPIC 3
1. When is an outer join used instead of a natural join?
2. Explain the processing order of a correlated subquery.
3. Explain that any query that can be written using the subquery approach can also be written using the joining approach, but not vice versa.
TOPIC 4
1. If am SQL statement includes a GROUP BY clause, the attributes that can be requested in the SELECT statement will be limited. Explain that limitaion.
2. Describe a situation in which you would need to write a query using the HAVING clause.
TOPIC 5
1. Explain the structure of a module of code that defines a trigger.
2. Under what conditions can a UNION clause be used?
3. Discuss the differences between triggers and stored procedures.
TOPIC 6
Discuss as detailed as possible a practical case about the oportunity to use or not to use an index for a table and the benefits/performance penalties that it involves.
TOPIC 7
1. When would you consider using embedded SQL? When would you use dynamic SQL?
2. When do you think that the CASE keyword in SQL would be useful?
3. Explain the use of derived tables.
Last Completed Projects
| topic title | academic level | Writer | delivered |
|---|