System Analysis - Normalization fix

We have to re upload a picture of the normalisation tables because we made a small error that affected all of the forms and made them all incorrect. We had to add a compound key to bring them all together.

- Karl Harrison

Assignment for System Analysis

Hello Everybody well today i am working on the assignment and cannot upload anything yet so you would have to be patient but we are in the middle of drawing out the Diagrams and That's it :)  

Hello People sorry i haven't updated this blog and i am going to show you what i have been doing

Group Work on case study

We have been busy this last couple of weeks and we have to create a problem/requirements spider diagram and catalogue for the Sandwich bar case study and then we have to present our finding, so here our little spider diagram that we have done so far :)

 

Answers to our questions...

-       What is the current process procedure?

o   For what ?

-       How are bookings currently taken?

o   Reception fill in booking forms, update the booking tables which come from Administration.  Fill in Amended Booking Forms - both sets of forms go to Administration where they are computerized. Reception does have access to a list of members which includes membership type, whether they are part of a corporate booking etc.  This information is generated from Marketing Department via the Membership co-coordinator and Finance who have the list of corporate accounts and people who can use them. 

-       How is the information currently stored?

o   Do you mean the booking info? If so this is stored in a box under the desk at reception and taken to admin at the beginning of every day.

-       How are current payments taken? Do you and how would you like them changed?

o   Invoices are sent to customers through the finance department.  When we take payment at the desk we create a till receipt one copy of which goes to the customer.  The till roll goes to Finance at the end of the day.

o   We also record the payment in the Payment Journal which also goes to Finance at the end of the day.

o   Yes – this could do with being changed, it is inefficient and data is easily lost.

-       Would you consider networking your computer systems? (Linking them together to save data)

o   Yes

-       Would you consider changing your current booking forms format? 

o   Yes – if it makes things more efficient

-       Would you consider computerizing the payment journal? (New payment system)

o   Yes – if it makes things more efficient

-       Would you consider changing how the time sheets are collected? (Input data via computer)

o   Yes – if it makes things more efficient

Systems Analysis and Design Week 2

Here are the questions that we have come up with out of our group;
What is the current process procedure?

*how are booking currently taken?
*How is information stored?
*How are payments taken & would you like them changed?
*Would you consider networking computers? Link together, save data.
*Would you consider changing the booking forms format?
*Would you consider computerising payment journal?  A new payment system & booking form( regular + consistent)
*Would you consider changing the time sheets collected (input data)?

That's all we done and we are now sending a email to Anna to confirm the questions we have come up with and that's all folks :) Peace out

Questions...

This week we have gathered into groups which we are a group of 4. We have thought up of certain questions in which we will ask Whitfield Sports Center. We are now deciding on specific team roles throughout the group.