storyboard and house style P2

Task 2 unit 43

:

unit 43 P1

D2 UNIT 18 CORRECTIONS!

another impotent that i had made on my database was that i created a button for the user to click on if they were navigated to the wrong page, such as i created a home button and applied this on every page so people could easily navigate themselves around the database. i have also made it simple for people to add their details to the database, such as they can fill in their details and click add details which will then add them onto the database and they will then have their own username and password generated from these details.

P7 mate

P7 corrections

P7

part p5 mart m3 again

part p5 part m3

P5 and P6

P4 and P6

P4

P6

P2 P3 M2

M1

Add notes that explain referential integrity in a relational database, describing the purpose of primary keys and foreign keys.


referential integrity- 

referential integrity means which primary/foreign key relationships are enforced in a database. By specifying the referential integrity rules you can have the database guarantee, an example of this would be that every sales representative is assigned to a valid office. Through the use of referential integrity constraints, many business rules can be enforced by the database server, instead of your application.

The terms "primary key" and "foreign key" are used throughout these documents.

Primary Key- A unique identifier for a table. A column or column combination with the property that, at any given time, no two rows of the table contain the same value in that column or column combination. this would be your name, age and gender etc...

Foreign Key- A foreign key is a column or combination of columns whose values match the primary key of some other table. A foreign key does not have to be unique; in fact, foreign keys are often in a many-to-one relationship to a primary key. Foreign key values should be copies of the primary key values; no value in the foreign key except NULL should ever exist unless the same value exists in the primary key. A foreign key may be NULL; if any part of a composite foreign key is NULL, the entire foreign key is NULL.

hello daniel

hi daniel hanratty its me sam matthew your loyal companion i hope you are having a good time in our ict lesson because i am having a most enjoyable time !!!

P1 corrections M1 D1