This post has been de-listed
It is no longer included in search results and normal feeds (front page, hot posts, subreddit posts, etc). It remains visible only via the author's post history.
We work in a non-profit research centre to find new genes, diseases and find new medication. since we have a lot of samples and data and everyone has their own way of storing them that creates an issue for us later. So I decided to create a database for our use however I still feel confused on how to organize it. so if anyone can help me that would be really awesome. here is the list of things we need in the database.
First Name Last Name Age Gender Marital Status Location Contact Number FamilyID MRN Mode Of Inheratense Disease StatusOfSubject FamilyID FamilycNumber Number Of Affected Members Pedigree Age of disease onset
SampleID
Location
GenePanel
WGA (Whole Genome Amplification)
CRP Labeling
Genetics Labeling
InHouseExom
Outsourced exom
Case Solved (Yes\No)
ExomID
ExomNumber
Spreadsheet of exom
Variant (Nucleotide Change ,Amino Acid Change)
Nucleotide Change
Amino Acid Change
Name of the Gene
NewGene (Yes\No)
Mode of inheritance (Dominant\recessive\X-linked)
Cardiac Ultrasound
Other Medical condition
Referral Physcian
Followed by
Subreddit
Post Details
- Posted
- 7 years ago
- Reddit URL
- View post on reddit.com
- External URL
- reddit.com/r/MSAccess/co...