Please enable JavaScript.
Coggle requires JavaScript to display documents.
GCSE Recap Videos (What is a database? (Persistence (
persistent…
GCSE Recap Videos
What is a database?
Persistence
persistent means that once the data has been put into the database it can be stored their and accessed again, for example if you sign up to get email updates from your favorite band you are now in their database.
A database is a persistent and organised store of data, persistent meaning that once the data has been put into the database it can be stored their and accessed again.
Forms
Forms are used for entering, modifying and viewing records
They are used so frequently as they are a easier way of guiding people into entering data correctly.
Steps to creating a form
-
-
-
in the navigation pane you will need to select the table that you want to use, and you don't need to open it just making sure it’s highlighted
Validation
A range check will check that a value typed in is within acceptable range of values, this one only really applies to numbers for instants the birthday with a wrong month e.g. 13 which does not exist as the month must be between 1-12. type check examines the data to see what data type it is for example integer, string or decimal.Lastly a format check, checks whether the data is in the desired format to do this we use an input mask to specify the format for example a postcode input mask might be LL00L00, where L means a letter must be typed and 0 means a number.
-
-
Entity
An entity is a category for storing data about a thing in the system. sometimes you might have multiple entities for example user and product
Reports
Reports give you the ability to present from any table or query in print, e.g. a print out of an invoice
Steps to create a query
-
-
If you click the view command then you can view the query in design view, by the end you should be viewing it in datasheet view
-
-
-
Queries
Queries give you a way to search for and compile data from one or more of your tables, running a query is like asking your database a detailed question.
-
-
-
Database in everyday use
we use databases everywhere in our day to day existence through our computers and phones and even a daily trip to the shops. checking what films are on in the cinema using your phone and updating your information on a social networking site requires a database.
Databases in action
One example includes waiting at the doctors office while the receptionist punches in your information, another example of a database in action includes asking a store employee to check their system for a special item.
An attribute describes the characteristics of an object. For example, in a database, fields are attributes, i.e. House_number is an attribute of an address or surname is an attribute of a person.
Databases can be accessed by lots of people at once from different devices using different types of software. For example i might use my phone to check social media while i'm out shopping, but when i get home i might access the same social network site on my computer, because i am still using the same information form the same database but the software i am using is different.