Q$2(30$ pts$)$:

Author Possion iscontactAuthor?

$\backslash$table$[[$AUTHOR$],[$Authorid$],[$Auth Name $($tname$,$ Mname,$],[$Pname$)],[$Auth Phone$],[$Auth Email$]]$

orders

Seller

Seller Name Develop relational schemas for the ER diagrams in Q$1,$ Q$2$ and Q$3$ on MS SQL Server. That is$,$ create a database in MS SQL Server for each question and then show your database structure in a diagram using SSMS$.$ You can choose any data type for each column in your tables. $(2)$ Set PKs and FKs$,$ and add referential integrity constraint for each FK$.(3)$ Each referential constraint line in the diagram must align with the corresponding PK and FK$.$ The layout should resemble the ERD in the question. Refer to the solution of the in$-$class tutorial in Week $4$ on D$2$L for an example. $(4)$ Set proper composite PKs for the M:N relationships or for the associative entities that don$$t have an explicitly specified identifier.