Suppose that the fragment of the Student Registration System has two user accounts: Student and Administrator. Specify the permissions appropriate for these user categories using the SQL GRANT statement.
What will be an ideal response?
An administrator should be able to read and modify all information in Student, Professor, Course, Transcript,andTeaching — if your university is like ours, only administrators can change information. Here is an example:
```
GRANT SELECT, INSERT, DELETE, UPDATE ON Transcript
TO Administrator WITH GRANT OPTION
```
Assuming that Ids and addresses are considered private, a student should be able to see names and student status in the Student relation, professors and departments in the Professor relation, everything in the Course relation, nothing in Transcript, and, perhaps, CrsCode and Semester in Teaching. Here is an example:
```
GRANT SELECT (CrsCode, Semester) ON Teaching
TO Student
```
You might also like to view...
Give an example of a transaction processing system (other than a banking system) that you have interacted with, for which you had an intuitive expectation that the serial order was the commit order.
What will be an ideal response?
The OpenOffice Writer ________ feature allows for the creation of form letters
A) Mail Merge B) Data Source C) Record Changes D) Main Document
A menu pane is a group of menus at the top of a program window
Indicate whether the statement is true or false
Move to Green Computing. Your organization is a leader in the development of renewable energy sources based on enhanced geothermal systems and is viewed as a champion in the fight to reduce carbon emissions. The organization employs over 25,000 people worldwide, primarily in the United States, Germany, and Mexico. Its products and services are used in over 50 countries around the globe. The executive team has set a goal of implementing green computing across the organization within a two-year time period and is evaluating a number of initiatives to achieve that goal. What direct, tangible business results can your firm most reasonably expect from implementing a successful green computing program?
A. Green computing presents an opportunity to substantially reduce costs.
B. Demand for the firm's goods and services will increase as existing and potential customers recognize its leadership in the use of environmentally friendly equipment.
C. Green computing will result in the safe disposal or recycling of computers and computer-related equipment.
D. Going green is in the company's best interests in terms of supporting the firm's public relations efforts, improving employee safety, and enhancing the well-being of the community at large.