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?
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.
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.
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.
-
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.
-
-
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.
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.
Reports
Reports give you the ability to present from any table or query in print, e.g. a print out of an invoice
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
-
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.
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
-
-
-
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
-
-
-
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.
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.