Evaluation:
The Database was successfully created with 4 queries and 2; forms, queries and tables and one relationship. The overall appearance of the database looked good, with the aesthetics of the reports and the overall ease of use of the forms. All the systems appeared to be in working condition, being the queries and each of the forms are able to input data into the tables, with minimal extra work. The data can pass through the forms successfully and it enters the tables correctly in the correct fields. I needed to change my form design as it was quite hard to use, the adding of buttons allowed the forms to be more user friendly and made it easier to input data with an efficient use of time for the client.
Stage 1: Creation of the tables and relationship of supplier code
The creation of the tables were fairly easily as it was a case of following the plan that I had created, regarding each of the fields for both tables. Both tables included the field "supplier code", this was used in the relationship to relate each object to a certain supplier to allow multiple objects to have the same supplier, this brought up supplier information in the queries even though the data is in two different tables.
Stage 2: Creation of Reports and Forms
The creation of the reports were fairly easy, with little or no problems as the report wizard is pretty straight forward to use. I created the report in a simple table design with a few select fields that are important including product ID, Supplier Name, price etc. The Forms were slightly more complicated as they required the use of buttons and each had to be used for a different button, this was very time consuming.
The topic relates to the global context, globalisation and a sustainability as it shows how everything is connected. Owning or running a shop in this age requires efficient use of technology and this topic highlighted the use of technology in everything we do. This also shows the close link between communities and human-made ICT systems.
This project answered the question of what a database is. It showed that Databases are useful organisers of data that allows easy input, output and organisation of data, it is an alternative to having physical records in folders, instead having all the information of products in sorted tables and queries. The advantages of a database's digital records over a regular physical records is that a database can be uploaded and accessed anywhere if need be as opposed to having to physically be there with the records. The Database allows you to easily "access" and search for records as opposed to manual searching of records through files and cupboards.
Peer Assessment:
I was peer assessed by Nathen and as you can see the results are mediocre. The Inquiring and Analysing criteria is lacking quite a bit as it is missing, the important sections, including the research sections, can be filled out and have more information. The analysis could have included three different organizations with advantages and disadvantages. The analysis and the research could have utilised sources and Documented them in a bibliography. Some Questionnaires or surveys could have been used to understand customer tastes and preferences. In Criteria B the designs or plans o f the database, although I included two of the tables, I could have included the forms or the reports and maybe some of the queries. The rest was adequate enough for Nathen to agree with.
The Database was successfully created with 4 queries and 2; forms, queries and tables and one relationship. The overall appearance of the database looked good, with the aesthetics of the reports and the overall ease of use of the forms. All the systems appeared to be in working condition, being the queries and each of the forms are able to input data into the tables, with minimal extra work. The data can pass through the forms successfully and it enters the tables correctly in the correct fields. I needed to change my form design as it was quite hard to use, the adding of buttons allowed the forms to be more user friendly and made it easier to input data with an efficient use of time for the client.
Stage 1: Creation of the tables and relationship of supplier code
The creation of the tables were fairly easily as it was a case of following the plan that I had created, regarding each of the fields for both tables. Both tables included the field "supplier code", this was used in the relationship to relate each object to a certain supplier to allow multiple objects to have the same supplier, this brought up supplier information in the queries even though the data is in two different tables.
Stage 2: Creation of Reports and Forms
The creation of the reports were fairly easy, with little or no problems as the report wizard is pretty straight forward to use. I created the report in a simple table design with a few select fields that are important including product ID, Supplier Name, price etc. The Forms were slightly more complicated as they required the use of buttons and each had to be used for a different button, this was very time consuming.
The topic relates to the global context, globalisation and a sustainability as it shows how everything is connected. Owning or running a shop in this age requires efficient use of technology and this topic highlighted the use of technology in everything we do. This also shows the close link between communities and human-made ICT systems.
This project answered the question of what a database is. It showed that Databases are useful organisers of data that allows easy input, output and organisation of data, it is an alternative to having physical records in folders, instead having all the information of products in sorted tables and queries. The advantages of a database's digital records over a regular physical records is that a database can be uploaded and accessed anywhere if need be as opposed to having to physically be there with the records. The Database allows you to easily "access" and search for records as opposed to manual searching of records through files and cupboards.
Peer Assessment:
I was peer assessed by Nathen and as you can see the results are mediocre. The Inquiring and Analysing criteria is lacking quite a bit as it is missing, the important sections, including the research sections, can be filled out and have more information. The analysis could have included three different organizations with advantages and disadvantages. The analysis and the research could have utilised sources and Documented them in a bibliography. Some Questionnaires or surveys could have been used to understand customer tastes and preferences. In Criteria B the designs or plans o f the database, although I included two of the tables, I could have included the forms or the reports and maybe some of the queries. The rest was adequate enough for Nathen to agree with.
No comments:
Post a Comment