This is what I have for 5 tables:

1

Renters
Renter ID	Renter_Name	Renter_Address	Renter_Zip Code	Renter_Phone
jbond	James Bond	5345 Wildwood Street	42365	316-678-3465
scook	Sophie Cook	725 Fanfai Road	12589	589-462-0978
skerney	Shane Kerney	4598 Sandy Lane	45963	177-253-4597
kminnie	Karen Minnie	239 Narrow Way Dr	78125	121-012-1534

2

Owners
Owner ID	Owner_Name	Owner_Address	Owner_Zip Code	Email	Owner Phone
jthomas	Jill Thomas	12 Kellogg Ave	83837	jthomas@gmail.com	617-243-4569
nsmith	Nora Smith	123 Broadway Dr	10005	nsmith@gmail.com	212-101-1234
jwhite	Jim White	205 Fairfield Road	60261	jimw@gmail.com	532-113-0948
bjames	Bran James	5 Maple Street	63108	james545@hotmail.com	314-678-3478

3

Boat Info
Owner ID	Boat ID	Boat_Name	Model	Year	Make	Length	Capacity
jthomas	1	Promise	Reefrunner	2015	Reflex	28 ft	8
nsmith	2	Titanic	Cobia 330	2020	Cobia	33 ft	10
nsmith	3	Whales	Bertram 510 Fisher	2018	Bertram	51 ft	15
jwhite	4	Shrimp	Pro Skiff 15 CC	2017	Mako	30 ft	9
bjames	5	Captain Hook	28 Surf	2012	Chaparral	28 ft	8
jthomas	6	Grand Turismo	Grand Trawler 62	2014	Micad	29 ft	9

4

Order Total
Renter ID	Boat ID	Rental Date	Rental Length	Sub total	Order Total
jbond	1	9/1/2022	7	$ 4,550.00	$ 11,550.00
jbond	2	9/1/2022	7	$ 7,000.00	$ 11,550.00
scook	3	9/1/2022	3	$ 2,400.00	$ 2,400.00
skerney	4	9/1/2022	7	$ 6,125.00	$ 6,125.00
scook	5	9/3/2022	5	$ 2,500.00	$ 2,500.00
kminnie	6	9/3/2022	3	$ 1,650.00	$ 3,600.00
kminnie	1	9/3/2022	3	$ 1,950.00	$ 3,600.00

5

Rental Price(per day)
Boat ID	Price per day
1	$ 650.00
2	$ 1,000.00
3	$ 800.00
4	$ 875.00
5	$ 500.00
6	$ 550.00

How would you separate this data into 5 different tables with primary key and foreign key and find relations between the tables with normalization?

Rental_Date	Renter_Name	Owner_Name	Boat_Name	Rental_Length (Days)	Price_Per_Day	Subtotal	Order_Total	Model	Year	Make	Length	Capacity	Owner_Address	Owner_Zip Code	Owner_Phone	Renter_Address	Renter_Zip Code	Renter_Phone
9/1/2022	James Bond	Jill Thomas	Promise	7	$ 650.00	$ 4,550.00	$ 11,550.00	Reefrunner	2015	Reflex	28 ft	8	12 Kellogg Ave; jthomas@gmail.com	83837	617-243-4569	5345 Wildwood Street	42365	316-678-3465
9/1/2022	James Bond	Nora Smith	Titanic	7	$ 1,000.00	$ 7,000.00	$ 11,550.00	Cobia 330	2020	Cobia	33 ft	10	123 Broadway Dr; nsmith@gmail.com	10005	212-101-1234	5345 Wildwood Street	42365	316-678-3465
9/1/2022	Sophie Cook	Nora Smith	Whales	3	$ 800.00	$ 2,400.00	$ 2,400.00	Bertram 510 Fisher	2018	Bertram	51 ft	15	123 Broadway Dr; nsmith@gmail.com	10005	212-101-1234	725 Fanfai Road	12589	589-462-0978
9/1/2022	Shane Kerney	Jim White	Shrimp	7	$ 875.00	$ 6,125.00	$ 6,125.00	Pro Skiff 15 CC	2017	Mako	30 ft	9	205 Fairfield Road; jimw@gmail.com	60261	532-113-0948	4598 Sandy Lane	45963	177-253-4597
9/3/2022	Sophie Cook	Bran James	Captain Hook	5	$ 500.00	$ 2,500.00	$ 2,500.00	28 Surf	2012	Chaparral	28 ft	8	5 Maple Street; james545@hotmail.com	63108	314-678-3478	725 Fanfai Road	12589	589-462-0978
9/3/2022	Karen Minnie	Jill Thomas	Grand Turismo	3	$ 550.00	$ 1,650.00	$ 3,600.00	Grand Trawler 62	2014	Micad	29 ft	9	12 Kellogg Ave; jthomas@gmail.com	83837	617-243-4569	239 Narrow Way Dr	78125	121-012-1534
9/3/2022	Karen Minnie	Jill Thomas	Promise	3	$ 650.00	$ 1,950.00	$ 3,600.00	Reefrunner	2015	Reflex	28 ft	8	12 Kellogg Ave; jthomas@gmail.com	83837	617-243-4569	239 Narrow Way Dr	78125	121-012-1534