Create 1 or multiple databases for class

From: Sunny Siu <xxsiu_at_omega.uta.edu>
Date: 1996/06/13
Message-ID: <4ppum2$13r_at_utaipx02.uta.edu>#1/1

We start using Oracle 7.2 for a class of 60 students this summer semester. Each student in the class is going to create its table and program in embedded SQL/C.

option 1. Create database for each student.

option 2. Create just one database for the whole class,

---

Question 1. What are the pros and cons of option 1 and option 2?

Question 2. In option2, can each student create table with the same name,

	    like "CREATE TABLE LAB1 ...."?  How about writing programs
	    to access the database?

Question 3. Any security issue I need to pay attention in option 2?

Your suggestion is appreciated.

--
--Sunny Siu

  Unix system admin., ACS
  University of Texas at Arlington
  siu_at_uta.edu Received on Thu Jun 13 1996 - 00:00:00 CEST