If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
I need help with my design Database Requirements.xls (01/01)
Hi, i am having some trouble decided how to design this database. I have attached an excel spreadsheet with all the requirements. So far this is
what i have come with: tblPerson -PersonId (PK) -LastName -FirstName -MiddleInitial -Title -DoB -Gender -MaritalStatus tblPersonRoleAddress -PersonRoleAddressID (autonumber pk) -PersonId (unique idx fld1) (FK - tblPerson) -PersonTypeId (unique idx fld2) (FK - tblPersonType) -Street -City -Province -PostalCode tblPersonType (going to be a lookup) -PersonTypeId (PK) -PersonType (determine whether they are a customer, doctor, business) tblClientDetail -PersonRoleAddressID (pk) (fk -tblPersonRoleAddress) -Occupation -Notes tblBusinessDetail -PersonRoleAddressID (pk) (fk -tblPersonRoleAddress) -Website -Description -Notes tbldoctorDetail -PersonRoleAddressID (pk fld1) (fk -tblPersonRoleAddress) -ClinicID (pk fld2) (FK - tblClinicDetail) I'm not to sure if this is correct so far, if anyone has a better suggestion on how to go about this, let me know. I was thinking of using a switchboard with 3 different types of contacts to enter into the database with fields unique to the type of role. Plus i have a multi select listbox that i have to do and don't know where to link that. If anyone can help, i would really appreciate it. Or even email me. Thanks in advance joe |
#2
|
|||
|
|||
Please do not post attachments. Would you accept an (unknown) attachment
from someone you don't know? Re-read the newsgroup protocols if you are unclear on why this is frowned on... -- Good luck Jeff Boyce Access MVP wrote in message news:z1ctd.449875$nl.144662@pd7tw3no... Hi, i am having some trouble decided how to design this database. I have attached an excel spreadsheet with all the requirements. So far this is what i have come with: tblPerson -PersonId (PK) -LastName -FirstName -MiddleInitial -Title -DoB -Gender -MaritalStatus tblPersonRoleAddress -PersonRoleAddressID (autonumber pk) -PersonId (unique idx fld1) (FK - tblPerson) -PersonTypeId (unique idx fld2) (FK - tblPersonType) -Street -City -Province -PostalCode tblPersonType (going to be a lookup) -PersonTypeId (PK) -PersonType (determine whether they are a customer, doctor, business) tblClientDetail -PersonRoleAddressID (pk) (fk -tblPersonRoleAddress) -Occupation -Notes tblBusinessDetail -PersonRoleAddressID (pk) (fk -tblPersonRoleAddress) -Website -Description -Notes tbldoctorDetail -PersonRoleAddressID (pk fld1) (fk -tblPersonRoleAddress) -ClinicID (pk fld2) (FK - tblClinicDetail) I'm not to sure if this is correct so far, if anyone has a better suggestion on how to go about this, let me know. I was thinking of using a switchboard with 3 different types of contacts to enter into the database with fields unique to the type of role. Plus i have a multi select listbox that i have to do and don't know where to link that. If anyone can help, i would really appreciate it. Or even email me. Thanks in advance joe |
#3
|
|||
|
|||
I agree with Jeff. You're not likely to get anyone to open your spreadsheet.
It would help very much if you would post a description of the real world problem you are trying to solve. A Database needs to model something in the real world and, while it appears that your database has something to do with the medical profession, I have no idea what you are trying to accomplish with the data you want to store. -- Lynn Trapp MS Access MVP www.ltcomputerdesigns.com Access Security: www.ltcomputerdesigns.com/Security.htm wrote in message news:z1ctd.449875$nl.144662@pd7tw3no... Hi, i am having some trouble decided how to design this database. I have attached an excel spreadsheet with all the requirements. So far this is what i have come with: tblPerson -PersonId (PK) -LastName -FirstName -MiddleInitial -Title -DoB -Gender -MaritalStatus tblPersonRoleAddress -PersonRoleAddressID (autonumber pk) -PersonId (unique idx fld1) (FK - tblPerson) -PersonTypeId (unique idx fld2) (FK - tblPersonType) -Street -City -Province -PostalCode tblPersonType (going to be a lookup) -PersonTypeId (PK) -PersonType (determine whether they are a customer, doctor, business) tblClientDetail -PersonRoleAddressID (pk) (fk -tblPersonRoleAddress) -Occupation -Notes tblBusinessDetail -PersonRoleAddressID (pk) (fk -tblPersonRoleAddress) -Website -Description -Notes tbldoctorDetail -PersonRoleAddressID (pk fld1) (fk -tblPersonRoleAddress) -ClinicID (pk fld2) (FK - tblClinicDetail) I'm not to sure if this is correct so far, if anyone has a better suggestion on how to go about this, let me know. I was thinking of using a switchboard with 3 different types of contacts to enter into the database with fields unique to the type of role. Plus i have a multi select listbox that i have to do and don't know where to link that. If anyone can help, i would really appreciate it. Or even email me. Thanks in advance joe |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Free Access Training | Timboo | New Users | 8 | August 17th, 2005 05:58 PM |
Incident Report Database Design | Jon Davidson | Database Design | 2 | August 10th, 2004 01:23 PM |
You do not have exclusive access... ERROR | Robin | General Discussion | 1 | July 6th, 2004 01:18 AM |
database design basic help | als0107 | Database Design | 3 | May 6th, 2004 07:26 PM |