MedVision ad

IPT database (1 Viewer)

MysticalElement

Troll Slayer
Joined
Jun 7, 2007
Messages
361
Gender
Male
HSC
2008
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
 

ajdlinux

Mod: ANU, ATAR/HSC Marks
Joined
Sep 15, 2006
Messages
1,890
Location
Port Macquarie / Canberra
Gender
Male
HSC
2009
Do you have any more idea on what your database is going to be than that?

Unfortunately I don't have my 2004 IPT files any more :(
 

MysticalElement

Troll Slayer
Joined
Jun 7, 2007
Messages
361
Gender
Male
HSC
2008
umm we got a few scenarios like a little retail shop like computers or fruit but we can use whatever as long as teacher ok's it any idea for a good scenario? to base the database on
 

ajdlinux

Mod: ANU, ATAR/HSC Marks
Joined
Sep 15, 2006
Messages
1,890
Location
Port Macquarie / Canberra
Gender
Male
HSC
2009
I would suggest something simple like a customer records database.

You have at least these tables:
* Customers
* Products
* Transactions

Each table should be self explanatory. Set up fields for foreign keys in each one, link them together, set up forms, and make a query and a monthly report.

If I had my database project still around I would give it to you =/
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top