ER_Relationships

[Genki_Tokyo]

I'm sorry if it's hard to understand because I'm translating the question from Japanese into English using translation software.

• I would like to manage the rental of mobile phones.
• Multiple units may be rented.
• I want to display "Phone1" and "Phone2" in "Table View"
  （Table_Shop、Table__Staff）
  

  Name_Shop	Phone1	Phone2
  ShopA	111-1111-1111	222-2222-2222

• I want to "TableView" with "Table_Phone_Lend"
  

  Phone_Number	Shop_Number	Staff_Number	Date_Lend	Date_Return
  111-1111-1111	ShopA		2023/1/1	2023/12/31
  333-3333-3333		StaffA	2023/1/1	2023/1/31

  
  

I created two relationship plans.

Which do you think is better, Plan A or Plan B?

 Thank you for your support.

[Tedhds4385]

have You got A Database or Spreadsheet Software you can create both of them
as Database you can use import from saved files to Database like
Spreadsheets choose View Options So you can create the Details in it like a
Spreadsheet key is Default in the Database as as you Type at the end it go
to a new Line 1 and Up and Other options fix it is to change the format and
Code for it to Work.

[Tedhds4385]

You need to create a Table 

Name |Address| Phones A| Phone B| 

1                          00-000-0000 For example A

2.                                             00-000-0000 B