🎯 Learning Objectives
Developing Data & Data Representation learning strand, specifically:
- Know what is required in order to setup a database from scratch.
- Be able to setup a database independently with the purpose of storing student information.
💬 Key Vocabulary
- Database
- Table
- Field
- Record
📝 Starter Activity – Database Recap
- Download the Starter Worksheet below and fill in the blanks to recap what you have done in this topic.
📝 Creating your own database
- In today’s lesson you will use all of the skills you have learnt in this topic to create your own database from scratch, use validation rules, fill it with data, create a form and query it.
- Download the below worksheet to see what you need to do to get your badges.
- Use previous lessons here on Bourne to Code to help you with each stage.
📖 Keywords – Definitions
Database – collection of data or information that has been stored in an organised way.
Field – one type or one piece of information.
Record – all the data about a person or an object.
Table – collection of the database’s fields and records.
💬 Summary
In this lesson, you…
- Setup a database from scratch.
- Setup a database independently with the purpose of storing student information.
In this topic you…
- Investigated the key terms about databases.
- Imported data into a database.
- Created validation rules and dropdown boxes.
- Created forms to input and display data.
- Created your own database from scratch.
🏅 Badge it
🥈 Silver Badge
- You have completed 4 of the 7 tasks on your uploaded L6 Worksheet.
🥇 Gold Badge
- You have completed 6 of the 7 tasks on your uploaded L6 Worksheet.
🥉 Platinum Badge
- You have completed 7 of the 7 tasks on your uploaded L6 Worksheet.