How do i relate these tables and also where do i have to put the primarykey or keys?

[Michael1926]

Good evening everyone!



So, the sheet asks me to create a database with 3 tables.

The name of the first table is Bank and has specific features like the codenumber of the bank, the location, phonenumbers and the numbers of employess.

The name of the second table is Stuff and also has specific features like name and lastname together in one field, number id, date of birth and if there are married (yes or no)

The sheet asks me to create a third table with the name Loans which include specific features as well. The third table accepts from the first table the codenumber and from the second table the numberid, also it has the field payoff, the field duration and the last field type of loan.

Hence, many to many relationship?, and if so, the primary keys are only on the first and second tables and the foreign keys are in the third table? Note that i didnt put any primary key in the third table

Sorry for the big text

[ssanfu]

This sounds like homework??

You are on the right track, although some things are not good programming practice. (No spaces on object names and first, fast Names should be in separate fields, do not use reserved words as object names ie "Name")

I have an autonumber in every table as the PK field.
For more about PK fields, see
Microsoft Access Tables: Primary Key Tips and Techniques
http://www.fmsinc.com/free/newtips/primarykey.asp


I guess you could call this a many-to-many relationship. To me, table "Loans" is the main data table.

Since you have given us the info, I would have:
tblBanks
-----------------------
BankID_PK - AUTONUMBER
CodeNumber- TEXT
Location - TEXT
PhoneNumbers - TEXT
NumOfEmployess - INTEGER


tblStuff (Staff??)
------------------------
StuffID_PK - AUTONUMBER
FirstName - TEXT
LastNamd - TEXT
NumberID - INTEGER
DateOfBirth - DATE
Married - YES/NO

tblLoans
-----------------------
LoanID_PK - AUTONUMBER
BankID_FK - NUMBER - link to tableBanks
StuffID_FK - NUMBER - link to tblStuff
Payoff - DATE
Duration - INTEGER (number of months??)
LoanType - TEXT

[orange]

Michael1926,

Please tell us a little about your post and the "sheet". As Steve said, it sounds like homework.

We don't do homework for you, but we will offer advice and info if you are putting in a honest effort.
Good luck.