Database Design Example Phase 2: Design
This article follows on from Database Design Example Phase 1: Analysis.
Based on the provided information, you can begin your logical design and should be able to identify the initial entities:
- Poet
- Poem
- Publication
- Sale
- Customer
The Poet's Circle is not an entity, or even of instance an a publisher entity. Only if the system were developed for many publishers would publisher be a valid entity.
Neither website nor poetry community are entities. There is only one website, and anyway, a website is merely a means of producing data to populate the database. There is also only one poetry community as far as this system is concerned, and there is not much you'd want to store about it.
Next, you need to determine the relationship between these entities. You can identify the following: