The following information has been recorded in an interview for a Project Supervision System: One supervisor...
Fantastic news! We've Found the answer you've been seeking!
Question:
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)
Expert Answer:
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
Related Book For
Posted Date:
Students also viewed these computer network questions
-
The following information has been collected regarding Burton Dee Company: Free cash flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
The following information has been obtained from Sardy Corp.s 2009 income statement and beginning and ending 2009 balance sheets. Required: Prepare the operating activities section of a statement of...
-
The following information has been obtained from Sardy Corp.s 2009 income statement and beginning and ending 2009 balance sheets. Required: Prepare the operating activities section of a statement of...
-
What does it mean that flame is non-luminous it is yellow it is invisible It has a very bright blue inner cone it is dark
-
Consider a simple ideal Brayton cycle with air as the working fluid. The pressure ratio of the cycle is 6, and the minimum and maximum temperatures are 300 and 1300 K, respectively. Now the pressure...
-
In a city of 140,000 people there are 40,000 Norwegians. What is the probability that a randomly selected person from the city will be Norwegian?
-
Express the stress-strain relationships in Equation 2.37 in terms of offaxis engineering constants such as the moduli of elasticity, shear modulus, Poisson's ratios, and shear-coupling ratios. 3 Ex...
-
A consulting firm specializing in agriculture determines that the following combinations of hay and grain consumption per lamb will result in a 25- pound gain for a lamb: a. The firm's president...
-
Consider the vector field F(x, y, z) = (5z+4y)i+ (z+4x)j+(y+5x)k. a) Find a function f such that F = f and f(0,0,0) = 0. f(x, y, z) = b) Suppose C is any curve from (0, 0, 0) to (1, 1, 1). Use part...
-
The Hokies Lunch Group PART A Fatma settled down for lunch at the Yank Sing Chinese restaurant. She was early and took the time to catch up on her e-mail. Soon she would be joined by Jasper and...
-
define what globalization is and list the types of globalization Explain the factors or drivers of globalization Discuss the benefits of globalization for companies and the economy in general. How...
-
___________ refers to the ability to control another persons behavior with negative reinforcement.
-
___________ is the process of mentally rehearsing what you will say during a discussion.
-
What artifacts, rituals, language/jargon, and narratives/stories have you observed in your workplace?
-
____________ occurs when some, but not all, of the information is passed on to the supervisor.
-
Compute and interpret the financial ratios covered.
-
Select three accounts that you feel are important when analyzing and making decisions for a business. (At least one must have an unfavorable variance.) Look for trends and use your imagination to...
-
Find the center of mass of a thin triangular plate bounded by the y-axis and the lines y = x and y = 2 - x if (x, y) = 6x + 3y + 3.
-
Why might the buttons used to make a shirt not be classied as a direct material? Give an instance in which buttons would be classied as a direct material.
-
What is a cash equivalent? Why are cash equivalents combined with cash on a balance sheet?
-
Why do changes in most current asset and current liability accounts affect the operating activities of a rm?
-
Has the U.S. economy experienced inflation or deflation during recent recessions? Explain.
-
Inflation is soaring and employment is beginning to show sustained improvement. The unemployment rate is 6 percent, compared to its 3.5 percent rate prepandemic. The CPI grew 5.4 percent in June, and...
-
How do you think recessions influence elections?
Study smarter with the SolutionInn App