P2 M2 prototype and home style

P2

ryan luckins

P1 (unit 43)

D   Multimedia in ICT	Definition	Example	How the media will meet the school’s objectives	How the media will meet the intended audience’s needs.
Sound	Something that you hear or what can be heard.	Voice over from the video showing what is being shown on the screen. Also music when the voice is not in action.	This type of multimedia help the school promote the subject by giving a clear indication on what task and activities are done in the department.	The sound over the top of the tour will entertain the audience while educating them about the opportunities and demonstrating the equipment and talent of the students at this school.
Animation	A film, television    program, computer game etc that has pictures.	A short film showing the that is done in the department. .	This type of multimedia helps to meet the school’s objective as the animations on screen will give an extra bit of information on every slide.	.      Thew animation that is being presented on the screen will hopefully grab the audiences attention.
Still Images	Still images will include logo's of the programs that are used in the department and maybe images of staff that teach certain tasks.	still images of students on the computers that is showing work being done.	This type of multimedia helps to meet the school’s objective of promotion and advertising as showing the stuents working, staff teaching and programs that are used will grab the audiences attention.	using still images of students doing work will give of the vibe that the quality of work is of a good standard.
Moving Images	Moving images such as GIFS can be used as a before an after stage of students work.	An example of this would be if a student was editing a image on photoshop, the image would include the student just starting the work and the student almost completing the work	This type of multimedia helps to meet the school’s objective of advertising and promotion by showing how the students can finish work within the lesson in a good quality.	Using images from previous performances is educational to potential students as it shows them what the subject entails and also will entertain them as that is the purpose of the original performance.

P5/M3

P1 update

What Is A Database?
A database is a structured collection of data that is organized in a certain structure so it can be easily accessed.    You do this by using tables which consist of columns and rows where different data types are stored. Databases can be classified according to types of content: bibliographic, full-text, numeric, and images.

Main features of a database;
- Tables
- relationships
- Data entry forms

Data Types;

- Text/Alphanumeric: This is simply known as text. It also consists of symbols and numbers and is used for all software.  

Numeric Data:

- Numeric data consists of numbers. It can also have decimals, fractions and positive and negative numbers.

Date/Time:

Is simply just date and time.

Boolean:

Boolean date can only consist of two values, Yes/No True/False On/Off 

Database Relationships

• One-to-many and many-to-one relationships 
• An employee can work in only one department; this relationship is single-valued for employees. On the other hand, one department can have many employees; this relationship is multi-valued for departments. The relationship between employees (single-valued) and departments (multi-valued) is a one-to-many relationship. 
• Many-to-many relationships 
• A relationship that is multi-valued in both directions is a many-to-many relationship. An employee can work on more than one project, and a project can have more than one employee. 
• One-to-one relationships 
• One-to-one relationships are single-valued in both directions.

Electronic and Paper Databases

A paper based system can only be used in one way which cannot be easily searched, modified, or accessed. A lot of written databases are now being put on computerized systems as it is more efficient but takes a lot of effort. 

Electronic databases are a lot easier to handle than a paper based database as it eliminates all of the problems a paper database has. An electronic database has it's advantages and disadvantages, If a document on a computer is erased it is automatically put into the recycle bin therefore it is never really deleted. A disadvantage would be if a database was put on a memory stick and was not saved correctly and the stick was lost that database would be gone forever.   

Interfaces
These are tools that are used by a software engineer, developers and programmers which are the middle man of components. Forms, reports and switchboards are the interfaces used inside a database and help to organize and communicate with the data base as the forms are used to log in information.

Report
A report is used when data form a database is summarised and presented so it is easy to read. A question would be put into the database like "how much profit did we make in july?" and the answer would apear in a structured form. 

Forms
A form is an interface that someone uses to create a database. It has a wide range of different command buttons that perform to certain demands. The button can be designed to how to user wants and which information is displayed on the form.

Switchboards

This acts as a menu button which enables standard commands to be run. for example if a button called "films" is pressed then all the films should appear in a form.

P7 (CORRECTED)

task4 Task5 UPDATED

CORRECTION

P2 (unfinished)

d1

D1

Common Mistakes when Creating a Database

Deletion of Fields: this can happen when someone has direct access to the database and deletes or edits fields by accident. To prevent this from happening the database should be updated and backed up on a regular basis. If the database is updated regularly there should not be a problem with deletion of files. Another way that you can prevent this from happening is to only allow members of staff use a (read only) copy of the data base, this way nothing can be moved around Validation rules:

Validation rules that are put into the database in the creation. They stop bad data being saved in your table.  You can create a rule for a field , or for the table. Use the table's rule to compare fields.

Null Values:   NULL values indicates that the field is unknown. A value of NULL is different from an empty or zero value. No two null values are equal. Comparisons between two null values, or between a NULL and any other value, return unknown because the value of each NULL is unknown.

Incorrect data types: when completing a data entry form there are certain fields in which you can write. These are called input masks the masks can be made to only accept data such as integers, floating point numbers, characters, strings and arrays.

M1

M1

Relational Integrity

Referential integrity is a database concept that ensures that relationships between tables remain consistent. When one table has a foreign key to another table, the concept of referential integrity states that you may not add a record to the table that contains the foreign key unless there is a corresponding record in the linked table. It also includes the techniques known as cascading update and cascading delete, which ensure that changes made to the linked table are reflected in the primary table. 

Primary Keys
The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server).

Foreign Keys
 A foreign key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables. 

Database relationships are similar to relationships in the real world, for instance your parents, siblings and other family are all relations. 

Relationships

One to one relationships; each primary key will relate specifically to one or none record in the table
One to many; This primary key will relate to one, none or more than one records in that table
Many to many; Each key in both tables can relate to more than one or any number of records.

p1