The Return on all Ords Data:

Date	30-Day Bill Rate	Rm	RAMP	RHVN	RSUN
Jan-13
Feb-13	0.0433	-2.8439	3.0075	27.0408	6.3208
Mar-13	0.0375	0.1029	-4.9270	9.6385	7.1231
Apr-13	0.0300	3.7953	6.0890	9.8901	9.8139
May-13	0.0233	-4.9121	-4.0741	-14.9717	-3.9291
Jun-13	0.0250	-2.8383	-17.9537	1.5937	-4.4106
Jul-13	0.0192	5.4486	6.3529	4.3138	7.5503
Aug-13	0.0200	1.7257	4.8673	13.1579	-3.8222
Sep-13	0.0283	5.8115	-2.7426	5.6478	7.6789
Oct-13	0.0317	-1.9556	5.3765	2.5158	2.3719
Nov-13	0.0342	0.7301	-1.6878	0.4885	-1.4200
Dec-13	0.0483	-2.7648	-5.7939	-2.1672	-0.6823
Jan-14	0.0467	4.0403	-2.7335	-5.0633	-7.0229
Feb-14	0.0400	-0.2290	13.1147	7.0000	-0.3284
Mar-14	0.0527	1.6028	3.1056	2.8037	9.0031
Apr-14	0.0213	-2.4173	3.8789	-0.6060	1.1655
May-14	0.0183	2.1636	4.7525	-0.6211	2.5346
Jun-14	0.0308	-1.6555	0.1890	-3.1250	1.4232
Jul-14	0.0317	4.4759	3.5849	-0.3225	5.5391
Aug-14	0.0333	0.0267	7.1038	14.8867	0.9797
Sep-14	0.0375	-2.1264	-7.1429	2.2535	-0.7515
Oct-14	0.0300	-3.7584	9.4781	4.6832	4.3447
Nov-14	0.0292	1.7138	-3.5898	0.6470	-2.1160
Dec-14	0.0325	3.0210	-2.4823	-8.9431	-1.9526
Jan-15	0.0283	6.2467	4.9091	22.3163	4.6942
Feb-15	0.0317	-0.6205	16.1178	11.8987	-5.0272
Mar-15	0.0342	-1.5012	-3.8806	0.6787	-0.8638
Apr-15	0.0483	-1.2660	2.0721	-1.1236	-2.8518
May-15	0.0467	1.2998	3.4162	9.0696	3.1643
Jun-15	0.0400	-5.6053	-9.6096	-4.0425	-0.7391
Jul-15	0.0527	4.2284	9.8007	-1.1086	6.2546
Aug-15	0.0213	-8.0821	-9.9849	-2.6906	-10.0911
Sep-15	0.0417	1.2657	-6.5546	-10.5991	-4.1876
Oct-15	0.0500	-1.3312	5.5409	2.5773	7.5471
Nov-15	0.0592	2.4223	1.3962	5.3107	2.1358
Dec-15	0.0572	-5.3886	0.3442	2.4510	-9.3353
Jan-16	0.0572	-2.1497	-7.8902	6.2201	-4.3657
Feb-16	0.0544	4.1209	-0.9311	7.6577	-3.5314
Mar-16	0.0367	1.0909	8.8346	-1.6736	9.2004
Apr-16	0.0183	2.0737	4.2991	-4.6809	4.9538
May-16	0.0117	2.4793	-4.0817	4.7592	3.8400
Jun-16	0.0253	-2.5221	-8.5106	1.0965	-6.1633
Jul-16	0.0417	6.2820	12.5969	4.9892	10.2627
Aug-16	0.0483	-2.0305	-9.4664	11.1570	-5.3611
Sep-16	0.0467	-0.0760	3.0368	-3.3458	-2.0025
Oct-16	0.0400	-0.4127	-13.4469	-2.8846	-1.1561
Nov-16	0.0527	4.6816	2.8446	-2.6906	4.4277
Dec-16	0.0213	-1.4653	7.2341	8.2105	8.1600
Jan-17	0.0350	1.5047	-0.7936	-2.7237	-3.6242
Feb-17	0.0213	2.4787	-2.4000	3.0000	1.8419
Mar-17	0.0183	0.0000	9.1558	-12.0388	2.0384
Apr-17	0.0308	0.7419	3.4749	-7.5055	4.4663
May-17	0.0317	-3.1324	-5.7835	-7.1281	0.2899
Jun-17	0.0333	0.0469	2.7722	1.3263	7.0809
Jul-17	0.0375	0.1718	3.8536	14.3979	-3.5763
Aug-17	0.0300	0.0416	-5.3803	-6.6361	-8.8173
Sep-17	0.0292	-0.0242	-2.5338	-4.9020	3.1977
Oct-17	0.0325	4.8711	2.8985	-2.5773	4.0613
Nov-17	0.0267	1.8345	2.8169	9.4524	5.5229
Dec-17	0.0283	-0.3373	1.5656	3.9900	-3.2798
Jan-18	0.0467	-0.4751	1.1560	8.3933	-1.4430
Feb-18	0.0542	-4.0606	0.7619	-11.2832	-0.7321
Mar-18	0.0525	0.0000	-3.0533	-7.9800	0.8501
Apr-18	0.0492	3.4538	-19.0381	-4.6071	5.0975
May-18	0.0458	0.8548	-3.4653	5.6818	-4.2083
Jun-18	0.0433	2.7141	-8.7180	-7.7778	8.6374
Jul-18	0.0508	0.7075	-4.4944	6.9277	2.6045
Aug-18	0.0492	1.4777	-1.7647	1.4084	3.4736
Sep-18	0.0500	-1.7813	-1.6400	-0.6451	-6.1652
Oct-18	0.0492	-8.9335	-22.5705	-9.3751	-3.1120
Nov-18	0.0492	-0.6940	-1.6194	4.2430	-4.9250
Dec-18	0.0508	3.9917	0.8230	0.0000	-5.1802
Jan-19	0.0492	5.3964	-7.7551	6.6455	2.7712
Feb-19	0.0317	0.0639	4.4248	6.8250	4.3914
Mar-19	0.0483	2.5025	-9.4828	11.6667	3.7251
Apr-19	0.0350	0.6310	8.0952	3.7313	-3.7010
May-19	0.0450	0.5094	-4.4053	2.8376	-1.2352
Jun-19	0.0475	3.1979	-2.3041	-2.1634	3.3768
Jul-19	0.0425	2.9749	-15.5660	7.8624	0.2969
Aug-19	0.0692	-2.9063	-5.3073	-0.2278	2.2206
Sep-19	0.0644	1.1152	7.6696	6.0053	1.8944
Oct-19	0.0558	2.5853	0.5479	-9.7130	-1.2854
Nov-19	0.0433	-2.0956	6.5395	10.4038	-0.5204
Dec-19	0.0375	2.5947	-2.0460	-5.3488	-3.1390
Jan-20	0.0300	2.0404	-4.6997	3.9312	-0.7716
Feb-20	0.0233	-8.5841	-8.2192	-12.2931	-11.8196
Mar-20	0.0250	-21.0799	-20.2985	-20.4852	-17.7839
Apr-20	0.0192	8.9534	7.1161	-5.7627	0.6572
May-20	0.0200	5.0110	13.9860	22.2037	0.4352
Jun-20	0.0283	2.0942	13.8036	8.5890	0.0000
Jul-20	0.0317	4.0758	-21.0242	6.9123	-7.3673
Aug-20	0.0342	-3.7881	4.4368	18.8172	8.7719
Sep-20	0.0500	2.0618	-14.7059	2.4887	-8.1864
Oct-20	0.0592	9.9279	25.4689	-1.9867	-2.8402
Nov-20	0.0572	1.6093	11.7647	7.8480	22.8989
Dec-20	0.0572	0.2963	-8.7720	1.7353	-3.4688
Jan-21	0.0544	1.0144	-4.8077	13.8593	3.4907
Feb-21	0.0367	1.1051	1.0101	-1.8727	-1.3889
Mar-21	0.0183	3.8961	-15.6667	9.3511	2.1215
Apr-21	0.0117	0.4087	-11.8577	-4.8289	6.1616
May-21	0.0253	1.1775	0.8968	0.9488	5.8040
Jun-21	0.0417	2.4073	0.0000	3.0075	-0.0899
Jul-21	0.0483	0.5893	-7.5555	3.4671	3.8704
Aug-21	0.0467	-1.0472	5.7692	-5.1146	8.1456
Sep-21	0.0400	1.1828	-10.0000	-6.5056	1.2750
Oct-21	0.0527	-0.6768	9.0909	-1.3916	-6.6879
Nov-21	0.0213	2.2643	-4.1666	5.3278	-7.6792
Dec-21	0.0350	-6.3267	-2.4154	-2.5641	2.3105
Jan-22	0.0450	0.9012	-13.3664	-0.6073	-0.2710
Feb-22	0.0475	4.4193	7.9999	6.9246	-2.4457
Mar-22	0.0425	1.7198	2.1164	1.9048	5.2623
Apr-22	0.0692	-0.8319	20.2073	-1.4064	3.0576
May-22	0.0644	-3.4901	-5.6034	-13.9489	-0.9599
Jun-22	0.0558	-9.5061	-12.7854	-15.2968	-3.2599
Jul-22	0.0433	6.3337	13.6125	11.5903	1.9126
Aug-22	0.0375	0.7290	7.3733	2.1739	-2.5916
Sep-22	0.0300	-7.5725	-6.0085	-4.4917	-6.6118
Oct-22	0.0233	12.0050	15.0685	2.9703	13.7587
Nov-22	0.0250	0.5614	7.9365	6.6612	4.4698
Dec-22	0.0192	2.1721	-3.3088	-2.8235	1.0067
Jan-23	0.0200	-3.0067	1.5209	8.2324	4.0698
Feb-23	0.0283	-1.0959	-22.4719	-13.8702	2.5539
Mar-23	0.0317	1.7319	1.4493	-7.0130	-3.3061
Apr-23	0.0342	-1.9317	10.7708	4.4895	3.0553
May-23	0.0544	-1.1229	-3.5242	-6.6482	6.5705
Jun-23	0.0367	1.7598	3.1963	3.2641	1.4286

Transcribed Image Text:

Make a semantic object model for a pizza order. The order will have a phone number which will uniquely identify it. It will also have an address to where the pizza is to be delivered (a group attribute). Finally, it will have one or more pizzas, another semantic object. Each pizza will have an order number that uniquely identifies it (distinct from the phone number of the order) and a size (small, medium, or large for example). In addition, each pizza will have a pepperoni attribute (no topping, one topping, double topping) as well as mushroom and sausage attributes (also no topping, one topping, double topping). Part 2. Draw an entity-relationship diagram to capture the above pizza order and pizza. Part 3. Convert either the above semantic object model or entity-relationship model into a relational model. Make a semantic object model for a pizza order. The order will have a phone number which will uniquely identify it. It will also have an address to where the pizza is to be delivered (a group attribute). Finally, it will have one or more pizzas, another semantic object. Each pizza will have an order number that uniquely identifies it (distinct from the phone number of the order) and a size (small, medium, or large for example). In addition, each pizza will have a pepperoni attribute (no topping, one topping, double topping) as well as mushroom and sausage attributes (also no topping, one topping, double topping). Part 2. Draw an entity-relationship diagram to capture the above pizza order and pizza. Part 3. Convert either the above semantic object model or entity-relationship model into a relational model.