Archive for the ‘Databases’ Category

Data Dictionaries Contin.

November 23, 2009

For the past three days(17th-19th) in Information Systems we have been looking at Data Dictionaries.

By now we should know that a data dictionary is a document that contains information about the different data items in a database. If you can’t remember  much,heres Ewan’s post .

We started thinking about inserting multimedia in databases such as images, sound or even a video.

Posted By David

Advertisements

Data Dictionary Knowledge Put To The Test

November 18, 2009

In Class today we put our data dictionary knowledge to the test

We used our wikispace to get different questions which we then made data dictionaries for.

Above is an example of the data dictionaries which we were creating.

We already know from Ewan’s blog that data dictionaries are documents which contain information on different entities and their attributes from a database.

Thank you for reading this blog I hope you found it interesting
Lol

Written by Lee W

VALIDATION IN DATABASES

November 16, 2009

In Information Systems on Thursday, we learned about validation in databases. Data validation allows you to control what values are entered into a field. We talked about the different types of validation checks and what they are used to do.

These validation checks are :

  • PRESENCE CHECK – Does a field HAVE to have data entered?
  • RESTRICTED CHOICE CHECK – Are there only certain acceptable                                                                             values?
  • RANGE CHECK – Does the data have to be within a certain range?

Here is a link that will send you to a website with all the information on validation within databases. http://www.theteacher99.btinternet.co.uk/theteacher/gcse/newgcse/module5/task10.htm

To ensure that you understood the details in this post, I have put in a link which will send you to a quiz on                                                                                             DATA VALIDATION AND  VERIFICATIONhttp://www.bbc.co.uk/apps/ifl/schools/gcsebitesize/ict/quizengine?quiz=datavalidationverification;templateStyle=ict

By Cammy

Implementing a database with relationships

November 11, 2009

Today in information systems we learned how to add relationships between two tables in a database. We created two tables, one including information about lockers and the other about pupils that own the lockers. The relationship is made by adding the primary key from the pupil table which is the pupil ID – a unique number that identifies a pupil – to the locker table.  There is an example of a simple relationship being made between two tables in the picture below.

You can get help creating this on the online help in FileMaker Pro (You can learn more about FileMaker Pro by clicking the link).It is simple once you get the hang of it.

By Emma

Using Edmodo

November 5, 2009

Edmodo image

Yesterday in information systems int 2 period 4 we learned how to use Edmodo.

Edmodo is a site used for homework.

It allows us to answer homework questions electronically and send the assignment back to the teacher.

You can create surveys and send messages. You can choose your own avatar

This helps us as we don’t have to carry it about or write stuff down. It is faster and is better for the teacher as he doesn’t have to carry jotters about and there is less possibilities of losing the work.

We like doing our homework this way because it is much easier and we can talk to others in the class about our problems.

Blog post written by Emma, Kirsty, David and Kerr

Test Post

November 5, 2009

This is a test post for Forrester High School Int 2 IS class