Week 13: Design, Implement, Validate and Evaluate
Class Task and Information
- Lesson 01:
Lost due to student free day.
- Part 2: Create a Data Dictionary
- Data Dictionaries are used to outline the blueprints to a table structure. They are used it identify the field table name, the caption name (the name to show the user), the data type, primary and foreign keys amongst other crucial pieces of information.
- Below are a series of example data structures that can be used to represent the structure of a entity table.
- TASK A:
- Using a Spread Sheet (like Google Sheets), create a FLAT FILE Data Dictionary for a table called tblSeniorSchoolStudents.
- Place at the top of the columns the elements of the data dictionary like the field name, data type etc.
- Pair and Share your column heading with the person next to you.
- Enter in one field (like first_name) and make adjustments where appropriate.
- Task B:
- Add appropriate fields to record information about students at MFAC in the senior school.
- Some suggestions are (and not limited to):
- Pair and Share your field list with the people around you to see the variations in the data collection.
- Importing Data into your LAMP - USE METHOD 2
- There are several ways to import your database into your mySQL database LAMP. In today's lesson we will be investigating 2 processes to importing the databases:
- Tutorial Method 01: Importing into mySQL through the terminal console.
- Tutorial Method 02: The following is an example database that you can import into your LAMP web stack through phpMyAdmin:
- Sample Database to import:tbl_students <Right Click or Control+Click and Save >
- Task C: Interrogate the database using ATOM before importing
- Table Name
- Field Names
- Field Properties
- Data Types
- Sample Data sets
- Check the spelling of fields and random data.
- If there are errors you can find and replace using Atom to fix.
- Task D:
- Import the database into your LAMP Stack
- Check the database name.
- Brows the database for errors and structure.
- Ensure that the data types are correct.
- Lesson 02:
- Lesson outline Video <--- Lesson instructions
- Database Abstraction
QBE Example template for Student Information
- This lesson we will be reviewing fields that are used on websites to make them dynamic.
- How to construct a field name?
- student_firstName, student_first_name, first_name, fName, fname, f_name etc.
- What are the key features and requirements?
- The relationship between field names and entities:
- Entities (tables) and their fields.
- Task 03: Creating an outcome
- Using phpMyAdmin - In small groups Create the criteria for:
- Single Criteria - All students in Bradman
- Dual Criteria - All Student in Bradman with a XL shirt
- Multi Criteria - 3 or more fields
- Ask you working partner to create a query to find single, deal and multi criteria searches. e.g.:
- All students in Bradman that have allergies and dog as a pet.
- All Female student that have a bedtime after 8:30 at night.
- All students who live 5 minutes from the school.
- Query by Example using SQL structure
- The following allows you to design your query without having to deal with syntax and the nuances of the language. Developing you QBE in a spread sheet is the best option for developers and I would recommend using Google Sheets to help you generate your questions and answers.
- QBE grids (Query By Example) - Tutorial on QBE
- Example Blanks QBE with a TRD image.
- Example Solution:
Find All player that went to the camp with the post code of 4556 that are goal keepers.
- Note: place the question at the top of the TRD and then complete the grid
- Task 03: Working in small groups (no more than 3), create a query for your group members to resolve that uses:
- Single Criteria, Dual Criteria and Multi Criteria
- Grouping and Order by
MFAC Link QBE Template
Readings / Homework
- Complete all set work.
- Reminder that the test will be Wednesday Week 5 (6th of Nov) Lesson 2