P2 House style Updated

P2 Story Board

P2 prototype Updated

P1 Unit43

Type Of Media	What  & Purpose	Platform	Audience
Video	Interview with media teacher explaining what tasks they do in media and what a future media student should expect also a media students work to back what the teacher is saying this is to inform and entertain the audience	Windows & Mac OS	The audience of the virtual tour will be potential students that maybe coming to school to do Media studies and want to see what sort of facilities the school has through a virtual tour rather than visiting the school also showing what type of things they do in media studies and what they can look forward to in that subject and compare it to other schools also parents of students who might want to know what the school is offering to their children and maybe want to know what their children are doing at school in Media.
Text	To inform the audience and give them information on the subject. The purpose of this is so that the audience can understand what they’re looking at as they would not know what was what without text.
Images	Images of department to inform the audience what sort of facilities the department has.
Audio	Audio in a virtual tour could be used for people who can’t read could use a Voiceover to inform and entertain the audience also you could also add sound effects to the virtual tour for example when the audience presses to move down a corridor you could have a footsteps.
Graphics	School Logo to inform the audience  so that the audience know it is official and so that it looks formal and professional

P7,P5,P6

Task 6

P2 , P3 , M2 , P4 ,P5,M4

                                                            Macro In Design View

d1

Deletion of Fields/Records

You can prevent the deletion of fields/records by backing up the database so that you can restore the database back to the last back up if a deletion occurs which many companies do although some data may not be retrievable if it was added after the last backup most backups are stored elsewhere so that they can’t be deleted. A cause of a deletion is normally human error where they have hit the delete key by accident that is why many databases ask you if you’re sure you want to delete this field.

Incorrect Data Types

To prevent incorrect Data Types many database’s use multiple choice questions so that the wrong data can’t be entered into the database and the data inputted is relevant and forms can be completed quicker and more accurately than if it was just a text box and people may put irrelevant data.

Validation

A Validation rule limits and controls what users can controls what users can enter in a table field or a control .Data types provide the first layer of validation. When you design a database table, you choose a data type for each field in the table, and that data type controls what you can enter.

 Field sizes provide another layer of validation, you can set a character limit on a field so you can prevent a user from spamming text into the field, or it can prevent an inexperienced user from mistakenly entering the wrong data.

Null values

Null values are shown when data isn’t entered at all or incorrectly similar to validation as it is there so that information is entered correctly this happens when information that the database needs isn’t entered and it comes up telling you what you have missed the question normally has a * to show that the information is needed to complete the form

M1

M1

The Primary Key Identifies each record in a relational table

 

Example; Imagine we have a users table that contains a record for

 each student at a school or in a club. The student's unique student or members ID number Would be a good primary key as some may have the same first name or last name so they wouldn’t be a good choice as you could make mistake of identity.

 

A foreign key is a field in a relational table that matches the primary key column of another table.

 

Example

This could be a user ID as this is most likely to be in more than one table and it is the primary key in the members table this could be in a payment table this would create a relation to the 2 tables

 

Referential Integrity is a database concept that makes sure that relationships between tables remain consistent .When a 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.

P1