Database Development Process Assignment

Assignment Task

Project Description

This document contains the business requirements for the course project. As database specialists you are asked to generate a detailed database logical design and prototype an implementation that will support these requirements. You must document your design using the template provided to you in SAM (Term Project Completion/Submission). You must build your prototype database in MySQL/MariaDB. It is strongly recommended that you use XAMPP and phpMyAdmin to help you build your prototype database. The database must support the Input and Output requirements of the system as stated in the rest of this document (below). All database tables in your final design must be normalized to at least 3NF, and you are expected to conform to the DBDL standard notation. Final ERD and Cumulative View are to show cardinality.

Overview

IslandLand Distributors is a distributor that buys products from its vendors and sells these products to its customers. The Island Land Distributors operation is divided into territories. Each customer is represented by a single sales rep, who must be assigned to the territory in which the customer is located. Although each sales rep is assigned to a single territory, more than one sales rep can be assigned to the same territory.

When a customer places an order, the computer assigns the order the next available order number. The data entry clerk enters the customer number, the customer purchase order (PO) number, and the date. (Customers can place orders by submitting a purchase order, in which case, a PO number is recorded.) For each part that is ordered, the clerk enters the part number, quantity, and quoted price. (When it is time for the clerk to enter the quoted price, the computer displays the price from the master price list on the screen. If the quoted price is the same as the actual price, the clerk takes no special action. If not, the clerk enters the quoted price.)

When the clerk completes the order, the system prints the order acknowledgment / picking list form and sends it to the customer for confirmation and payment. When Island Land Distributors is ready to ship the customer’s order, this same form is used to “pick” the merchandise in the warehouse and to prepare it for delivery.

Island Land Distributors uses the balance-forward method. With the balance-forward method, customers have balances. When the system generates an invoice, the customer’s balance is increased by the amount of the invoice. When a customer makes a payment, the system decreases the customer’s balance by the payment amount

At the end of each month, the system updates and ages customers’ accounts. The system can tell what a customer owes that is over 90 days, 60 days, and 30 days. 

The system provides customer statements, an aged trial balance (described in the report requirements sections.), a monthly cash receipts journal, a monthly invoice register, and a sales rep commission report. The system then removes cash receipts and invoice summary records from the database and sets month-to-date (MTD) fields to zero. When the system processes the monthly data for December, it also sets the year-to-date (YTD) fields to zero.

This Data Science has been solved by our PhD Experts at My Uni Paper.