Answered: (a) Late deliveries of material by…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

You are required to suggest and prepare the following database tables to match the above process activities so as to generate the two reports as per respective formats

(a) Late deliveries of material by suppliers (due date vs actual delivery date) as per format below:

ABC REAL DEVELOPERS LTD.

SUPPLIER WISE LATE DELIVERIES REPORT Date dd/mm/yy

sr no.	supplier code	supplierf name	supplier location	order no.	order date	material code	material discription	due delivery date	actual ielivery date

(b) Payment status of customers for residential projects (total amount, amount paid, date of payment, balance amount) as per format below:

ABC REAL DEVELOPERS LTD.

CUSTOMER WISE PAYMENT STATUS REPORT Date dd/mm/yy

Srl. No.	Customer Code	Customer Name	Customer Location	Project Name	Invoice Date	Amount Due	Payment Due Date	Actual Date of Payment	Balance Amount

The Project Manager of ABC Real Developers Ltd., Mr. Dev Kumar, has engaged you as a consultant to suggest a basic information system and the required database format to store the necessary data.