The Student Registration System is to be integrated with an existing student billing system (which also bills for meal plans, dorm rooms, etc.). The databases for the two systems reside on different servers, so the integrated system is distributed. Using your imagination,
a. Give examples of two global integrity constraints that might exist for the global
database of this system.
b. Give examples of two transactions that access both databases.
a. IC1: The amount the student is billed for corresponds to the courses she is registered for.
IC2: A student is allowed in the dorm only if she is registered for at least 1 course.
b. The dorm registration transaction (to check constraint); the billing transaction.
You might also like to view...
A pop-up blocker is a web browser feature that ____
a. keeps the window in a minimized state b. prevents unwanted advertisements c. censors Internet searches d. prevents color images from being displayed
The ____ panel contains buttons for creating objects, such as tables, images, forms, and videos.
A. Forms B. Tables C. Layers D. Insert