170 likes | 295 Vues
This guide details the process of designing a Human-Zombie relational database system. It covers user requirement analysis, creating an Entity-Relationship Model (ERM) using ERDs, mapping entities like "Human" and "Zombie" to relational tables, converting the relational model (RM) to SQL, creating and populating tables, executing queries, and optional features like stored procedures, functions, and triggers. Finally, it addresses front-end integration and comprehensive documentation to ensure clarity and usability. Perfect for developers and database administrators.
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)