I received help and asnwers for question 1 and 2 and I have included those answe
ID: 3571577 • Letter: I
Question
I received help and asnwers for question 1 and 2 and I have included those answers in this post. Could someone help me with question 3, 4 and 5?
Hands-on practice in database design is important. Use a relational DBMS to implement the integrated REA data model presented in this chapter, or one of the integrated data models from the homework problems, or a model provided by your instructor.
Then, perform the following tasks:
1. Write a query to calculate total accounts receivable.
2. Write a query to calculate accounts receivable for a specific customer.
3. Create a sales invoice form that references the appropriate tables and inputs data about attributes into the proper tables.
4. Write queries to calculate as many financial statement items as possible from the data model you implement.
5. Design appropriate input controls to ensure the validity of data entered in the form created in step 3.
Answer : 1) Write a query to calculate total accounts receivable?
In the beginning, get the accounts receivable amount by adding all the attributes for the balance which are there in the table name called customer table.
The sales information for the new financial period has to be intended while adding all the sold quantity and multiplying them for getting the new sales in the inventory table where the inventory table is maintaining in many-to-many relationship.
The total amount of the cash receivable which are there in the customer table that can be planned by adding all the amount that are accessible in the received amount column in that respective table.
Total Accounts R = retrieved results from query A + retrieved results from query B – retrieved results from the query C
2) Write a query to calculate accounts receivable for a specific customer?
In the beginning, get the accounts receivable amount by adding all the attributes for the balance which are there in the table for keeping the records of all customers Select and retrieve only those rows in the table.
Selecting the new sales information for the new financial period has to be intended while adding all the sold quantity for the sold products that is having the invoice number which is fount by query “b” and it is in many-to-many relationships.
The total amount of the cash receivable which are there in the customer table that can be planned by adding all the amount that are accessible in the received cash tables that has a primary key for customer number and that is a foreign key in the respective customer table.
Total amount of Accounts R = retrieved results from query A + retrieved results from query C – retrieved results from the query D.
Explanation / Answer
3) two tables { sales and sales_inventory}
and refer to tables{ customer and inventory} for info like
{ billing and shipping address, description of product}
5) steps
a) to prevent duplicacy or null/fake primary key automatic generate the sales invoice
b) restriction on item_id
c) the product quality sold ad field prices sigature check
d) full check on customer info{billing ,shipping address}. the info should be checked automatic
accordingly.
e) full check on product details like{this should be shown by entering product id}
check on item info, price of item.......
f)check on the date when item is book, dispatched, and to reach at customer place.