Part l: Understanding Accounting Relational Database Quick Jolt Electronics manufacturers and sells specialized electronic components to customers across the country. The following tables illustrates some of the records in its accounting databases. For example, the ""Sales by Inventory number" records show detailed sales data for each of the company's inventory items, and the "Customer Payments" records indicate customer cash payments. Listed by invoice number. Use the information provided in these tables to answer the following questions Sales bv Inventorv Number Item Invoice QuantityPrice Each Number Number S2,000 $2,000 S1,575 S 3,000 S3,500 $1,000 600 S 300 $4,000 S 3,000 S5,000 S5,000 S5,000 S5,000 V-1 V-3 V-6 V-5 V-6 V-3 V-1 V-5 V-3 V-7 V-2 V-4 V-5 V-7 I-4 I-6 Sales bv Invoice Number InvoiceAmountCustomer Date Salesperson Number V-1 V-2 V-3 V-4 V-5 V-6 V-7 Number C-1 C-2 C-5 Number S-12 S-10 S-10 S-10 S-10 S-10 S-11 S 7,200 S 10,000 S 16,000 S 10,000 C-2 S 16,600 S 35,000 C- S23,000 July 1 July 12 July 22 July 26 July 31 August 1 August 2 C-5 C-4 Sales by Sa spersonQuarterlyCommission Number Sales Customer Payments Amount tance nvoice Number Advise Numbar Customer Data stomer Name Accounts stomer Number sperson Receivabe Number Amount Ghymn and Sons D. L r the follow 1) What is the total amount of sales on Invoice V-3? What was the name of customer thatmade that purchase? What items did this customer purchase and their quantities in purchase? that invoice? What are the prices for each item in that 2) Customers can choose among one of three payment options 5% discount if immediate cash payment. b) a) 2%discount offlist amount iftotal invoice paid bythe 15 day ofthe month following purchase c) Deferred payment plan, using 6 monthly payment 3) Which option does J.P Carpenter appear to be using in invoice V-27 4) What are the quarterly sales amount for salespeople S-10, S-11, and S-127 5) Assume that customers C-1 through C-5 began this quarter with net accounts receivable balances of zeros, what are their balances now? Part2: Designing Database and enforcing data referential integrity North Beach College was founded as a small, liberal arts school just three years ago Since that time, the institution has grown to the point where parking on campus is difficult and parking in illegal areas is common Accordingly, the board of directors has reluctantly approved a policy requiring campus police to issue parking tickets Currently, the college requires students and faculty to register their cars, with parking office, which issues them parking decals that registrants must display inside the front windshield of their cars. At present, all records keeping at the parking office is done manually, severely limiting the ability of office personnel to create reports or perform meaningful statistical analyses about parking on campus. For example, it is currently not known how many students of each class (freshmen, senior, etc.) register their cars or howmany full-time faculty.part-time faculty, or staff registertheir cars. The newpolicy of writingparkingtickets will only add to this problembecause it required office staff to match parkingtickets to students andfaculty names. In addition, the Board of Directors would like an end-of-semesterreport indication how many parking violations of each type (meter violation, invalid parking sticker, etc.) are issued by the campus police. To solve theseproblems, yourealize that adatabase system mightwork 1) Propose a database ER-diagram for the newdatabasesystem. Your model should illustrates database entities, attributes, relationships between entities that show maximum and minimum cardinalities, and therecord structure foreach entity. A record structure example is shown below. What primary keysyouwilluse for each entity? Would you enforce validation rules in your proposed database?List at least four validations rules for some ofthe tables' fields alongwith the textmessage that will displayed to the database users 2) 3) Table Name Customer Table Customer Data Field Name Data T ort Text stomer First Name Short Text Customer LastName Short Text Short Text Short Text Short Text Short Text Short Text Phone Number Address tv tate Example of Record Structure