ideas about Database structure

  • (2 Pages)
  • +
  • 1
  • 2

26 Replies - 1240 Views - Last Post: 06 September 2016 - 03:16 PM

#16 pharaon  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 164
  • Joined: 18-October 07

Re: ideas about Database structure

Posted 06 September 2016 - 12:35 PM

ok now i got 3 tables
families(family_number, Family_address)
individuals(person_ID, family_Id, pname, roles, birthdate, quilification, job, tel, comments)
roles(roles) which will be husband, wife, son, daughter

now my application will have two options
1. add family
2 search families

so what would be the best way to add data to the two tables families, individuals with one step....i mean to fill the whole data in one forum in one step and add it to the tow tables
the application have to get the last family number from families(family_number) and the last person id from individuals(person_ID) so i can add he new number

what do you suggest
Was This Post Helpful? 0
  • +
  • -

#17 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13382
  • View blog
  • Posts: 53,409
  • Joined: 12-June 08

Re: ideas about Database structure

Posted 06 September 2016 - 12:45 PM

Use MS Access' "import data" functionality.
Was This Post Helpful? 0
  • +
  • -

#18 pharaon  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 164
  • Joined: 18-October 07

Re: ideas about Database structure

Posted 06 September 2016 - 12:47 PM

View Postmodi123_1, on 06 September 2016 - 07:45 PM, said:

Use MS Access' "import data" functionality.

import from where?
and what will be a good user interface?
bunch of text boxes or one data grid view?
or two data grid view for each table
Was This Post Helpful? 0
  • +
  • -

#19 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13382
  • View blog
  • Posts: 53,409
  • Joined: 12-June 08

Re: ideas about Database structure

Posted 06 September 2016 - 01:09 PM

I thought you had the data. If you don't then just make up the data.

It's your project you tell us what you think the UI should look like.
Was This Post Helpful? 0
  • +
  • -

#20 pharaon  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 164
  • Joined: 18-October 07

Re: ideas about Database structure

Posted 06 September 2016 - 01:15 PM

View Postmodi123_1, on 06 September 2016 - 08:09 PM, said:

I thought you had the data. If you don't then just make up the data.

It's your project you tell us what you think the UI should look like.

oh i don't have the data
i'm making it for some one who follow some area's families
so all he need is a program to add the family's data in his area
like if he have 20 families in his area and how many member for each family with their details

it wil be vb.net 2013 application

This post has been edited by pharaon: 06 September 2016 - 01:17 PM

Was This Post Helpful? 0
  • +
  • -

#21 pharaon  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 164
  • Joined: 18-October 07

Re: ideas about Database structure

Posted 06 September 2016 - 01:20 PM

can i make data grid view with only two editable rows that user can edit's their cells but can't add more rows?
Was This Post Helpful? 0
  • +
  • -

#22 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13382
  • View blog
  • Posts: 53,409
  • Joined: 12-June 08

Re: ideas about Database structure

Posted 06 September 2016 - 01:22 PM

Okay.. am I going to get paid for doing all your design work as well?

If not then stop and think about things. How have you seen applications input data? How have you seen applications display data?

If you are going to be tracking families well - you will need to review my past comment about having a relational table for a user id and a family id (and _not_ have a family id column in the user table).. A person can belong to one or more families through birth and marriage.

Quote

i'm making it for some one who follow some area's families

Well that just sounds creepy.

---
Yes, you can have the grid not have a 'new row' prompt.
Was This Post Helpful? 1
  • +
  • -

#23 pharaon  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 164
  • Joined: 18-October 07

Re: ideas about Database structure

Posted 06 September 2016 - 01:30 PM

i don't need to track families in that way

just husband, wife, kids
that's all i need
Was This Post Helpful? 0
  • +
  • -

#24 astonecipher  Icon User is offline

  • Too busy for this
  • member icon

Reputation: 2329
  • View blog
  • Posts: 9,356
  • Joined: 03-December 12

Re: ideas about Database structure

Posted 06 September 2016 - 01:36 PM

Quote

just husband, wife, kids
that's all i need


If this idea has ANY longevity, you have to think in a broader scale. What happens when the kids have kids?
Was This Post Helpful? 0
  • +
  • -

#25 pharaon  Icon User is offline

  • D.I.C Head

Reputation: 0
  • View blog
  • Posts: 164
  • Joined: 18-October 07

Re: ideas about Database structure

Posted 06 September 2016 - 02:54 PM

then will be new family and removed from their original family

that's what we need
Was This Post Helpful? 0
  • +
  • -

#26 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 13382
  • View blog
  • Posts: 53,409
  • Joined: 12-June 08

Re: ideas about Database structure

Posted 06 September 2016 - 02:58 PM

Ooookay. Well, go nuts.
Was This Post Helpful? 0
  • +
  • -

#27 astonecipher  Icon User is offline

  • Too busy for this
  • member icon

Reputation: 2329
  • View blog
  • Posts: 9,356
  • Joined: 03-December 12

Re: ideas about Database structure

Posted 06 September 2016 - 03:16 PM

Then your structure makes no sense. To about it however you want those requirements to be and suite it how you want. It I am documenting family members, I want to be able to trace lineage, oh wait I am working on a project just like that now!
Was This Post Helpful? 0
  • +
  • -

  • (2 Pages)
  • +
  • 1
  • 2