Re: help help

From: Ed Stevens <Ed.Stevens_at_nmm.nissan-usa.com>
Date: Wed, 19 May 1999 12:28:57 GMT
Message-ID: <7huaq7$tv7$1_at_nnrp1.deja.com>


In article <37420D57.390DB949_at_columbia.edu>,   Richard Cuello <rc370_at_columbia.edu> wrote:
> What kind (subject) of database does everyone operate? egs. retail,
> legal, personal, hospital, etc.. And what entities are part of your
> database? egs, name, address, phone, billing.. etc..
>
> I'm designing a database for a class and I am looking looing for
> feedback on what to do my project on.
>
> r
>

The entities in a database are exactly those needed by the application. Design your app, and you'll know what entities you need. Don't design your app, and it won't matter any way. In that case you can use the following:

CREATE TABLE MY_HOMEWORK

   (ID_NUM              CHAR(5) PRIMARY KEY,
    STREET_ADDRESS      CHAR(25),
    QTY_ON_HAND         INTEGER,
    ANNUAL_SALARY       INTEGER,
    OFFLINE_DATE        DATE,
    STATUS_FLAG_1       CHAR(1),
    FATHERS_DOB         DATE,
    VENDOR_CODE         CHAR(4),
    AMOUNT_DUE          NUMBER(5,2))

--
Ed Stevens
(Opinions are not necessarily those of my
employer)


--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---
Received on Wed May 19 1999 - 14:28:57 CEST

Original text of this message