170 likes | 288 Views
Step 1. User requirement collection and analysis. Step 2 ERM design using ERD. Lnam. Fnam. ID. Human. Human. become. Zombie. Lnam. Fnam. ID. Human. become. Lnam. Fnam. ID. Zombie. Step 3: mapping from EDM to RM. Human table. Zombie table. Step 4: RM to SQL. Create table ….
E N D
Step 1 • User requirement collection and analysis
Lnam Fnam ID Human
Human become Zombie
Lnam Fnam ID Human become Lnam Fnam ID Zombie
Step 4: RM to SQL • Create table ….
Step 5: populate tables • Insert …
Step 6: queries • Select …
Step 7: stored units • Sp • Sf • Trigger (optional)