Question:
Hi there.
I'm currently studieing ICT at AS level, and we have to produce a database using Microsoft Access. The trouble is, I'm not sure what to base it on.
Has anyone got any ideas?
Replies will be thanked.
Cheers!
Answers:
DVD rental shop ?
Answers:
My son based his around the fact his school was setting up houses, and points. Using a list of pupils, and then giving them a rating for sports, behavior, academic skills, etc., to split them up fairly in the first place, then a created a points table for achievements, and demerits.
Do something you know well if you can, and if it can be useful to a sports club etc., all the better. Try to stay away from the mundane CD lists, and see if you can get an excel file of the data, typing in a list of names is very boring, and does not really show you can use Access. I am sure we have some sample papers in his mountain of rubbish left when we went to uni. Does your school have any, these showed projects which had got A, B and C grade results.
The fact Mum is not bad at Access helped too!
Answers:
Agree with MadCowMan. You want any scenario where you are trying to keep track of hiring/renting or loanding things to people.
e.g. DVD/Video store, musical instruments, camping equipment, library
This was you has 2 entities (people and objects) and a relationship (hint: one person can rent many DVDs but one DVD can only be rented to many people but only one person at any one time)
Ideally you will also want a "customer" for whom you are going to develop the database for as it will make it alost easier to perform a requirements analysis and evaluation for the database.
Answers:
Agree with MadCowMan - I used to work for Oracle and this is the exact scenario we had to build when we joined.
You can have all sorts of things - inventory, user maintenance, overdue letters, stock reports etc. Lots of flexibility there for you.
Also, agree with donny-gal if that doesn't interest you - find something that does. Here's some more ideas:
- Mate of mine rewrote a company car management system at one stage (costs, links to reviews, specifications, optional extras, order form to get one)
- pseudo-online dating system
- Share portfolio manager
- Employee / HR system
- Cut-down (and free) version of Microsoft Money - track your money coming in and out, reports of biggest expenditure by value / category / date range.
I quite like the sound of the last one, especially given the forum you are asking!
HTH,
Faqqer
Answers:
Agree with MadCowMan - I used to work for Oracle and this is the exact scenario we had to build when we joined.
You can have all sorts of things - inventory, user maintenance, overdue letters, stock reports etc. Lots of flexibility there for you.
Microsoft use a library system as a demo database on their SQL courses too
Answers:
How about a Hotel booking system
Answers:
in the good old days the scenario was always an airline booking system, thats always a pretty good one as there are a fair few inter-relationships
Answers:
i work in a school and alot of the a-level course for access is around somekind of booking system for a bussiness.
Answers:
Agree with the all the above.
First find a subject that you enjoy. It's much easier to envisage how the data relates if you understand it. What are your hobbies? Are you in any clubs or anything that uses scores / points?
I suggest registering with . It's free to use and you get LOADS of help (they won't write it for you but will give you direction when you get stuck).
There are numerous threads on there relating to the Normalization of data. Strongly reccommend that you get your head around that before you start.
Answers:
Has ICT replaced Computing then? When I did my AS level in computing, our project involved writing a program. Mine was a geometry teaching and testing program. Was quite proud of it, did it in BASIC and had to put in subroutines to handle displaying superscripts and the pi character. The test questions involved random numbers as well so it would be different every time you took the test. Ended up getting a C for the AS level overall which was a bit disappointing. Not much help to the OP but just reminiscing on my own experiences. The databases we set up during GCSE were usually a book/library lending system.
Answers:
I did a database based on fictional crimes and the people who may of commited the crimes and appearance a bit like the national crime database so you could have hair colour, eye colour, height, weight, distinguishing features so on and so fourth, I quite enjoyed it making up lots of fictional charcters then doing a search within the database of people with certain features as listed above.
Answers:
How about a criminal record system for criminals who are convicted abroad. Then sell it for ££ millions to the Home Office - the numpties there need one!
Answers:
How about a criminal record system for criminals who are convicted abroad. Then sell it for ££ millions to the Home Office - the numpties there need one!
Lol, you really think the Government would be interested in something that would increase efficiency and productivity. That would only happen if it was an expensive project that claimed to do that but doesn't actually work.
Answers:
>you really think the Government would be interested<
To be realistic the ICT coursework should include 2 years spent on a 'technology demonstrator', ensuring that all stakeholders were agreed in principle that the project could move to a limited pilot, while simultaneously running the old system in parallel, doubling headcount. A report with the benefits case would then be submitted to the Minister for consideration, after which an invitation to tender would be published in the European Journal. After best and final offers (6 months later and at 500% what the private sector would pay), the selected system integrator would spend 2 years coding the system from scratch using unproven but CV enhancing technology, before finding that the original requirements were hopelessly outdated. Public sector ICT...never has so much been billed in consultancy, by so few, at such cost to so many tax-payers
Answers:
You could do it on cars
like make, model, year ,registration ,color no of doors and price or popstars ,footballers,countries in the world ect lol i just read it off our homework.
Answers:
Cheers everyone!
Thanks button not working too well at the moment.
Answers:
Lol, I did a Video Rental System back in the day too (about 7 years ago). It's a good system to use as there's plenty you can do and it's quite flexible. Plus if you finish with time to spare, there's lots more you can do to the system.
Answers:
Plus if you finish with time to spare, there's lots more you can do to the system.
That's a very good point. Sometimes it's hard to estimate how long a project will take. When I wrote my program for my computing project it was very modular and was set up to easily be expanded by adding additional modules (in my case different teaching subjects etc) without having to alter the structure of the main program. It's worth thinking about a project where you could easily add features/content if you have time but still have what looks like a complete project if you don't have time.
Answers:
Did exactly the opposite for my major project at university. Learnt from that mistake. Came up with what was a great system but it was far too much and I lost marks for lack of completion (despite working like a dog to get most of it done).
As SS has said, and I kind of pointed out. A system like the video shop is fairly simple on the outlook, and if you're pushed for time you should be able to finish it. But should you have more time, or want to make sure you get an A, there's plenty of extra "modular" stuff that you can add in.