Two important steps for Database Design are :
Customer places orders to buy products
Entities are nouns. So , we can find entities in above business statement are all bold items i.e. Customer , Order and Product.
Entities may map to one table or may be to more tables.
Second aspect is business rule. Business rules example :
Applicant minimum age should be 18 years.
Credit Card no should be 16 digits.
So , one can define data integrity rules in database ( e.g. age should 18 and Credit card no should be 16 digits )
- Finding entities and relationships between them
- Finding business rules that define how data will be stored
Customer places orders to buy products
Entities are nouns. So , we can find entities in above business statement are all bold items i.e. Customer , Order and Product.
Entities may map to one table or may be to more tables.
Second aspect is business rule. Business rules example :
Applicant minimum age should be 18 years.
Credit Card no should be 16 digits.
So , one can define data integrity rules in database ( e.g. age should 18 and Credit card no should be 16 digits )
Add some good articles
ReplyDeleteWe will add new articles on Database Design. Also request you to go through some articles in Sql and oracle and provide your feedback.
ReplyDelete