Thread: Normalization
View Single Post
  #1  
Old March 12th, 2010, 08:53 AM posted to microsoft.public.access.tablesdbdesign
sys_analyst47 via AccessMonster.com
external usenet poster
 
Posts: 11
Default Normalization

Hi,
I am developing a inter dept application which will help us out to track the
auto loan application receiving, status of application, daily activity of
staff & few more things beside that. The problem which i am facing to design
tables is this I have a contract which needs to be issue to customer if the
loan has approved which is based on 36 fields which are as under just suggest
me is there any way to split this ?? if i will split this in different tables
I have to setup a mail merge with Word So will i be able to do that??

Customer identification
Customer name Branch
Sales officer
Local purchase order date
Vendor
Vendor address
Brand
Model
Year of Make
Color
Chassis no
Engine no
Original cost
Insurance cost
Total cost Down payment
Total deferred payment
1st installment date
Last installment date
1st installment amount
Last installment amount
Place of registration
Vehicle owner name
Passport no
Debt account
Commission amount in no
Commission amount in words

this is my customer table from where i generate contract.
The idea a customer record is entered there should be no redundancy. Please
don't forger that I have to issue contracts by mail merge. Or is there any
way to design report for contracts. it contains 12 pages for one customer.
can we design such a report???

--
Thanks & Regards
Majid Pervaiz
Operations Analyst
Al Hilal Bank, Abu Dhabi, UAE

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201003/1