Assignment: Chapter 10 Review Exercise 1-10
1. What is the Enterprise Manager in SQL Server? It is used to carry out the most common administrative tasks, including creating databases, indexes, and other database objects. P301
2. What is the Tree pane used for? Shows the structure of your SQL Server enviorment.
3. What are the data types available in SQL Server? Text, varchar, char, ntext, nvarchar, nchar, bigint, int, smallint, tinyint, bit, numeric, decimal, float, real, datetime, smalldatetime, timestamp, money, smallmoney, varbinary, binary, image, there are also less commonly used datatypes.
4. What is a reserved word? A word that has special meaning in SQL cannot be used to name objects. P305
5. What is the purpose for a check constraint for a column? A setting for a column where you can specify a condition that data values must conform to when being inserted into the column. P306
6. How is primary key specified? First, create a database diagram go to table view then right click the field and chose ?Set Primary Key'. P306-309
7. What is the datasheet view used for? It is used to enter data into the database. P310
8. How is a relationship created in SQL Server? First, the FK and PK must have the same column widths and data types. Relationships are created from the table design view, right click the FK and chose relationships from the menu. Next click the relationships tab. Click the new button, make sure you have the parent table chosen as the primary key of the table and same for child table with its FK. Next you must select the PK of the table from the grid underneath ?Primary Key Table', then select its matching FK field in the child table. P316
9. How is a concantenated primary key specified? Simply highlight all the columns ...