Evalution of my database

by sashakw (student)

Table of Contents

Evaluation of the performance of my database

For my database assignment I used certain Properties for example I used field types and field sizes very well in my work because I changed the size of the field to fit the right amount of data in and also field types is where I choose what sort of data will be entered into my database (etc... Text, Number, and Currency) if these changes were not made my data would have given false data. These were very easy to do as I simply had to use my instinct to know what field size and field types were accurate. Some of my fields didn’t really have to have a certain field size but I chose to put one in as for the field types it was advised for me to put them in as my data would have been entered incorrectly.

It is easy to extract useful information from my database because you can easily read the information and the field are named accurately. It is simply to find certain information because there are ways you can use the database to find these information it makes it easier for the customers in the long run to be able to gather information from a certain criteria’s. I didn’t have any problems with this area because it wasn’t as difficult as I intended it was.

My validation prevents data entry errors because I have tested each and every one of my validations and they work perfectly so there will not be any data entry errors. I have also entered input mask for some of my validations these will make sure only a certain amount of numbers are entered into my database which will help people to not enter the wrong data. The good thing about having the validation in my database is that I know that the data being entered is correct and will save me a lot of time.

This is a preview of the whole essay

The qualities of my reports are moderately good they show the information that you get when searching for a certain type of data. But before I started my reports I got confused on what exactly the reports show as they were a written form of my queries but I eventually understood what they were showing. I have stated which are my primary keys and which are my foreign key and from my primary key, foreign keys and also my fields of data I have created a relationship table which shows the relation between each table and their fields. The relationship helps to show me how the data are connected together this will improve the effects of a database. Tables make it easy for the information to be set out and read so when I created my three tables I made sure all the data were easy to read and understand. There isn’t much you can do to make the tables much more effective so I just made sure that the tables were appropriate for the data that will be entered in it.

I made queries that helped to organise my data into certain category which I can also extract information from. Such as what type of bikes are being brought the most or who are buying a certain bike all these can help a company to make a lot of profit and boost sales. I have made it clear what quires I have made to show the company’s qualities. The creations of the queries were very difficult for me as I didn’t know exactly what I was doing.

Feedback from others

Name: Amy Gowland

Date: 03/12/12

Comments: “You have worked to the best of your ability and you’ve shown some understanding in your database”

I agree with this comment I believe that I have worked to my best ability and I have understood what I am doing through my database assignment.

Name: Jackie Suter

Date: 03/12/12

Comment: “Good work you have achieved some elements in your database but you need to work on the other elements to boost your marks”

I have taken these comments into acknowledgement and I also agree with what has been said. So I have made sure that all the elements were mentioned in my database to make sure I get the best mark I can achieve.

Evaluation of my performance during the whole unit

Throughout the whole unit I managed to use the time I had to work on the unit very well I had no problems completing the work, the work was up to standard and handed in on time. When starting the unit I had no idea what a transactional website was this then became clear when I did some research and was taught about it. I had to revise the skill of creating a database as I didn’t know much about databases when I started the unit but I eventually got the hang of it and was able to complete my work. I had trouble with entering the validations but I quickly resolved this issue by finding out how to place the validations into my database and make them work properly. I also came across some problems which were when I wanted to import my data , I was losing some of my data I eventually resolved this by finding out that my data was corrupted I solved this by renewing my data.

I knew what flow diagrams were and how to use them to show information also I already knew how to create a table of data through the software called Microsoft access. I had some basic skills on how security works and the different types of threats there is and how they are prevented through security but I still had to do a few more research on other threats and find ways to prevent them. I have learnt how to rearrange data , take out data , replace data and change data in my database I have also learnt how to create a relationship, queries and query reports. I have also learnt how to make graphs to show the effects of the database.

Feedback from others

Name: Amy Gowland

Date: 03/12/12

Comments: “Sasha has shown her understanding of each assignment throughout the whole unit and has evaluated her work to her best potential. There are also some sections of her work that could be improved”.

I have improved on the sections that I need to and also I doubled checked my work and made sure my evaluations were to my best potential and improved any other sections that might not have been noticed.

Name: Jackie Suter

Date: 03/12/12

Comments: “Sasha has create nice assignments but they all need to be improved for her to achieve a good mark on the unit and some of her evaluations need to give more details (etc. good and bad features)”.

I agree whit these comments I do need to improve on some of my evaluations because these will improve my marks on a whole.

Effectiveness of the database as a whole and own performance in the unit

The database would be very useful for a company because it will show you how well the sales are doing and help you see who are buying what products and give them appropriate deals related to the products they buy. It also makes the company more aware of their customers.

How would you improve your database

To improve my database I could do more research on how a database works and also analyse my imported data properly. I could improve on my design in the database assignment also adding more detail to my work can improve my work as a whole. I do not think that there ar4e any other areas that I can improve on. I think that the work I have currently done is done to the best of my abilities. If there were other bits that I have not noticed that need improving I will improve them.