University Assignment Help Needed

[UniStudent]

Hi - I am a final year student on a computing degree.
My tutor issued me with a Database Assignment this week - and today i have been informed by the university that he is going to be off ill for some time. i only have less than 3weeks to complete the assignment and was wondering if someone would be kind enough to help me - as databases is my weak point.

looking forward to hearing from you!

Regards
UniStudent

 

[pbaldy]

Welcome to the site. If you post specific questions, there are always people around willing to help.

 

[statsman]

As a rule, the site will try to assist you with specific answers to specific questions.
However, we will not do your work for you (rather defeats the purpose of going to uni).

Example of a bad question - "Where do I start?"
Example of a good question - "I can't seem to get this query to work. Here is the code I'm using".

Good luck.

 

[UniStudent]

First of all thank you v much! wasnt sure if anyone would bother replying! I most certainly do not wish for anyone other than myslef to complete this daunting task -
I have the created Fact and Dimension tables, i just need helping running and creating a few queries - in order for anyone to understand what i need help on you will need to see the db (star schemas etc...)

my msn messneger ID is wizdood@hotmail.com
i can send you the 4kb access 2007 file for you to have a look at and hopfully assist me!

Regards
UniStudent

 

[stopher]

I would suggest you upload your file here. This explains how. I would suggest you first convert to Access 2000 format so that more folks can read it.

Chris

 

[UniStudent]

Thanks alot! ok so here i av attached the created DB file - From the datamart i need at least 2 different trends/Pattern from within this data, but it has to be in areas that are of oppertunity or concern for the trading situation.

This is the scenario below

[FONT=&quot][/FONT]
[FONT=&quot]SFit[/FONT][FONT=&quot] is the name to be given to the recently outsourced fitness facilities at the University. The new company has taken over the existing university facilities and has expanded them in the light of market research. SFit seeks to expand it’s presence in London by widening its membership to include many more non-student members.[/FONT]
[FONT=&quot]There are a number of membership types available designed to meet the differing needs of its varied membership profile. In line with an outsourcing requirement student and staff membership is offered at discounted prices as are senior citizens. These prices are shown in Figure 1 below. SFit have introduced a casual membership for those who prefer to pay each time that they visit a facility.[/FONT]
[FONT=&quot]SFit[/FONT][FONT=&quot] have a number of facility types (gymnasiums, fitness suites, swimming pools) based at various locations. However, not all locations offer all facilities. On each visit to certain facilities a member can choose to have a personal trainer[/FONT]


I Hope you guys can help - ? - ?


Regards
UniStudent
[FONT=&quot][/FONT]

 

[UniStudent]

No1 willing to help me?

 

[BarryMK]

There is a lot of freely given help on this particular forum but I think the experts who kindly responded to you above would expect you to have actually constructed some queries so they could help you to correct any errors that you found. It is unlikely that they will write them for you from the ground up. You need to do more actual work yourself to get them on side.

 

[UniStudent]

Thankks for that Barry - The help i need is with creating the queries - i want to be able to know who the popualr personal trainer is. but cnt get it to do that ?

 

[Alansidman]

Why don't you start here.

http://www.datapigtechnologies.com/AccessMain.htm

Follow the tutorials on Queries. Create your queries. Then post your SQL here for help.

Here is a second site that will help you to create queries, but you'll need to do them first and get back to us with specific questions.

http://www.bluemoosetech.com/

Alan