地理选举信息系统数据库设计 [英] Database Design For Geo Electoral Information System

问题描述

这是我的地理选举信息系统的数据库设计。在这个系统中



候选人注册并创建他的个人资料，然后订阅包裹计划。

候选人可以设置他的帐户他的盟友/助理。

然后候选人选择目标选区并发布文字通知，事件，视频等等。

另一方面，选民属于该选区能够通过Gis系统搜索他们的候选人，然后关注他们的候选人并获得他们的通知，视频和活动新闻。



请查看图表并建议是否我犯了一些错误，或者是否可以进行更多修改。



点击这里数据库设计

This is my database design for a geo electoral information system. In this system

The candidate signs up and creates his profile, then subscribes to a package plan.
The candidate can set up his account his allies/assistant.
Then a candidate selects the target constituency and posts the textual notification, events, videos and much more.
On the other hand voters belong to that constituency are able to search their candidate via Gis system and then follow their candidate and gets their notification, videos and event news.

Please have a look at the diagram and suggest if I had made some mistake or if more modification can be done for the improvement.

Click Here For database design

推荐答案

这是完美的数据库设计，但下面是几个使数据库架构更多的建议可靠



1）加在tblCity表中DistId并在TblCity和TblDistrict之间创建引用键

2）从TblAppUserDetails中删除City列并添加CityId

3）在TblCity之间创建引用和TblAppUserDetails

4）对所有具有城市栏的表格重复步骤2,3



希望这有助于

This is perfect database design,But below are the few suggestion to make the database architecture more reliable

1) Add "DistId" in tblCity table and create reference key between TblCity and TblDistrict
2) Remove "City" column from TblAppUserDetails and add "CityId"
3) Create reference between TblCity and TblAppUserDetails
4) Repeat STEP 2,3 for all the tables which have "City" column

Hope this helps

这篇关于地理选举信息系统数据库设计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！