Question

When working with databases, you will find frequently that there is no documentation, data dictionary, data flow diagrams, etc., associated with a database especially an ERD. There are many reasons as to why this happens such as a business wants to keep this information proprietary, etc. However, SQL Server provides a way to generate an ERD for a database it currently manages.

Create an ERD of the AdventureWorks2016CTP database, take a screen shot of it and attach it as a response to this CAT and let us know what you think of the capability built into SQL Server.

Answer 1

Sales dbo Person Schemas Sales Purchasing Person Production