Database Design- Creating Context and Physical ERD Using SQL Power Architect & generating SQL Code
Database Design- Creating Context and Physical ERD Using SQL Power Architect & generating SQL Code
This is a simple content which is created for beginners to understand.
This video contains
After getting a Use Case Narrative:
1. How to generate Context /Conceptual Model using SQL Power Architect
Identify entities
Identify relationship with cardinalities
In the relationships: You need to know whether it is an identifying one or non-identifying one
2. How to generate Physical ERD or a Fully attributed model with Data type and size of each attributes.
In this try to resolve the M:N issues
Identify the Attributes, Keys and Constraints
Identify the Data type and Size
3. How to generate and create code from Design Tool for development purposes!
Credits: Internet resources and University level materials ( Thanks to Bahrain Polytechnic, I have used a few slides and a few from their content ,Thanks a lot and this video is not for monetary benefits).
Credits: https://www.polytechnic.bh/admission/...
If you have any doubts, you may reach out to me @[email protected]
Happy Learning!