You created the relational schema for the MVCH database. Next, you will develop the specification for database implementation. Specifically, you need to identify and document choices regarding the properties of each data element in the database, using the information provided in the case segments and options available in SQL Server (or other DBMS you may be using for this assignment).

Review the information provided in the case segments and identify the data type for each field in the database.

• Do you see any opportunities for user-defined data types? Which fields? Why?

• Are any fields candidates for coding? If so, what coding scheme would you use for each of these fields? • Which fields may take on a null value? Why?

• Which fields should be indexed? What type of index?