Peer reflection

Evaluating the solution

I began this project with no prior knowledge on how to use access or what it is used for. However I practiced  using a YouTube clips that showed what to do to create the database using access. I also  briefly learnt how to make relationships and queries. Towards the end I learnt how to make reports as well as forms.

I began this project by doing the investigation, this task for me was fairly easy as I had the assistance of a search engine e.g. Google. and most of it was just gathering information and ideas to start off with the project.

The second part to this assessment was to design our database, I found this tricky as I had to go back to access and remember how the database looks. 

I then had to complete the final task, the create.I realized there were many faults in the design, therefore I fixed the information put into the fields as well as the records. The create was the longest and the most difficult task in my perspective

Creating the solution

I created a Student and Teacher tables and added the data that fit the fields, Afterwards, i connected the relationships between the two.

Developing ideas

Resource list:
-Microsoft Access
-Laptop
-The internet
-Teacher
-USB drive

Step-by-step time related plan:
-Experiment with Microsoft Access.
-Learn how to create queries and database tables. (e.g. by watching YouTube videos)
-Research and collect data that is needed to carry out my consumers needs.
-Create Queries and tables to organize my costumer's data.
-Ask friends to reflect on my creations for improvements,

I should spent most of my time on learning how to use Microsoft Access and creating queries, because if i fully understand that, the rest of my plan can be carried out fast and smoothly.

Creating a Database for an Organisation- Inquiring and Analyzing

Term 1

Unit: Database

Statement of Inquiry: How can a business or an Organisation modernize its records using Information Technology?

Global Context: Globalization and Sustainability

Investigation:

A database is a way of sorting information in an organized, logical way. Databases are usually created using Microsoft access. The meaning of keeping records is "the maintenance of a history of one's activities, as financial dealings, by entering data in ledgers or journals, putting documents in file, etc." to help my costumer to keep his records, I will design database tables and queries.

My costumer is the principle of EIS-M, his request is to design a database including information regarding the students and teachers attending the school. To provide what he wants, I can use Microsoft access to set up data tables and queries. My costumer will use the database I will create for organizing teacher and students' schedules and having access to information in an organized and clear format. In the organization/ school, the product will be used more heavily by managers and teachers. I am going to provide a design solution by presenting students' classes, teachers and grades, and teachers’ classes and students. After than making connections between the two.

1-      Dictionary.com. Dictionary.com, n.d. Web. 28 Nov. 2014. <http://dictionary.reference.com/browse/record-keeping>.

2-      "DATABASE TECHNOLOGY." DATABASE TECHNOLOGY. N.p., n.d. Web. 28 Nov. 2014. <http://www.ercim.eu/medconf/papers/jeffery.html>.