"databased and sql$,$ I will thumbs you up if it helps thanks so much :)

please do not copy and paste the other answer with the same question, I want someone else to answer this since it is not what I am looking for and you are just wasting my questions, thanks I appreciate that.

PROJECT TOPIC: Library: Books, Copies of the books, Patrons, Checkouts

when creating ERD diagram, the notation must be in crows notation, attached at the bottom is an example of crows foot notation in databases so you can understand

any way to show diagram in crows foot notation containing the following information:

The name of the project

$3-4-$ sentences describing the problem $($Use the topic assigned to your name to define and describe the business situation$)$

List of the business rules $($make assumptions if degree of the relationship is not known$)$

ERD of the database $($please must be in crows notation also showing PK$,$ FK$1,$ FK$,$ etc..$)$

SQL Notebook in microsoft sql server mangement or azure data studio notebook sql code please

Code section with execution results

Commands to create all the tables

Commands populating $5-10$ records into each of the table

Select commands for each of the tables

create TABLE Movie$($movieID int primary key, movieName

varchar$(10),$ dateOfRelease date, budget int$)$;

$^^^$ sql code should run$/$look similar to bullet above :)

below is an example of crows foot notation with some other topic but please make sure you are doing the topic listed below...

please screenshot your outputs and post them as well I would really appreciate it I will definitely thumbs you up$!$

PROJECT TOPIC: Library: Books, Copies of the books, Patrons, Checkout

FIGURE $8\mathrm{.}1$ DATABASE MODEL HE generates INVOICE PK INV NUMBER FK$1$ CUS$\_$CODE INV$\_$DATE # contains CUSTOMER PK CUS CODE CUS$\_$LNAME CUS$\_$FNAME CUS INITIAL CUS AREACODE CUS$\_$PHONE CUS$\_$BALANCE $+$ LINE PK$,$FK$1$ INV$\_$NUMBER PK LINE$\_$NUMBER P$\_$CODE LINE$\_$UNITS XO$09$ LINE$\_$PRICE FK$2$ is found in $1$ VENDOR PKY$\_$CODE V$\_$NAME VANNTACT H$0-$ Supplies $-06$ PRODUCT PK P$\_$CODE P$\_$DESCRIPT P$\_$INDATE P$\_$QOH P$\_$MIN P$\_$PRICE P$\_$DISCOUNT FK$1$ V$\_$CODE V$\_$PHONE V$\_$STATE V$\_$ORDER"