Homework assignment #1
CS 643, Spring 2002
Due: Wednesday, Feb. 13, 2002
Total points: 100

CS301 (Computer Mastery) is a popular class among students in all majors. There are about twenty sections offered in each semester. Currently, all sections share the same set of textbook. The department is considering the creation of a resource management system for the instructors as well as the students of all sections of CS301. In calss, we discussed the possible resources that can be organized using Oracle tables. As a database administrator, you're asked to perform the following tasks:

1. Successfully install Oracle on the computer assigned to you. Create a database to be used for this assignment.
2. Plan and implement the logical structure of the database through tablespaces. Create the tables necessary for the project. In a document, record the parameters of the tablespaces as well as the structure of the tables. In addition, explain why you allocate table to different tablespaces in terms of security and/or backup concerns.
3. Create two views to demonstrate that a privilege can be granted to a user or a type of users on a view but not on its base tables. Record the views and explain how they satisfy the above requirement.
4. Define the types of users for the project. For each type, create a role and grant to it only the privileges that are absolutely required to accomplish necessary work for that type of user. Excessive granting of unnecessary privileges can compromise security, and hence will result in points deduction. Record the privileges for each role and explain why they're both sufficient and necessary.
5. Create one user for each type. Grant the users appropriate roles, respectively. For each user, list two SQL statements that are permitted and list two SQL statements that are prohibited.

Submit the document at the beginning of the class. It'll be graded based on correctness, clarity, and organization.