Data Dictionary

November 17, 2009

In information systems yesterday we learned about data dictionaries.

A data dictionary is a document which contains information about the different data items in a database. Also we looked at examples of databases and we had to give each database a data dictionary.

For example we looked at a car table and a rental table, in the dictionary we named the entity, attribute, type of field, validation and what kind of key. To get practice go on edmodo and go on the link for the wikispaces where you can practice data dictionaries (sorry couldn’t get link.)

by Ewan

 

Advertisements

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