what needs to be considered when developing a network strategy

When you create a network strategy you have to consider the kind of topology you are going to use this is how the computers are connected.

bus topology this is when computers are connected to a single cable known as the bus. Data packets are sent out along the bus with the address of the receive.

Star topology this is when all nodes on the network connect to a central node then messages are passed to the central node, and then onto the recipient.

Mesh topology this is when each node must be connected to at least 2 other nodes and If one link is broken, packets can still reach their destination via a different link.

Functions of an OIS

Firstly, a function of an OIS is gathering data. This is just getting all of the data you will require. 

Secondly, Storing Information this is just putting the information into the computer. This may be that the user types the information that has been gathered into a spread sheet and storing it on a hard-drive or a memory stick.

Thirdly, Processing Information this is making the data into information. This can be done in four ways Searching, Sorting, aggregating and performing calculations

Finally, Outputting Information this is displaying the information. 

Validation

Validation is when the database will be checked to make sure it meets the requirements and rules.

There are 3 different types of validation:

Presence check: this is if the field needs to have data entered into it.

Restricted choice check: the value entered has to be of a certain value e.g mr, miss

Range check: the value entered has to fall within a certain range e.g. 0-100, 1 -10.

Unnormalised to Normalised form

To Normalise your database you would first delete the repeating groups that are in the unnormalised form then you would identify the primary key of the new entity then you would create a foreign key to connect the new entity to the original entity.

Extension task,

Unnormalised form:

Instructor ID

Instructor Name

Class Code

Sport Class

Level

Cost Per Lesson

 

First Norm Form:

Instructor:

Instructor ID

Instructor Name

 

Class:

Class Code

Sport Class

Level

Cost Per Lesson

Instructor ID

 

2. the purpose of a key is so that you can link the two table together.

entity relationship diagrams and Data Dictionary

ENTITY RELATIONSHIP DIAGRAMS

An Entity relationship diagram can be one of the following:

One to One(1:1), One to Many(1:M) or Many to Many(m:n).

One to One to is when one thing can only relate to one other thing for example. a football manager MANAGES one football Club
One to Many is when one thing can relate to Many other things, e.g. A football fan can support more than one football club. for example someone might support heart and chelsea.
Many to Many is when many things relate to many other things. e.g. a football can play for many football clubs in his career.

DATA DICTIONARY

a data dictionary is a document which contains information about the different data items in a database e.g about the records.

info systs

entity

anomalies

realational databases

attributes

flat file database

field

record

Database management system

 

Bitmapped Graphics

There are 4 file types;

Bmp, PNG, JPEG And GIF.

 

Compression; this is making the file size smaller by decreasing the standard of quality.

Uncompressed; this is when the picture is not altered. it has the same standard of quality. this means the file size is larger.

256 colour; GIF files use 256 colours so that the file size is keeped down.

lossless compression; this is when the file is compressed but the quality has not been kept as it was originally.

lossy compression; this is when you make the file size smaller and lose quality of the picture. 

 

BMP files are usually large in size as these files do not get compressed so the quality is off a high standard but the file takes up alot of space.