search

waidyanatha / nirogilk

Nirogi Lanka Non Communicable Disease Health Information System
0 stars 0 forks source link

database draft #2

Open waidyanatha opened 10 years ago

waidyanatha commented 10 years ago

re design "nirogilanka" database 1) develop ERD with workbench 2) re-label attributes (all lower case) with meaningful names 3) create database in spoton.lk/mysqld

Include ERD in SRS

waidyanatha commented 10 years ago

nirogilanka_erd_v0 3

overall very good job on normalizing the database, nice start :+1:

a few changes ...

gihanrt commented 10 years ago

nirogi lanka database version 4

On Mon, Sep 23, 2013 at 5:44 AM, Nuwan Waidyanatha <notifications@github.com

wrote:

[image: nirogilanka_erd_v0 3]https://f.cloud.github.com/assets/543943/1191281/b28635f4-244d-11e3-8b52-c0bbd50f3d48.png

overall very good job on normalizing the database, nice start [image: :+1:]

a few changes ...

-

change all attribute names to lower case and also reduce the names if you possible

we don't need the other_diseases table. We should be able to implement that using the disease and disease_parameter tables; which is more normalized

we also don't need the users table because we will implement user login and authentication using LDAP

submit mwb version 4 after you make these changes ( will email the edited mwb file)

— Reply to this email directly or view it on GitHubhttps://github.com/waidyanatha/nirogilk/issues/2#issuecomment-24916888 .

waidyanatha commented 10 years ago

Starting to look better, still some inconsistencies with upper case and lower case.

First include the person and house tables (only) in the nirogilanka db on spoton.lk; the rest we can add one by one as and when you create the GUIs for them

remember to update the git code with a mysqldump file only for the nirogilanka database. you can call this file nirogilanbka.sql. Then when installing all we have to do is run that file. So make sure to update that file each time you make a change to the database

On Sat, Sep 28, 2013 at 10:25 AM, gihantharanga notifications@github.comwrote:

nirogi lanka database version 4

On Mon, Sep 23, 2013 at 5:44 AM, Nuwan Waidyanatha < notifications@github.com

wrote:

[image: nirogilanka_erd_v0 3]< https://f.cloud.github.com/assets/543943/1191281/b28635f4-244d-11e3-8b52-c0bbd50f3d48.png>

overall very good job on normalizing the database, nice start [image: :+1:]

a few changes ...

change all attribute names to lower case and also reduce the names if

you possible

we don't need the other_diseases table. We should be able to implement that using the disease and disease_parameter tables; which is more

normalized

we also don't need the users table because we will implement user

login and authentication using LDAP

submit mwb version 4 after you make these changes ( will email the edited mwb file)

— Reply to this email directly or view it on GitHub< https://github.com/waidyanatha/nirogilk/issues/2#issuecomment-24916888> .

— Reply to this email directly or view it on GitHubhttps://github.com/waidyanatha/nirogilk/issues/2#issuecomment-25289020 .