Anyone good with MS Access and SQL statements regarding Database Design - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Anyone good with MS Access and SQL statements regarding Database Design

gs-rai Avatar
5y, 7m agoPosted 5 years, 7 months ago
Hi im working on a project where creating a database
Its regarding a car mechanic company who go out and repair broken down or cars what have been in an accident.

Anyway the main target behind it is once iv created the database, i want to be able to be able to use data mining tools to find 2 ways of analysing two different parts of the business.

For example. For every job 2 technicians get sent out. Each technician varies on level of skill/qualification.

So some sort of SQL to show how the level of job efficiency is affected by what technicians are paired together..

Efficiency being judged by how long they take to repair (arrival time on the scene to leaving time)

The above sounds so brief, but hopefully someone will understand what i mean. Just looking for an outside perspective.
gs-rai Avatar
5y, 7m agoPosted 5 years, 7 months ago
Options

All Comments

(5) Jump to unreadPost a comment
Comments/page:
#1
Your answer depends on what you database looks like. Plus you need to provide more detail.
#2
I will take some screen shots to show the basic design. Im just changing some stuff around for now. Will have it up in an hour or so.

Cheers for the reply back.
banned#3
Is this a real product or a school project?
#4
its a exam for his next job (his interview is tomorrow!) lol
#5
Your answer depends on what you database looks like.

This.
Was the database designed? Or is it just a bunch of tables thrown together? Do you have a Logical Process Model?

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!