IST 359 Lecture Notes - Lecture 2: Sql Server Management Studio, Microsoft Sql Server, Database

• School: Syracuse University
• Department: Information Studies
• Course: IST 359
• Professor: nosky

Document Summary

Part 1: relational basics and the physical model. In this lab we will learn the about the relational database model and how it is put into practice using the microsoft sql server instance on the ist students server. By the time the lab is complete you should be able to: Connect to microsoft sql server and log-on to your database and use its basic capabilities. Explain the basic concepts of the relational model. Explain the importance of entity integrity and referential integrity. Describe how and when to use logical domain to constrain and clean data input. Demonstrate how to create database objects and enter data on sql server. Describe the characteristics of good naming conventions and explain why they are important. To complete this lab, you will need: your ist students logon and password from our previous lab, sql server 2014 management studio (or sql server management studio express) so that you can connect to your sql server database.