Turn on thread page Beta
    • Thread Starter
    Offline

    0
    ReputationRep:
    Hey, was wondering if anyone can help me with the design of Tods Tyres, i need help with the Entity Relationship Diagram, Data Flow Diagram and Normalisation.

    Please any help will be much appriciated!

    Cheers
    Offline

    0
    ReputationRep:
    theres ones of the data flow diagrams that has to be dones for this tods tyre thing the 1 for sendin invoices is very similar only it sud have the following titles for the boxes going from left 2 rite row by row

    customer (arrow) Check Booking (arrow) booking records
    (arrow)
    change tyres (arrow sayin update) car records
    (arrow)
    calculate costs
    (arrow)
    customer (arrow saying send to) print out billing invoice (arrow) invoice file (arrow saying duplicate copy) accountant

    hope that makes sense
    Attached Files
  1. File Type: doc Data flow diagram for booking a car in for a service and tyre change.doc (31.5 KB, 490 views)
    Offline

    12
    ReputationRep:
    That is very helpful and kind of you. Look's perfecto.
    Offline

    0
    ReputationRep:
    thanks
    • Thread Starter
    Offline

    0
    ReputationRep:
    Yeah makes sense and helps me a lot.

    Thank You Very Much
    Offline

    0
    ReputationRep:
    Thanks for that Clair.
    Offline

    0
    ReputationRep:
    my email is [email protected]

    please can you email me, your dfd's ,, so that i can have a look,

    i will be happy to email my database,,

    regards
    Offline

    0
    ReputationRep:
    Out of intrest, what program are you designing this system on?
    I have to use Delphi, and program a bespoke program fgrom scratch.
    Offline

    2
    ReputationRep:
    (Original post by Gromituk2k)
    Out of intrest, what program are you designing this system on?
    I have to use Delphi, and program a bespoke program fgrom scratch.
    Visual Basic.....some people on here who are usig Delphi say it requires a lot more lines of code. Is that true?
    Offline

    0
    ReputationRep:
    ive done mine in delphi and mine takes up almost 4000 lines of code...
    Offline

    2
    ReputationRep:
    (Original post by Soul Reaver)
    ive done mine in delphi and mine takes up almost 4000 lines of code...
    :eek:
    mine is just above 1000, and that's including the comments!
    Offline

    0
    ReputationRep:
    holy ****! we are doing ours on MS access, and its really really ****! our teacher is for **** all and giving us no help, and access is a piss poor program to do this stuff on. We still havent started writing out our reports and the exams on monday.!! If anyone else is using access then please tell me how to do the calculations for the invoices. Thanks.
    Offline

    0
    ReputationRep:
    (Original post by mockel)
    :eek:
    mine is just above 1000, and that's including the comments!
    what! i thought 4000 wasnt that much at all lol concidering all i have in their is the code to do what the sylibus asks and comments :eek:
    Offline

    2
    ReputationRep:
    (Original post by Soul Reaver)
    what! i thought 4000 wasnt that much at all lol concidering all i have in their is the code to do what the sylibus asks and comments :eek:
    VB must be a lot simpler
    Offline

    0
    ReputationRep:
    (Original post by nrg106)
    holy ****! we are doing ours on MS access, and its really really ****! our teacher is for **** all and giving us no help, and access is a piss poor program to do this stuff on. We still havent started writing out our reports and the exams on monday.!! If anyone else is using access then please tell me how to do the calculations for the invoices. Thanks.

    k, i can.

    U need to do a report based upon a query

    Obviously, I dont know how ur tbl's r set out. Relationships and all that but here goes.

    U needs to do an IFF statement cos u have to take ito considerations VAT.
    All ur fielsd names will b diff but, first u work out VAT, pull up priceexVAT, all that stuff.

    Then the for the final price its


    FinalCustomersPrice incVAT: IIf([Discount]=True,[CustomersPrice exVAT]/100*95+[VAT added],[CustomersPrice incVAT])

    does that help, it works aswell.

 
 
 

University open days

  1. University of Cambridge
    Christ's College Undergraduate
    Wed, 26 Sep '18
  2. Norwich University of the Arts
    Undergraduate Open Days Undergraduate
    Fri, 28 Sep '18
  3. Edge Hill University
    Faculty of Health and Social Care Undergraduate
    Sat, 29 Sep '18
Poll
Which accompaniment is best?

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

Write a reply...
Reply
Hide
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.