Twitter. Some people love it. Some people hate it! What most people don't realise is that Twitter is just a great big ugly database with a beautiful user interface.

Look at the tweets above. Each tweet has:

• the name of the user
• the Twitter handle of the user
• an avatar
• some tweet text
• some content eg an image, gif or video
• the date of the tweet

But where is all of this data coming from?

Description

This is a database table.

It has 8 records of data.

Each record has 5 fields.

One of the fields has alphanumeric datatype.

One of the fields has numeric datatype.

One of the fields has date datatype.

   Skill-up 1 - Importing data

Let's import a basic data file into a powerful database application. Watch this video if you need help.

data file

Be smart! Download the file and save it in a new project folder. Don't leave it in the downloads folder of your computer. You are not a newbie!

    Challenge 1 - Editing the table

Can you delete all Johnny Depp movies from database. Hint: there are 16 records storing Johnny Depp movie info:

    Challenge 2 - Entering data

Search for your favourite movie. Is it in the database? If not, do some research and add it.

Ask someone near you for about theirs. Is it in the database? If not add it.

If your favourite movies are already in the database table, do some research and add 2 new ones. Remember to research the imdb score - don't just make it up!

You should be left with 983 records of data!

   Evidence

Create an evidence document eg a Google Doc. Paste a screenshot of your table in Design View into your document. Write 3 things that you now know about databases.