Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Beginner Project

Re: Beginner Project

From: Sumaira <sumairagul_at_hotmail.com>
Date: 5 Dec 2001 13:02:16 -0800
Message-ID: <459bb6b3.0112051302.7614825e@posting.google.com>


Hi,

   As you are interrested to develop a Database for dvd rental site, You must know the Rules Of Relational Database Management : Six Steps of Database Design;Entity Relationship Model;Normalization;Then Adjust Physiacal schema, somwhat like this:
Create Few Objects:
1: Table Of a client containing attributes i.e;Cname,Caddress,Cphoneno,Crented Film,etc.

2: Table Of DVD Shop containing attributes i.e;salesperson' name,Type of Film,time/Date of rent,rental_rates etc.

3: Create a relationship between these two objects ,to relate entities from the same entity sets.

Database Design Tools:
Design Tools are available from RDBMS,as well as see the following URL for details on Sbase's
tools:http://www.sybase.com/products/application_tools .

Oracle Tools:http://www.oracle.com/tools

Bye
Sumaira.
TurkBear <jgreco1_at_mn.rr.com> wrote in message news:<vccs0u0gktdscftn1i9p669ssretfq4oqk_at_4ax.com>...
> It would also help to attend class...One assumes the material will be covered...
>
>
>
>
> Ban Spam <ban-spam_at_operamail.com> wrote:
>
> >blackcatwhitecat2002_at_yahoo.com (Goran) wrote in
> >news:ca53d7.0112032049.11878658_at_posting.google.com:
> >
> >> Hi,
> >>
> >> I am taking an Oracle class in school and I have a project related to
> >> creation of a database for a DVD rental site (see www.netflix.com).
> >> The project includes creating the ER diagram, script for all objects
> >> and for all functions of the site.
> >>
> >> Question: Could anybody help me with any clue, hints, any similar
> >> projects?
> >>
> >> Thank you.
> >> G.
> >>
> >
> >When all else fails, RTFM.
> >
> >Alternatively try http://otn.oracle.com or doc.oracle.com
> >
> >
> >
> >HTH & YMMV
> >HAND!
> >
> >
> >
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> Check out our new Unlimited Server. No Download or Time Limits!
> -----== Over 80,000 Newsgroups - 19 Different Servers! ==-----
Received on Wed Dec 05 2001 - 15:02:16 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US