The invoice-printing program is depicted in the figure below. I'd like to search for invoices based on the buyer's full name ( Natural person/legal entity full name ) or the invoice date to find all invoices associated with those two situations. For example, if a user searches for a given person or date, they will obtain a list of invoices, each with an invoice number. In the future, I may need to search by invoice number , where each invoice number will only display one invoice. So, based on the previous description, I require an ERD similar to the one below. It is not necessary to determine the data type of each entity in order to answer the question; what is most important is the relationship between the tables based on my above explanation. I tried to create four tables, but I was unable to establish the necessary relationship between them. Click to download the database Thank you for your interest.

Designing an entity relationship diagram (ERD) for invoice printing software

Reza Jaferi 331

The invoice-printing program is depicted in the figure below. I'd like to search for invoices based on the buyer's full name (Natural person/legal entity full name) or the invoice date to find all invoices associated with those two situations. For example, if a user searches for a given person or date, they will obtain a list of invoices, each with an invoice number.

In the future, I may need to search by invoice number, where each invoice number will only display one invoice.

Invoice So, based on the previous description, I require an ERD similar to the one below.

enter image description here It is not necessary to determine the data type of each entity in order to answer the question; what is most important is the relationship between the tables based on my above explanation. I tried to create four tables, but I was unable to establish the necessary relationship between them.

Click to download the database

Thank you for your interest.

Alexei Stoyanovsky 3,416 Reputation points

2023-11-12T09:57:29.38+00:00

Well at least you rephrased your homework task a bit, that should count for something :-)
Reza Jaferi 331 Reputation points

2023-11-12T17:03:01.15+00:00

Well, don't consider the following sentence:

In the future, I may need to search by invoice number, where each invoice number will only display one invoice.

And then answer this question.

Share via

Designing an entity relationship diagram (ERD) for invoice printing software