The following information has been recorded in an interview for a Project Supervision System: One supervisor...

 

Transcribed Image Text:

The following information has been recorded in an interview for a Project Supervision System: One supervisor can supervise many students. The supervisor must supervise at least one student. Each student is allowed to select only one supervisor. Each student must handle at least one project. The student can handle more than one project. The project may have one or many students. Required: (i) Draw a basic Entity Relationship Diagram (ERD) for the above scenario using the Crow's Foot notation. You are required to resolve many-to-many relationships, if any. (9 marks) (ii) List the relevant attributes for Supervisor and Student entities using Database Design Language (DBDL) format, Underline all primary keys and use an * to indicate a foreign key. You should use the format in the following example: PRODUCT (Product ID, Description, Category, Supplier_ID*). (4 marks) b) The HBC Bank granted loan for their customers based on the following conditions: If a customer has an account with the bank and has no outstanding loan, the loan application will be accepted. If a customer has an account with the bank and still has outstanding loan, the loan application will be accepted provided if the customer obtained the approval from the management. Otherwise, the loan application will be rejected. The loan application will be rejected in all other circumstances. Construct a simplified decision table based on the above scenario. (8 marks) c) Explain TWO (2) advantages of a decision table over a decision tree. (4 marks) The following information has been recorded in an interview for a Project Supervision System: One supervisor can supervise many students. The supervisor must supervise at least one student. Each student is allowed to select only one supervisor. Each student must handle at least one project. The student can handle more than one project. The project may have one or many students. Required: (i) Draw a basic Entity Relationship Diagram (ERD) for the above scenario using the Crow's Foot notation. You are required to resolve many-to-many relationships, if any. (9 marks) (ii) List the relevant attributes for Supervisor and Student entities using Database Design Language (DBDL) format, Underline all primary keys and use an * to indicate a foreign key. You should use the format in the following example: PRODUCT (Product ID, Description, Category, Supplier_ID*). (4 marks) b) The HBC Bank granted loan for their customers based on the following conditions: If a customer has an account with the bank and has no outstanding loan, the loan application will be accepted. If a customer has an account with the bank and still has outstanding loan, the loan application will be accepted provided if the customer obtained the approval from the management. Otherwise, the loan application will be rejected. The loan application will be rejected in all other circumstances. Construct a simplified decision table based on the above scenario. (8 marks) c) Explain TWO (2) advantages of a decision table over a decision tree. (4 marks)

Answer rating: 100% (QA)

DECISION TABLE FOR LOAN APPROVAL SNO Decision Table Decision Tree 01 A Decision table is a table of ... View the full answer