relational database (1 Viewer)

[MysticalElement]

hey people
i just got my first major ipt assessment ...making a relational database..... i got an idea of what to do but i really want to have a look at some examples so i can pick on ideas and really understanbd what to do...


if u have one i can look at please pm me thanks heaps

 

[LatK7]

Most text books have examples of relational databases in comparison to flat file ones.

It's basically a simple task of arranging common fields into tables to avoid data redundancy. Then you form relationships.

But once again, text books have good examples.

 

[ajdlinux]

I can send you my IPT files including my database task - just PM me with your email.

 

[MysticalElement]

i already have remember


thanks everyone who replied

 

[ajdlinux]

Whoops, forgot who you were...

 

[crazathiest]

I guess I can use this thread to ask for help too. I'm in a similar situation with the relational database, but I won't be starting that yet. I'm more in need of help of where to start for my 'scenario' given.

Scenario:

Students are to design a relational database for a gymnasium. The current way of doing things is via cards and filing cabinets.

Must have atleast 3 tables, 15 fields and use 5 data types.

Design and build a database which will make updated class lists and allow merging of letters to members or instructors.

You must have a switchboard.

I'm just looking for ideas for the first couple of things needed for 'week 1 marking' of the assignment(marked each week, then marked at the end):

Purpose of system, Diagrammatic view of system, Gantt Chart, Context Diagram.

Any idea for this stuff^.

Thanks