with using the ER model, Relational model (RM) and SQL to designand query databases
1. Choose 3 (three) domains, cases, scenarios.
Be specific, choose a concrete company, business, enterprise,institution in each sector.
2. Create or design an ER model for each domain use case.
At least 15 entities per domain
At least 5 attributes per entity
Each entity should participate in at least 1 relationship
Focus on 2-way, binary relationships
3. Convert 2 (two) of your designs into Relational Models.
All entities into relations
All relationships into relations
Create manually the relational schemas
Create example, concrete relational tables
4. Implement the 2 RM designs using SQL technology:
MySQL, SQLite, MS SQL Server, (discouraged: MS
OR
OR