Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started