Part 2 Problem Solving Questions: M & M Enterprise would like to build a database for their accounting system. Currently, they run a file-based manual system for their accounting payable. After a series of interviews, our data modelers found the 6 ledgers listed below

Vendor

Vendor Number	Name	Address	Other
44	Danby	1122 Main St.
55	Milo	591 Assembly St.
66	Dobbs	9611 Marion Dr.
77	Aarfy	222 Horseshoe Rd.
88	Daneera	1901 University Ave.
99	McWatt	888 Riverbend Cir.

Purchases

Purchase Number	Amount	Vendor Number	Other
1	6183	66
2	4756	44
3	2329	66
4	9842	55
5	3158	44
6	8378	66

Services

Service Number	Amount	Type	Vendor #
1	225	Advertising	77
2	275	Advertising	77
3	2020	Cleaning	88
4	181	Transportation	55
5	862	Advertising	99
6	313	Transportation	55
7	310	Advertising	77
8	2020	Cleaning	88

Cash-Disbursement

Check Number	Amount	Other
100	1010
101	6183
102	1010
103	2329
104	9842
105	810
106	1010
107	8378
108	181

Purchase-Payment

Purchase Number	Check Number
1	101
3	103
4	104
6	107

Service-Payment

Service Number	Check Number
3	100
3	102
1	105
2	105
7	105
8	106
4	108

2-1) After review the ledgers carefully, answer the following questions for M & M Enterprises.

1. How much inventory did M & M buy from Dobbs last month?
2. Did any vendors sell M & M both inventory and services?
3. To whom was check #101 sent?
4. How much does M & M owe in accounts payable?

2-2) Draw a Data Model in Tables for the M & M Enterprises as the given system. Next, if you can improve their data structure for the future database system, please draw an improved Data Model for the M & M Enterprises.