Continuing my SQL education, I have been working with PostgresSQL while taking online courses via Coursera. I have create some SQL statements using cube, rollup and grouping sets operators. See below: Cube ROLLUP: Grouping Sets: Partial Cube: Partial RollUP:
Category Archives: sql
Entity Relationship Diagram: Conversions
When you finish creating your Entity Relationship Diagram and made sure that there are no errors; you can then start converting to tables by using the conversion rules. See below. Entity Type Rule: Convert the Student, Loan, Institution, Lender and DisburseLine entity types into tables. 1-M Relationships rule for all relationships except Sent relationship. UseContinue reading “Entity Relationship Diagram: Conversions”
Notable 