affirmative action policy
Define affirmative action. Examine an affirmative action policy at a four-year selective university.
Approaches to database programming.
List the three main approaches to database programming. What are the advantages and disadvantages of each approach?
ER model constructs.
Discuss the correspondences between the ER model constructs and the relational model constructs. Show how each ER model construct can be mapped to the relational model, and discuss any alternative mappings?
FUNCTION operation
What is the FUNCTION operation? For what is it used? And present a practical example/ scenario.
Key and foreign key constraints
How can the key and foreign key constraints be enforced by the DBMS? Is the enforcement technique you suggest difficult to implement? Can the constraint checks be executed in an efficient manner when updates are applied to the database?
Characteristics of relations
Discuss the characteristics of relations that make them different from ordinary tables and files.
DBMS Architecture
If you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose? Why? Why would the other architectures not be a good choice?
Traditional file processing vs database
Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.
