Question: Using PowerPoint or similar software, create a visual architectural layout of a relational database program that will track the receivables owed by your customers. The

 Using PowerPoint or similar software, create a visual architectural layout ofa relational database program that will track the receivables owed by yourcustomers. The layout must include: 1. At least two databases 2. Atleast one key field in each database 3. Lines connecting the key

Using PowerPoint or similar software, create a visual architectural layout of a relational database program that will track the receivables owed by your customers. The layout must include: 1. At least two databases 2. At least one key field in each database 3. Lines connecting the key fields between the data bases 4. A narrative describing the ways that the program will work (i.e., How will the program be used?) 5. A narrative describing the mechanics of creating an aging report. (i.e., From the fields in the databases, how will they be searched to print an aging report?) Example: Below is a visual architecture of a relational database. Customer Database Duta Transaction Database Field Name Field Name Data Key Key Field Field Yes Number Number Yes Customer ID First Name Middle Name Last Name Address 1 Address Number Teal Text Text Date Customer ID Apartment Date Payment Due Date Payment Received Play Made S/ Notes Text Numune Nunti TER Rent Database Data Sa Fie Name ty File Number Number Yes Telephone Date entered Credit limit Credit limit Dato Number Number Twi Date Date Number Date Apartment Database Narne Duta Customer ID Apartment Rent Type Rent Start Period Rent Amount Day of month Due Renewal Ticker Key Field Yes Number Number partment Target Rent Location Square Footage Style Number Number Text Number Text Creating an Accounts Receivable Aging Report The purpose of this project is to build your skills in finding the relationships that make data more meaningful. In this case, a business manager can determine the amounts owed by each customer and the length of time the amounts are outstanding; this helps with collecting cash, which a business needs to stay viable. First Step Envision the form and content of the report. The report will be as of a specific date (report-date), which is entered by the user. . The report will list customers who owe money (outstanding balance) The outstanding balances of invoices will be aged from the report-date The report will have columns where outstanding balances are listed by the length of time outstanding; column will be "

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!