Unit 17 - Lesson 3

Learning Outcomes

Week	Lesson Activity	Learning Assessment	Skill Developed
1.1	60 min As a team create the ERD or Class diagram for your e-commerce website 30 min Get your proposed design checked and signed off by your manager as being in third normal form 60 min Each member of the team needs to document user requirements for editing one entity as a use case with a full flow of events. 60 min Each member of the team needs to document user stories with example data validation. 120 min Each member of the team needs to create a example user interface for a form in HTML5 for editing one entity. This one uses Bootstrap for styling Web Page How to Style an HTML5 Form using CSS3 instead of Bootstrap 30 min Each member of the team needs to write notes on the effectiveness of the proposed design and to suggest improvements 30 min Each member of the team needs to ensure that they have documented their entities sufficiently to produce a data dictionary from Visual Paradigm. 30 min Add sample data to the ERD. Link the model to a SQL Server Database and create the database with sample data added.	Questions and Answers Data Design SQL Server DB HTML5 Form Notes	ERD Modelling Normalisation HTML5 Forms SQL Server

Week

Lesson Activity

Learning Assessment

Skill Developed

apply the database developmental cycle to a given data set

design a fully functional database (containing at least four inter-relational tables) including user interface

evaluate the effectiveness of the database solution and suggest methods of improvement

provide supporting user and technical documentation

1.1

60 min As a team create the ERD or Class diagram for your e-commerce website
30 min Get your proposed design checked and signed off by your manager as being in third normal form
60 min Each member of the team needs to document user requirements for editing one entity as a use case with a full flow of events.
60 min Each member of the team needs to document user stories with example data validation.
120 min Each member of the team needs to create a example user interface for a form in HTML5 for editing one entity. This one uses Bootstrap for styling
Web Page How to Style an HTML5 Form using CSS3 instead of Bootstrap
30 min Each member of the team needs to write notes on the effectiveness of the proposed design and to suggest improvements
30 min Each member of the team needs to ensure that they have documented their entities sufficiently to produce a data dictionary from Visual Paradigm.
30 min Add sample data to the ERD. Link the model to a SQL Server Database and create the database with sample data added.

Tutorial Keeping a Data Dictionary in Sync with ERD
Tutorial Writing Effective Use Cases
Tutorial 28 HTML5 Features, Tips, and Techniques you Must Know
Web Page Bootstrap 3 with Form Validation illustrates how to combine JavaScript with HTML5 form validation. I could not get this working, but sever websites have the same code.
Web Site Free Icons this is the site I used to obtain the icons used below.
Example

Using CSS3 to indicate simple validation
Example

Using CSS3 to indicate validation using icons