Search This Blog

Thursday 20 November 2014

Database - 'Inquiring and Analyzing'




Scenario:
As an It designer you have been approached by an organization of your own choice to create a database for them. Write a scenario explaining what you need to do and how you are going to respond to their request.

Company/ Organization - Trick 'o' Treat Candy Production:
My idea for the company that I will be making a database for is a candy shop that sells goods all year round. I chose this as my idea as I have a variety of products to work with and it is something many people may like.
         
Planning:
Who is my customer - the owner of the candy company Trick 'o' Treat Candy Production and further into the business my customer will be the customers that would like to order candy from the store as they will have to check out the database and fill out the forms provided for the delivery.
What does he/she want - the owner of the company wants me to create a database to help organize the amount, sale and identification of the product because they have a problem on keeping track on amounts bought and sold of their product.
What can I use to provide what he/she wants -  I can use Microsoft access to help organize the data required in a table in fields and records so. The fields will include the various fields required to present the products in the records below. For example type of candy, amount delivered/sold, how much stock etc.                                                      
Where will he or she use the database you create - they will use it in their shop either on the counter or somewhere else to keep track on the produce that comes in and goes out. It will keep them organized and allows customers to have an organized choice with no trouble at all when purchasing their product of choice.

How can I help my customer keep records -  With the help of a database my customer can keep records in an organised table to keep track on various rates and amounts.
Who in the organisation will use the database -  The person at the counter will be able to record the amount of the product sold and synchronize it to the database used by the person who would be in charge over the database.
When will they use the product -  The people who are a part of the company will be able to have a view on the deliveries required and the amount of candy sold and bought by the production center. Customers will be able to buy candy at the store but also order it and book an amount.
How am I going to provide a research solution - I would have to come up with all the fields and the records for each one of them. I will have to work with the company and research what fields would be needed and how many records and what they are having trouble keeping track of.
What are my limits to this project - My main problem would be the resources as it may take time to download most of the applications needed to help support my data base. Another problem will be the time if it would have been set as it takes time to create forms and queries on Microsoft access.

Research:
What is a database - A table constructed by records who are assorted under fields based on the product. Records contain various situations that belong to a series based on the field.
How can I create a database - With the help of Microsoft Access I can create a database for various needs and I can include various checks to make sure my data is up to standard. Queries can also be created if the client has any doubts and forms for a booking or a need for a delivery of the product.
What does my customer do with these records -  My customer can store data under fields that can consist of amounts and identification characters or any other information required which helps keep work organised and easy to use.
Means of keeping records -  Before the use of databases companies and business used folders and files to keep store important data. all a database is, is a group of files and folders on a computer.
What would be the possible solution using the software and computer system the customer has in his/her organisation - If the data I require exists in that system then the only thing I would need to do is probably update that system to help in the current time.
What level of computing skill is required by the user of the database - The user must be organised and he must be a forgetful person because when you are organising the income and outcome of the company in terms of amount of produce you will need to keep updating the system as a candy shop is usually a fast paced business just like the supply of other food industries.



1 comment:

  1. Hi Nathen,
    I like your idea of the company. But would like to see more work on that. The questions show basic answers with very little research.
    Anyways you have only a week to complete the entire project. So get working and good luck.
    Ms.Veena

    ReplyDelete