السلام عليكم ورحمة الله وبركاته
كل عام وأنتم بخير
وأسأل الله أن يتقبل منا ومنكم رمضان
مطلوب مني تحويل المستلزمات إلى E-R digrams
وهذا كان شوي صعب
أتمنى منكم مساعدتي
السؤال الأول
2. Each client identified by a client number (CLIENTNO) who applies for a loan is assigned to one
bank loan manager identified by employee number (EMPNO). Each bank loan manager may have
many clients. The bank loan manager assists the client to complete a loan application identified by
a unique application number (APPNO). Each loan application must have a single client who is a
primary applicant, and may have one or more clients who are secondary applicants. The loan
amount (LOANAMT), date of the application (APPDATE), income (INCOME) and expenses
(EXPENSES) of the primary applicant are recorded on the application. Each application must have
at least one (but may have several) guarantors, who must also be clients of the bank. The total
assets (TOTALASSETS) are recorded for each guarantor. Clients who are applicants (primary or
secondary) on one application may be guarantors on another application, and vice versa. But the
same client cannot be both applicant and guarantor on one application. The following information
requirements have been identified during analysis:
CLIENTNO client number
CLIENTNAME client name
CLIENTADDRESS client address
EMPNO bank loan manager employee number
EMPNAME bank loan manager employee name
APPLNO loan application number
APPDATE date of application
LOANAMT loan amount
INCOME income of the primary applicant
EXPENSES expenses of the primary applicant
TOTALASSETS total assets of a guarantor