Prior to completing the module below it is highly recommended that you familiarize yourself with the following learning material:
- Basic Database Normalization
- Practical Normalization
- More on Normalization
- Real World Normalization Perspective
- ActiveRecord Design Pattern
- Eloquent Model Conventions
- Entity-Relationship Model > Crows Foot Notation
- Create a new branch in your 'php-final' git repo called
architectureand commit all the work from this module there. - Following the Laravel conventions and patterns for database architectures, create an Entity Relationship Diagram (ERD) using Crow's Foot Notation to diagram the Entities and Relationships below.
- Use whatever attributes you think are necessary for each Entity. Be sure to include necessary "timestamp" attributes for each Entity to conform to the Laravel standard.
- Use whatever diagramming tool you like. You could even draw it and take a picture if you like, as long as the diagram is clear.
- belongs to: Company Type
- has and belongs to many: Users
- has many companies
- belongs to (0 or 1 Company)
- has many: Companies
- has and belongs to many: Companies
- has and belongs to many: User Types per company
- has one User: Status
- has many: Users
When you are done, push your code to GitHub. Please create a tag called v1.7 with a message of "ready for review". Be sure your tags are pushed to the remote repository and are visible in GitHub.
Create an issue titled Review Module 8 - Architecture and assign it to @generationtux-helmsmen.