How to Organize Tables according to Case Studies
684110Feb 9 2009 — edited Mar 19 2009There are two class projects that I am working on - a Library Database and another one on Video Rental.
I would like to keep the tables that I create for these projects separate.
I thought of using prefixes like LIB_ and VID_ for the two sets of tables. Is there a better way? I do not
have privileges of creating a user.
The Oracle database is currently running at the University and I am accessing it through SQL Developer.
There is a connection name that I am using right now. Would using two different connection names
create two different namespaces?