Database Creation and Design Implementation

Take a database design from Visio to SQL Server. This is the typing method vs. running a SQL file to create the DB objects. Quick overview of design in Visio and then how to create a database and tables in SQL Server including datatype assignment and primary key designation. There are a few minor design flaws that are included so that in subsequent SQL exercises the minor flaws will become evident. For the most part this is limited to the Rating table field names. #databasecreation, #databaseimplementation

Category