Re: Create 1 or multiple databases for class

In article <4ppum2$13r_at_utaipx02.uta.edu> xxsiu_at_omega.uta.edu (Sunny Siu) writes:
>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?

It sounds like you want to create a database for the whole class, and create a schema for each student. If you had each student create a database, you would wind up teaching a DBA class instead of a C class.

>
>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?
>

Yes. Check your SQL syntax books, it's schema.table if there is a need.

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

Grants and profiles, if students need to cross schemata.

jg
>
>Your suggestion is appreciated.
>
>--
>--Sunny Siu
> Unix system admin., ACS
> University of Texas at Arlington
> siu_at_uta.edu

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O