I am designing a new system but am not sure what fields to link up in relationships. i have the following tables in my system
*AUTHORISE (base no, power, engagement)
*BASE (base no/acc no/customer name)
*Process verbal date (Base no./process verbal date/date 1/date2/date3../date 6
*Several accounts (base no;/Account no 1.../account no 6
*Single account (base no, account number)
* Source table (base no/id card/expiry date /comments)
*statut verbal date (base no./statut verbal date/comments)
Base number is the primary key as its unique each time. can u please tell me whether tables are normalised n wat fields to link in relationships)
*AUTHORISE (base no, power, engagement)
*BASE (base no/acc no/customer name)
*Process verbal date (Base no./process verbal date/date 1/date2/date3../date 6
*Several accounts (base no;/Account no 1.../account no 6
*Single account (base no, account number)
* Source table (base no/id card/expiry date /comments)
*statut verbal date (base no./statut verbal date/comments)
Base number is the primary key as its unique each time. can u please tell me whether tables are normalised n wat fields to link in relationships)
