Binary is the language that computing devices can understand. It only uses 2 characters.

The numbers 0 and 1.

Yes

00000011

We need to understand that this system works from right to left and uses a row of doubling numbers starting at 1 to figure out the binary conversion. eg 1,2,4,8,16,32,64 etc actually is flipped to be 64,32,16,8,4,2,1. The numbers 0 and 1 are then placed under this row according to whether they are used in the calculation or not. The number 3 from the previous card, showed that 1 and 2 are used to make 3, therefore we place a 1 under the 1, and a 1 under the 2 becoming 00000011

Data is binary. It is made by computing devices so they can process instructions in a language they understand.

It is when an exact copy of the data is made. This is good for backup files, but really bad for repeating the same data in a database table and must be avoided.

Data integrity is having accurate and consistent data in a database. Types are entity integrity, referential integrity and domain integrity.

Each primary key must be unique and must not be null.

Every foreign key must have an equivalent primary key.

Data in a field must be the correct type or expected values. You can do this by selecting a data type for an attribute. eg the field Age in a table about Student will need to be number data type. (or integer)

This is when the same data is entered two or more times into a database.

An anomaly is an unexpected result in a database. Insert, update and delete are 3 types.

This is not being able to add some data to a table. For example if a new student came to our school (but we don't know from which school), and the current school database had a primary key "Previous School", then we wouldn't be able to add them to our database. As you know primary keys, can't be NULL.

This is when data is updated in one place, but is repeated elsewhere and not updated in that place. For example a table may have several records/rows for Sam Brown but only one of the rows is updated.

When data is unintentionally lost by deletion of a record which has other data in that record. For example in a database with one table and lots of rows, if you delete one row, you lose all the data in that row. There may be good data in some of that row that you wanted to keep.

This means to process information. One example is in SQL where we can find data in a database by using the command: SELECT * FROM Emp; This query will manipulate the data in the database, EMP table to return all data about Employees.

This is protecting the data from unauthorized people and unauthorized use by using passwords to protect it. By also preventing access to certain parts of the database using privileged user accounts.

For a database to work on the web they must use an API (application program interface) or an ODBC (Open DataBase Connectivity) program. This is independent of type of database or platform. eg it will make a windows or mac database work on the web.

It is using rectangles to represent entities, diamonds to represent relationships, and attributes circled and joined by a single line. It is also using cardinality of 1:1, M:1 and M:N.

It is like a user manual to show the user how to use the software.

The personal data must be protected from unauthorized loss or use.

The data must be used as part of normal business processes.

The data must be destroyed and/or de-identified once it is no longer needed for any purpose for which it was collected. Unless, it is needed as part of business archive or for tax purposes.

readability, navigation, logical order and inclusivity (use by all)

It stands for Relational DataBase Management System.

The purpose is to organize data for a company or business in the most efficient way, so it can be used effectively by the company.

The purpose is to show to other developers the structure of the database. It is a table in the database with details about the fields in the database.

name, data type, size of field, format, constraints and other details to help a shared understanding of the database.

It is changing the database structure so each table only has attributes about that entity. The opposite is flat file database with lots of data all in one table, eg employees, department, sales. A normalized database will put those into a single table for each.

1. Remove repeating groups into their own table. 2. Allocate the original primary key as a foreign key to this new table.

Make sure that the information in any one table is only about that one entity. If not, make a new table for the other data.(To be in 2NF it must be in 1NF and all non-key attributes depend on the primary key)

Remove attributes for composite keys and place into a new table for this composite key.(In 2NF and no Transitive Dependency)